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

Announcements

No record found.

News and Announcements icon
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,297
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,555 Most Valuable Professional on at
    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

    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 32,152 Super User 2026 Season 1 on at
    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,297 on at
    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

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 February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans