Skip to main content
Solved

How to Add Shipment Ref # on my Invoice Summary


Hi, Everyone.

 

Newbie here. Can someone pls help me how to add the Shipment Ref # on my Invoice Summary pls.

 

Thank you,

Jay

 

 

Best answer by Naveen Boga

Hi @guintojoeyjay It requires a customization to display the “Shipment Nbr” in the Invoices header section and this customization should also covers the below scenarios.

  • Single SO → Single Shipment  #1001→ Invoice Header field will show #1001
  • As part of Acumatica standard functionality, we can add multiple Sales Orders using “Add Order” grid button.
    • Single Sales Order may have multiple Shipments
    • Multiple SOs with multiple Shipments.
  • In this case, make sure that customization should display Shipment Nbrs with comma(,) separated values in the Invoices screen.

View original
Did this topic help you find an answer to your question?

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3382 replies
  • Answer
  • July 6, 2021

Hi @guintojoeyjay It requires a customization to display the “Shipment Nbr” in the Invoices header section and this customization should also covers the below scenarios.

  • Single SO → Single Shipment  #1001→ Invoice Header field will show #1001
  • As part of Acumatica standard functionality, we can add multiple Sales Orders using “Add Order” grid button.
    • Single Sales Order may have multiple Shipments
    • Multiple SOs with multiple Shipments.
  • In this case, make sure that customization should display Shipment Nbrs with comma(,) separated values in the Invoices screen.


Hi @Naveen B . Where do I begin doing the customization pls?

 

Thank you,

Jay


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3382 replies
  • July 6, 2021

Since you want to display Shipment Nbr Invoices screen, please extend the DAC of ARInvoice and add a new field.

Then extend SOInvoiceEntry graph to have a logic to bring the Shipment Nbrs to display the header section.


@Naveen B is it the same logic if I wanted to add shipment # on my Sales Order Screen summary? Or If I want to show my SO# on my shipment screen?

 

Thank you,

Jay


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3382 replies
  • July 6, 2021

It will be bit different.. below is the simple logic.

In the ARTran table anyways you have the “Shipment Nbr”, so just loop through the grid records and populate the values in the header section.

string shipmentnbrs = string.Empty;

foreach (ARTran ObjTran in Base.Transactions.Select())
{

   if (ObjTran != null)
      { 
         shipmentnbrs += ObjTran.SOShipmentNbr + ", "; 
      }  
 }        
      
// add this Shipmentnbrs values to the extended ARInvoice DAC field  
                    


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings