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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to associate a sal...
Small and medium business | Business Central, N...
Suggested Answer

How to associate a sales order with a production order

(0) ShareShare
ReportReport
Posted on by How to associate a ... 5

Hi,

I need to build a report in Excel where I can get all my Production Orders related to its sales order.

Here an exemple. 

pastedimage1683729157858v3.png

I currently use Jet reports for that, and I try to link "Sales header" with "Reservation Entry" and "Prod. Order Line" however,  I don't have any success.

Any suggestion? 

Thank you  

I have the same question (0)
  • Suggested answer
    Earl98 Profile Picture
    Earl98 154 on at
    RE: How to associate a sales order with a production order

    do all sales lines already have reservations? If so, you can pull data from reservation entries table:

    Reservation Status Item No. Location Code Quantity (Base) Reserved For Reserved From Entry No. Transferred from Entry No.
    Reservation FG1654 YELLOW -1 Sales Order 1035 Prod. Order Line Firm Planned 101007 115 0
  • How to associate a sales order with a production order Profile Picture
    How to associate a ... 5 on at
    RE: How to associate a sales order with a production order

    Hi Earl W,

    Unfortunately, I need more fields from Prod. Order Line table.

    In addition, I need to use Reservation Entry table because I am not an expert in Jet, and I don't know if it exists another way to associate the Prod. Order with the sales orders.

    Any suggestions are more than welcome. :)

    Thanks!

    DR

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans