+2
Hi,
I am trying to pull the Sales Order number onto the Purchase Order Form (PO641000) for Drop Ship SO’s & Purchase Orders.
I can’t find the tables to link to from the PO Line to get the Sales Order#.
In the SO I can click on the PO Link
On the PO I can click on the View SO Demand.
Can anyone point me in the right direction for this?
Thanks Bill
Best answer by Neil Cantral
View original
+3
SOLinesSplit will have the fields needed to create the relation between purchase order and sales order details. (POType, PONbr, POLineNbr, etc.)
+17
Yes, As Neil said, we can get the PO details from SOLineSplit talbe. just attaching screenshot for reference.
+2
Thank you for the assistance!
It worked like a charm!
This is not working for me for some reason. It’s really puzzling. The joins look right and I know that there are thousands of Mark For PO’s but it only returns one record.
I look at the SOLineSplit DAC and see plenty of records. Can you verify that the joins are correct? Inner returns the same single record.
+1
Try:
POOrder (Parent) Left Join POLine (Child)
OrderType = OrderType
OrderNbr = OrderNbr
POLine (Parent) Left Join SOLineSplit (Child)
OrderType = SOLineSplit.POType
OrderNbr = SOLineSplit.PONbr
LineNbr = SOLineSplit.POLineNbr
Tested this in a GI and it is working.
I would also add a parameter to only show results for POLine Type “Goods for SO” operator “Or” “Goods for Drop-Ship” check the box “From Schema” to see the drop down selection options.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
