Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Allocating the invento...
Supply chain | Supply Chain Management, Commerce
Unanswered

Allocating the inventory and production orders to the Sales order lines

(0) ShareShare
ReportReport
Posted on by Juan Montoya 15

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 

  • Juan Montoya Profile Picture
    Juan Montoya 15 on at
    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 Profile Picture
    AliceBarendregt 1,470 on at
    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 Profile Picture
    Hana Xue Microsoft Employee on at
    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.

    pastedimage1681179935816v1.pngpastedimage1681179951935v2.png

    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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,983 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans