Skip to main content
Solved

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

  • Jan 19, 2021 1:34 PM UTC
  • 6 replies
  • 696 views
  • Translate All

BellCo
Freshman I

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

@dwilkins97 

 

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

 

Hope this helps!!

 

View original

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Jan 19, 2021 2:51 PM UTC

Hi @dwilkins97 

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

 

 

Translate

BellCo
Freshman I
  • Author
  • Freshman I
  • Jan 19, 2021 3:00 PM UTC

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

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • Jan 19, 2021 3:51 PM UTC

@dwilkins97 

 

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

 

Hope this helps!!

 

Translate

BellCo
Freshman I
  • Author
  • Freshman I
  • Jan 19, 2021 3:56 PM UTC

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

Translate

  • Freshman I
  • Nov 9, 2023 3:23 AM UTC

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

Translate

dgodsill97
Varsity I
Forum|alt.badge.img+6
  • Varsity I
  • Apr 17, 2026 3:31 PM UTC

The SOLineSplit is updated with PO Receipt number when the PO is received so you can relate the receipt to the original PO Line of Line Split is the PO Line is linked to multiple SO Line Splits.

Translate