web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Join between purchase ...
Microsoft Dynamics GP (Archived)

Join between purchase order and shipment

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Tom Mathew Profile Picture
    Tom Mathew 1,750 on at

    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.

  • VJ Shah Profile Picture
    VJ Shah 373 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    Thanks, I had a feeling this was going to be the answer but was hoping for a more simple join.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans