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

Unanswered

How to find the link between sales order to production orders

(1) Share

Report

Posted on by Samantha73

2,663

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

All responses (4)

Answers (0)

Samantha73

2,663 on at

Like (0)

Report

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.

false

FG1

-1

Reservation

FG1 BOM

2024-04-01

101012

10000

2024-03-29

2024-04-01

-1

Order-to-Order

false

Unlimited

-1

false

None

false

true

FG1

Reservation

FG1 BOM

2024-04-01

5406

101001

10000

2024-03-29

2024-04-01

Order-to-Order

false

Unlimited

false

None

false

Valentin Castravet 26,793 Super User 2025 Season 1 on at

Like (2)

Report

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Tarik Jerkovic 109 on at

Like (1)

Report

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 15,334 Most Valuable Professional on at

Like (0)

Report

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