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... / Demand forecast on pla...
Small and medium business | Business Central, N...
Suggested Answer

Demand forecast on planning worksheet not deducting existing inventory

(2) ShareShare
ReportReport
Posted on by MS-03120953-0 463
Hi 
We do not use locations for the demand forecast
The planning worksheet for purchase and assembly orders does not deduct existing inventory e.g our demand forecast for Sept 2024 is 1000, existing inventory is 200. The planning worksheet indicates we need to order 1000
 
 
I have the same question (0)
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,169 Super User 2026 Season 1 on at
    Maybe this will help clarify things.
     
    When using demand forecasts in the planning worksheet, the system calculates supply based on net requirements, but this depends on how your forecast setup and item planning parameters are configured.
     
    If you’re not using locations, make sure:
     
    The forecast is entered under the blank location (not a specific one).
     
    The item’s planning parameters (like reorder point, safety stock) don’t override available inventory.
     
    You're running "Calculate Plan" with the correct filters and include forecast option checked.
     
     
    If everything looks right and it still suggests 1000, the system might be ignoring inventory due to setup — review item planning fields like Lot Accumulation Period or Include Inventory settings.
     
    Mark this as the verified answer if it helps. Let me know if you want help reviewing the setup.
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    Can Demand forecast work for Assembly Item

    Solved: Demand forecasting

    Best Regards
    Gerardo

  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans