Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : 5qz844jWXQqJUooqRPbAfm
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Planning Worksheet -- ...
Small and medium business | Business Central, N...
Suggested answer

Planning Worksheet -- Having to Use an Item Number Range

Like (5) ShareShare
ReportReport
Posted on 28 Mar 2025 14:34:19 by JE-20081519-0 1,229
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 
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar 1,991 on 29 Mar 2025 at 18:37:24
    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
    Khushbu Rajvi. 12,116 Super User 2025 Season 1 on 29 Mar 2025 at 07:00:04
    Planning Worksheet -- Having to Use an Item Number Range
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 3,170 on 28 Mar 2025 at 16:17:50
    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
    Mansi Soni 1,577 on 28 Mar 2025 at 15:33:16
    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

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February 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... 293,333 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,262 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans