Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested answer

How come my Formula material item substitution (plan group & priority) is not working in Dynamics 365?

(0) ShareShare
ReportReport
Posted on by 314

Hi Expert!
My goal is to substitute items material in case there is insufficient stock at the time the Batch Order is created.

I have a setup in the Item Formula, where the 2 component items in the formula I give the same Plan Group 'Additive' and Priority 1 and 2. (img 1)

5140.pastedimage1628655197931v1.png

When a Batch Order is created, the Item material which Estimated qty is filled is the first item. Even though the first material has no stock, and the second material has stock. (img 2)

6403.pastedimage1628665390147v1.png

I feel that I have taken the right steps in setting the Plan Group and Priority in the Formula.
But the results that appear in the OP's Formula are not as expected.

Is there a step that is missing or not quite right? Please advice and solutions.

Regards,
Antony

  • Suggested answer
    Michael Antony Profile Picture
    314 on at
    RE: How come my Formula material item substitution (plan group & priority) is not working in Dynamics 365?

    Actually it is working, I have missed the actual substitution that is working in the other Planned Batch Order

  • WillWU Profile Picture
    22,352 on at
    RE: How come my Formula material item substitution (plan group & priority) is not working in Dynamics 365?

    Moved to SCM forum.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans