Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Item Substitution - Substitute Item with Different QTY in BOM

(0) ShareShare
ReportReport
Posted on by 15,437

Hi

Let say we have item A and B and we can substitute them with each other in production BOM. But if we substitute item B we use half of what we have as usage of Item A. is it anyway to set this substitution up this way? 

Example 

For finish part C

BOM

Part A   usage QTY 1 

But if we substitute with part B usage QTY is .5 

Thanks 

  • MahGah Profile Picture
    15,437 on at
    RE: Item Substitution - Substitute Item with Different QTY in BOM

    Thanks Steve .

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Item Substitution - Substitute Item with Different QTY in BOM

    MahGah,

    You are correct. If you want the Substituted Item to change the Qty. Per value, based on the Item, you will need a customization.

    Thanks,

    Steve

  • MahGah Profile Picture
    15,437 on at
    RE: Item Substitution - Substitute Item with Different QTY in BOM

    Hi Steve 

    Thanks for answer. 

    Just to summarize what you mentioned : it is no automated way (beside maybe customization) to change the substitute QTY based on part. User must manually change that QTY? 

    Thanks again 

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Item Substitution - Substitute Item with Different QTY in BOM

    MahGah,

    You can perform the component substitution process and alter the Qty. Per value. Here is an over view of the process (NOTE: I used my old NAV pictures as the process overall has not changed)

    There are times in a manufacturing company where substitute items that are not on the Bill of Material are OK to use if the preferred item is not available. Often this substitution has to be approved by an engineer and is usually in the form of a ‘Usage Variance’. If substitutions are a common event, it might be useful and time saving for the engineering department to set up ‘Item Substitutions’ ahead of time so that an individual variance doesn’t have to be approved and signed each time.

    To set up a Substitution in Dynamics, go to the Item Card for which a substitute is available.

    pastedimage1619535749205v2.png

    Figure 1 – Item Substitution entry

    Then enter the item number that is OK to be used as a substitute.

    pastedimage1619535749206v3.png

    Figure 2 – Enter the item number of the item that can be used as a substitute

    Now, go to the component list of a production order and select the substitution that was approved by the engineering department.

    pastedimage1619535749206v4.png

    Figure 3 – From the component list of production order…

    pastedimage1619535749206v5.png

    Figure 4 - …select the approved substitution

    The production order component list now contains the substituted item. You can update the Qty Per if necessary.

    pastedimage1619535749206v6.png

    Figure 5 – The production order component list shows the substitution

    pastedimage1619535922783v7.png

    The above pic come from a Released Prod. Order, component page to Select Item Substitution.

    Hope this helps.

    Thanks,

    Steve

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,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,013 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans