Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Unanswered

How to find the link between sales order to production orders

Posted on by 2,437
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
  • Samantha73 Profile Picture
    Samantha73 2,437 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    
  • Valentin Castravet Profile Picture
    Valentin Castravet 24,824 Super User 2024 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.
     
     
     
     
  • Tarik Jerkovic Profile Picture
    Tarik Jerkovic 92 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.
     
     
  • gdrenteria Profile Picture
    gdrenteria 12,183 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

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans