Allocating the inventory and production orders to the Sales order lines

(0) Share

Report

Posted on by Juan Montoya

Hi Everyone,

We need some help for designing a solution for the below requirement.

Consider a Make-to-stock fashion industry. We create production orders (coming from firming planned orders, created by MRP run for the item forecast). Then we create sales orders and fixed the delivery date.

**Now we need to find a best solution for finding and allocating the best fulfilment (on-hand stock or production order) for the sales lines as per the sales delivery date and customer & order priority. (Allocating means reserving, marking, or any other way. Take the below information into the account:

1. We wanted to see what sales order lines are available from on-hand inventory, then what's available from production and finally what's sold out.

2. we need to prioritze sales order by customer & order priority

Thanks in advance

Categories:

Production Control

Planning

Inventory and warehouse management

Vendor Experiences

All responses (3)

Answers (0)

Juan Montoya 15 on at

Like (0)

Report

RE: Allocating the inventory and production orders to the Sales order lines

Hi Hana

Thanks so much for your response, however, In my D365 F&O, i'm unable to use the explosion functionality
AliceBarendregt 1,470 on at

Like (0)

Report

RE: Allocating the inventory and production orders to the Sales order lines

Hi Juan,

From an ISV point of view you might want to have a look at the following:

bluehorseshoe.atlassian.net/.../Reservation Template

bluehorseshoe.atlassian.net/.../Dynamic Marking Template

The above ISV will give you the possibility to specify when a reservation/marking should occur, what the priority should be taken customer accounts/groups into account etc.

From a base D365 point of view you could maybe check whether you can trigger the reservation when running the release to warehouse job. You could subsequently check whether you can configure multiple batch jobs which will subsequently run in sequence after each other. The customer groups or other order priorities is something you subsequently should configure via the the RTW batch job queries.
Hana Xue 7,156 Microsoft Employee on at

Like (0)

Report

RE: Allocating the inventory and production orders to the Sales order lines

Hi Juan,

Maybe you can try to use the Explosion button from product and supply on the sales order line. to trace by clicking the Update button (. Once the trace has completed, the Explana.on tab on the explosion screen provides users with the step-by-step explanations. Or you can consider creating the production order from sales order line.

The related questions and discussions found for you are in the following links. Hope it will be helpful.

Marking a production order to a sales order - Microsoft Dynamics AX Forum Community Forum

production order from sales order - Dynamics 365 Supply Chain Management Forum Community Forum

Best Regards,

Hana