Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Join between purchase order and shipment

Posted on by Microsoft Employee

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.

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    VJ Shah 371 on at
    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 Profile Picture
    Tom Mathew 1,750 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans