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 find the link b...
Small and medium business | Business Central, N...
Unanswered

How to find the link between sales order to production orders

(1) ShareShare
ReportReport
Posted on by Samantha73 3,245
Hi All
Currently using production orders with make to order setting using planning worksheet. What is the best way to find out the link between sales order and the production order? Is table 337 contain all the data for this or is there another easier way as 337 table difficult to work with.
Thanks
I have the same question (0)
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,078 Most Valuable Professional on at
    How to find the link between sales order to production orders
    Hi
    I certainly remember that connection mentioned. Table Relation between Sales Order and Firm Production Order (dynamics.com)
    Then I have seen that there are some apps that, in addition to other facilities, give you other possibilities. Create a Soft Link Between a Sales Order and Production Order in Sabre Production (youtube.com)
    BR
    GR
  • Tarik Jerkovic Profile Picture
    Tarik Jerkovic 111 on at
    How to find the link between sales order to production orders

    Hi,

    You can easily find the Production Order created from a Sales Order. Just go to the Sales Line in the Sales Order, then click on Related Information and select Reservation Entries. There, you will see all related Sales and Production Orders.

     

     
    I hope so you will easy find. Also we have another solution to find connected/related Sales and Prod Order.
     
     
  • Valentin Castravet Profile Picture
    Valentin Castravet 31,262 Super User 2025 Season 2 on at
    How to find the link between sales order to production orders
    If your item is make to order and you created a prod. order, you can use the following: in the sales order go to Actions -> Plan -> Planning -> Order Tracking. The order tracking page will display the prod. order no. From there you can click Show to open it.
     
    This is all possible out of the box.
     
     
     
     
  • Samantha73 Profile Picture
    Samantha73 3,245 on at
    How to find the link between sales order to production orders
    Thanks for the suggestions and it works from the front end however from a reporting point of view how to connect SO to Prod order. See attached for the reservation entry table after 1 entry as a test
     
    RESERVATION_ENTRY Reservation Entry 337                                                                                
                                                                                         
    Entry No. Positive Item No. Location Code Quantity (Base) Reservation Status Description Creation Date Transferred from Entry No. Source Type Source Subtype Source ID Source Batch Name Source Prod. Order Line Source Ref. No. Item Ledger Entry No. Expected Receipt Date Shipment Date Serial No. Changed By Qty. per Unit of Measure Quantity Binding Suppressed Action Msg. Planning Flexibility Appl.-to Item Entry Warranty Date Expiration Date Qty. to Handle (Base) Qty. to Invoice (Base) Quantity Invoiced (Base) New Serial No. New Lot No. Disallow Cancellation Lot No. Variant Code Appl.-from Item Entry Correction New Expiration Date Item Tracking Untracked Surplus Package No. New Package No.
    1 false FG1   -1 Reservation FG1 BOM 2024-04-01   37 1 101012   0 10000   2024-03-29 2024-04-01     1 -1 Order-to-Order false Unlimited 0     -1 -1 0     false     0 false   None false    
    1 true FG1   1 Reservation FG1 BOM 2024-04-01   5406 2 101001   10000 0   2024-03-29 2024-04-01     1 1 Order-to-Order false Unlimited 0     1 1 0     false     0 false   None false    

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