Copy Custom Field From Sales Order To Invoice When Invoice Created

Hi @TimMarkiw  In the Invoices screen, we have a feasibility to add the Multiple Orders to the Single Invoice. In this case, you wanted to display comma-separated values in the Invoice header section.

Hello Naveen,

We will always only put a single sales order on a single invoice so i only need to know how to copy the GTRInvoice field exactly as it is in the sales order being invoiced. 

Thanks

Hi @TimMarkiw ,

You can use below code snippet to pass custom field from SO to invoice.

    public delegate void PersistDelegate();

        [PXOverride]
        public void Persist(PersistDelegate baseMethod)
        {
            baseMethod();
        SOOrderEntry soOrderEntryGraph = PXGraph.CreateInstance<SOOrderEntry>();

        SOOrder soOrder = soOrderEntryGraph.Document.Current;

            if (soOrder != null)
            {
                ARInvoice arInvoice = new ARInvoice();

                // Copy the custom field value from Sales Order to Invoice
                arInvoice.GetExtension<ARRegisterExt>().UsrCustomField = soOrder.GetExtension<SOOrderExt>().UsrCustomField ;

                Base.ARInvoice_CustomerID_DocType_RefNbr.Cache.Insert(arInvoice);
            }
        }

Hope, it helps!

Regards,

Sweta

@sweta68 

Hello Sweta,

I haven’t gotten this to work yet but I wanted to give you an update.

When I add this code

   public delegate void PersistDelegate();

        [PXOverride]
        public void Persist(PersistDelegate baseMethod)
        {
            baseMethod();
        SOOrderEntry soOrderEntryGraph = PXGraph.CreateInstance<SOOrderEntry>();

        SOOrder soOrder = soOrderEntryGraph.Document.Current;

            if (soOrder != null)
            {
                ARInvoice arInvoice = new ARInvoice();

                // Copy the custom field value from Sales Order to Invoice
                arInvoice.GetExtension<ARRegisterExt>().UsrGTRInvoice = soOrder.GetExtension<SOOrderExt>().UsrGTRInvoice ;

                Base.ARInvoice_CustomerID_DocType_RefNbr.Cache.Insert(arInvoice);
            } else
              {

                }
        }

to the SOInvoiceEntry the code compiles, published and runs, however the GTRInvoice was not copied across and the soOrder is always null so the if condition is never fulfilled. I added the else for testing and the code within it was always the code that was executed.

I am going to continue to try more things this afternoon and I will let you know if works or if I need further help.

Thank You!

Your SOOrder will always be null because soOrderEntryGraph.Document.Current is null in a newly created graph instance.

Use:

SOOrder order = soOrderEntryGraph.Document.Search<SOOrder.orderType, SOOrder.orderNbr>(order.OrderType, order.OrderNbr, order.OrderType);

Here is my final code mostly taken from a post by @darylbowman  

  public static string GTRInvoiceNumber = "";
    #region Event Handlers
      public delegate IEnumerable PrepareInvoiceDelegate(PXAdapter adapter);

      [PXOverride]
      public IEnumerable PrepareInvoice(PXAdapter adapter, PrepareInvoiceDelegate baseMethod)
      {
        PXGraph.InstanceCreated.AddHandler<SOInvoiceEntry>((graph) =>
        {
          graph.RowPersisting.AddHandler<ARInvoice>((cache, e) =>
          {
            var invoice = e.Row as ARInvoice;
            if (invoice is null) return;
            string gtrInvoiceNumber = GTRInvoiceNumber;
            cache.SetValue<ARRegisterExt.usrGTRInvoice>(invoice, gtrInvoiceNumber);
            cache.Update(invoice);
          });
          graph.RowInserted.AddHandler<ARTran>((cache, e) =>
          {
            var tran = e.Row as ARTran;
            if (tran is null) return;
            var invoice = graph.Caches[typeof(ARInvoice)].Current as ARInvoice;
            ARRegisterExt registerExt = invoice.GetExtension<ARRegisterExt>();
            SOOrderExt orderExt = Base.Document.Cache.GetExtension<SOOrderExt>(Base.Document.Current);
            GTRInvoiceNumber = orderExt.UsrGTRInvoice;
          });
        });
        return baseMethod(adapter);
      }
    #endregion

Thank you all for your help.