Join between purchase order and shipment

(0) Share

Report

Posted on by Community Member Microsoft Employee

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.

7571.SnipImage.JPG

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

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Join between purchase order and shipment

Thanks, I had a feeling this was going to be the answer but was hoping for a more simple join.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Join between purchase order and shipment

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.
VJ Shah 371 on at

Like (0)

Report

RE: Join between purchase order and shipment

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.
Tom Mathew 1,750 on at

Like (0)

Report

RE: Join between purchase order and shipment

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.