You’re offline. This is a read only version of the page.
Hi
I wondering where the join between purchase order line and shipment line is, I've looked through all of the fields in the tables below.
In this case, the second line on POP10110 has a sequence number of 32768, but if you ship the second line first then the sequence number on the shipment is 16384. I know you could you the item number in the example, but that's not reliable as some people use the same item number on multiple lines of the purchase order. Surely there is a join somewhere?
Thanks
*This post is locked for comments
Thanks, I had a feeling this was going to be the answer but was hoping for a more simple join.
As I mentioned in my first post, item number works for my test example above, but in production it won't as the same item number is repeated. Basically, we use a third party purchasing application where line comments are attached to the purchase order only. I'm trying to build an expense report, it is the shipment that hits the P&L, but return the line comment from the purchase order. If they have repeated the same item number multiple time on the purchase order, with different line comments, this logic doesn't work.
The Purchase Order Line table POP10110 and Receipt Line table POP30310 are linked thru the Receipt Line Quantities table POP10500. However, you do not want to just directly join them. You will want to first aggregate the lines into a total by PO Line Number and sum the Quantity Shipped and Invoiced. Hope this helps.
You can use PO Number, Item Number and Quantity in case the same item has been entered multiple items with different quantities. If the all the above 3 fields are same what difference it is going to make and use the PO Number & Item No instead.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (