web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Drill down production ...
Small and medium business | Business Central, N...
Suggested Answer

Drill down production item to calculate purchase items in BOM

(1) ShareShare
ReportReport
Posted on by LF-16052033-0 605
Hello experts, 
 
We are struggling with how to calculate planning for our sub-assembly production items. How do we use the demand forecast to predict how many sub assemblies we want to produce for the week to have the system calculate how much we need to purchase for all of our buy items for the sub assembly?
 
Does the planning worksheet calculate and drill down from the production bom into the components that make up the finished product?
 
 
I have the same question (0)
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 7,079 Super User 2026 Season 1 on at
    The Planning Worksheet will scan through every level of your Bill of Material.  It will suggest Prod. Orders for your Sub-Assemblies.  It will suggest Prod. Orders for your Sub-Sub-Assemblies.  It will suggest purchases for the materials at all levels based on all suggested Prod. Orders (finished or sub-components).
     
    Once you understand how strong the calculation is, you'll want to define how you want the results to be.  Do you want your sub-assemblies on their own Production Order or nested on the Parent Item's Prod. Order?
     
    Don't forget, all Items have their own Planning settings.  You don't have to use Fixed Reorder, Lot-for-Lot, or Order for ALL Items, you get to mix and match based on your rules for the Item.  Beyond that, you get to make those decisions based on each plant/warehouse (a.k.a. Location).
     
    I would strongly recommend you reach out to your partner for a review of the Planning capabilities within Business Central.  There are a lot of great features, but with flexibility can come different configurations to dial in the planning for your business needs.  There are a lot of great sessions available on YouTube as well.
     
    Hope this helps get you started!
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,122 Super User 2026 Season 1 on at
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 7,079 Super User 2026 Season 1 on at
    To add one more point to your question, "How do we use the demand forecast to predict how many sub assemblies we want to produce for the week", you generally build your Demand Forecast for your Finished Goods.  The forecast demand for the Finished Goods will determine which Sub-Assemblies are going to have demand, which in turn determines which purchased components are going to have demand.  You don't need to Forecast each level in your BOM, the system will see the subsequent lower-level demand created by the Finished Good's Forecast.
     
    Once you establish your Finished Goods Forecast, you are making a decision on HOW (stock vs. lean, etc.) to handle the demand generated for the sub-assemblies and purchased components.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,138 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,279 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,192

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans