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