In a Sales Order, add the linked Purchase Order in the Sales Order line. (SOline.PurchaseOrderNbr)

  • 19 January 2021
  • 5 replies

In a Sales Order, add the linked Purchase Order in the Sales Order line for each SO line item.  (SOline.PurchaseOrderNbr). 

If the PO Nbr was added in the SOLine DAC, you could have a Sales Order Generic Inquiry that listed Sales Orders with the associated PO for each line item in the Sales Order, thus enableing you to quickly check on Purchase Order when a customer calls to inquiry about a Sales Orders. Often, a Sales Order is assoicated with more than one Purchase Order and you would have the ability to display the associated PO with each line item on the SO.  


Best answer by Naveen Boga 19 January 2021, 16:51

View original

5 replies

Userlevel 7
Badge +17

Hi @dwilkins97 

PO information is already available in “SOLineSplit”. Please find the screenshot for reference.



Have you used SOLineSplit in a GI to have a PO column for each item line on a SO?

Userlevel 7
Badge +17



I just created sample GI by having PO columns, and find attached XML format GI.


Hope this helps!!


Thank you for the comments and for taking the time to look at this. 


I tried that inquiry that you are showing but I’m getting duplicate lines for the sales order. Has anyone successfully created a GI or a report that shows a Sales Order linked to a purchase order? Or better yet, we’d love to see the sales order linked to a purchase order and the receipt. 

And then from the sales order if we could also see any shipments related to it. 

So essentially a single report that shows the full life cycle of a sales order (from Linked PO all the way to shipments). 

Has anyone created something like this??


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved