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

Community site session details

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

Planning Worksheet Problems!

(1) ShareShare
ReportReport
Posted on by 254

Hello everyone,

I hope you're doing well.

I’ve been working with the 'Calculate Regenerative Plan' in Business Central and have already defined the necessary SKUs. When I run the plan without any filters, I expect to see all material requirements and MPS; however, it doesn't generate some items as anticipated. Based on the released production order, BOM and the current inventory in the location, system should generate a shortage plan!

But without filtering, the planning engine cannot generate the above items. (The date in planning covers released production order date range!)

here is the result without filter! The above items cannot be generated!!

 

Interestingly, when I apply filters for specific items, the system generates the filtered items correctly—except for one. When I filter for this particular item alone, the system does generate the shortage, which makes the behavior seem inconsistent.

 

When I use filter, the system can generate but without cannot!!

I am using Business Central on the cloud, and this seems unusual, possibly a bug. Has anyone else encountered this issue or have suggestions on what might be happening?

Thank you in advance for your help!

Best regards,

 
 
 
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    28,392 Super User 2025 Season 2 on at
    Planning Worksheet Problems!
    It would help us if you provided pictures of your item/sku set up.
     
  • Suggested answer
    Ben Baxter Profile Picture
    6,150 Super User 2025 Season 2 on at
    Planning Worksheet Problems!
    First, ensure "Dynamic Low-Level Code" is enabled in your Manufacturing Setup.  Next, run the "Calculate Low-Level Code" function.  Finally, re-run your planning without filters and see if you get the desired results.
     
    I can't be sure this will address your issue, but without having access to the data this would be the first thing to check.  If your Items have the wrong level assigned they will not pick up all demand during planning, but it would work when doing a single item plan (as all other demand is in place at that time).
     
    Hopefully this helps resolve your issue.  If not, reach out to your Business Central partner who can review the data to troubleshoot your issue.  99.9% of planning issues are data related.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    19,004 Super User 2025 Season 2 on at
    Planning Worksheet Problems!
    You're experiencing an issue with the 'Calculate Regenerative Plan' in Business Central, where certain material requirements and shortages are not generated without filters, but work correctly when filters are applied. To address this, check the planning parameters, item setups, and released production orders for accuracy, and ensure inventory levels are correct.
  • Gerardo Rentería García Profile Picture
    22,526 Most Valuable Professional on at
  • CU07101338-0 Profile Picture
    254 on at
    Planning Worksheet Problems!
    Hi,
    I've added some more details with my question. 
    Thanks in advance!
     
  • Jun Wang Profile Picture
    8,152 Super User 2025 Season 2 on at
    Planning Worksheet Problems!
    The description of the issue is quite general. Planning worksheet looks at parameters set up from different places. BC also looks at supply and demands. If you provide one item as example, and explain the setups, expected behaviors, and actual behavior, experts might be able to offer more specific insights/solutions. 

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,678 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,635

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,210

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans