Solved

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

  • 19 January 2021
  • 5 replies
  • 385 views
BellCo
Rank

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.  

icon

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

View original

5 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

@dwilkins97 

 

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

 

Hope this helps!!

 

1 Attachment
Naveen B
S
Rank

Hello,

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??

Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @dwilkins97 

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

 

 

Naveen B
BellCo
Rank

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

BellCo
Rank

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

Reply


Terms & ConditionsCookie settings
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