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

Planning Worksheet -- Having to Use an Item Number Range

(5) ShareShare
ReportReport
Posted on by 1,483
Hi:
 
If you want the Planning Worksheet to generate suggestions not just for a finished good but also for its subassemblies and those subassemblies' component part numbers, you have to enter all of those items as an Item Number range in the "Calculate Plan" screen.
 
If you enter only the finished good in the Item Number "range", only one suggestion generates and that one suggestion is only for that one finished good.
 
Is there not a way of capturing all of the items without having to specify all of the Item Numbers in the range?
 
Thanks!
 
John 
  • Verified answer
    Ramesh Kumar Profile Picture
    3,337 on at
    Planning Worksheet -- Having to Use an Item Number Range
    Hi John,
     
    I think best way tackle this issue is have 2 batch one for Finished and one sub assembly and defaulted to item range. I think some of the fields take default to last updated value.
     
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    14,482 Super User 2025 Season 1 on at
    Planning Worksheet -- Having to Use an Item Number Range
  • Suggested answer
    Jainam M. Kothari Profile Picture
    6,025 on at
    Planning Worksheet -- Having to Use an Item Number Range
    .Hello
     
    In Business Central, to generate planning suggestions for a finished good and its subassemblies, you usually need to enter all items as an Item Number range in the "Calculate Plan" screen. However, you can streamline this by setting up a reorder cycle, defining planning parameters for items or groups (including SKUs for item, variant, and location combinations), and ensuring correct low-level codes in the Bill of Materials (BOM). These methods help include all relevant items without manually specifying each item number.
     
  • Suggested answer
    Mansi Soni Profile Picture
    1,715 on at
    Planning Worksheet -- Having to Use an Item Number Range
    Hello John,

    In Business Central, the Planning Worksheet suggests orders based on the item numbers specified in the Calculate Plan screen. If you only enter the finished good, it will generate a suggestion for that item alone. To include subassemblies and components without manually specifying each item, ensure that dependent demand is triggered. This typically happens when items have a Production BOM and proper replenishment settings (like Make-to-Order or Make-to-Stock). Also, check Reordering Policies and Planning Parameters to ensure the system considers all required items automatically.

    https://learn.microsoft.com/en-us/dynamics365/business-central/walkthrough-planning-supplies-automatically
    https://learn.microsoft.com/en-us/dynamics365/business-central/production-about-planning-functionality

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

#2
Martin Dráb Profile Picture

Martin Dráb 232,892 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans