web
You’re offline. This is a read only version of the page.
close
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...
Suggested Answer

Manufacturing Bill of Materials - aggregate the total per item when loading into BC?

(3) ShareShare
ReportReport
Posted on by 178
If a Bill of Materials  has an Item (sub-assembly or actual item) that is used multiple times in the overall BOM even if used at different levels, do you have to aggregate the total per item (and possibly per level) before uploading the BOM to BC?
I had an example today whereby a subassembly is used 3 times at the same level and the it triplicated the quantity when I generated a Quantity explosion of the BoM and subsequently when I created a Prodn order, the component list quantity was triplicated as well. 
I have the same question (0)
  • Suggested answer
    Ben Baxter Profile Picture
    6,620 Super User 2025 Season 2 on at
    When you say, "a subassembly is used 3 times", are you referring to needing 3 of that sub-assembly as a component to a parent Item?  If so, you can either change the quantity to 3 or put three lines each with a quantity of 1 (this can have an impact on order-based planning).
     
    If you refer to "used" as a tool usage and not a component usage, you would list it in the Routing, not the BOM, so as to not consume the tool as a component.
     
    Lastly, since it sounds like you have multi-level BOMs, I would encourage you to run the "Calculate Low-Level Code" and ensure your Manufacturing Setup has enabled the Dynamic Low-Level Code.
     
    You may want to reach out to your partner who can actually login and see the data, as that is the best way to troubleshoot these types of processes.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    Sohail Ahmed Profile Picture
    11,150 Super User 2025 Season 2 on at

    Hope this might be helpful:

    No, you do not need to manually aggregate total quantities per item or level before loading a Bill of Materials (BOM) into Business Central.

    Business Central's standard BOM explosion logic is designed to automatically:

    • Aggregate quantities for the same component across different lines at the same BOM level.
    • Recursively aggregate quantities of components used in sub-assemblies (multi-level BOMs) into the top-level production order component list.
     

    Your observation of triplicated quantities during BOM explosion and Production Order creation indicates a setup error in your BOMs, where the component is likely listed multiple times with its individual quantity instead of a single line with the aggregated quantity at each specific BOM level.

    Example: If an item requires 3 screws, the BOM line for "screws" should be Quantity = 3, not 3 separate lines each with Quantity = 1. If a sub-assembly uses a component, and that sub-assembly is used multiple times, the system will correctly sum up the component usage.

    Action: Review and correct the structure of your BOMs to ensure each component is listed only once per parent item, with its total required quantity at that level.

    ✅ Mark this answer as verified if it helps you.

  • Suggested answer
    Ramesh Kumar Profile Picture
    7,529 Super User 2025 Season 2 on at
    Sorry if my understanding is incorrect here. When you say used 3 times at same level why don't you combine it. However I put links which might be useful if you learn about parent-child BOM
     
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 on at
    Sorry, maybe I didn't fully understand.. If you mean that Bom contains Bom, and the same item is contained in both the upper and lower levels,, the quantities for those will of course be combined. If you do not want to aggregate, or if the quantity is repeated, please split the quantity.
     
    Hope this helps.
    Thanks.
    ZHU

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans