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 :
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 76
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
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 19,137 Super User 2025 Season 2 on at
    Demand forecast on planning worksheet not deducting existing inventory
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 23,572 Most Valuable Professional on at
    Demand forecast on planning worksheet not deducting existing inventory

    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
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,086 Super User 2025 Season 2 on at
    Demand forecast on planning worksheet not deducting existing inventory
    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.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 4,304

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,045

#3
Sumit Singh Profile Picture

Sumit Singh 2,970

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans