Update Demand Forecast for Microsoft Dynamics 365 Business Central
A forecast that sits in a report does not change what planning suggests. For material requirements planning (MRP) and the master production schedule (MPS) to use it, the numbers have to be in Business Central's demand forecast.
Enhanced Forecasting Worksheet writes predicted values into a standard Business Central demand forecast that you choose, so planning picks them up like any other forecast.
How Update Demand Forecast works in Enhanced Forecasting Worksheet
- The planner calculates and reviews the forecast in Enhanced Forecasting Worksheet.
- The planner chooses Update Demand Forecast and picks the demand forecast to update.
- The planner confirms sending the predicted values.
- The demand forecast shows the new quantities by item and period, and the next planning run uses them.
Key capabilities
Standard demand forecast
Update Demand Forecast writes to Business Central's own demand forecast, the one shown in the Demand Forecast Overview matrix by item and period.
Your choice of forecast
The planner chooses which demand forecast to update, for example a planning forecast.
Confirm first
A message asks whether to send the predicted values to a demand forecast before anything is written.
Used by planning
Because the values are in the standard demand forecast, MRP, MPS, and planning tools such as Enhanced Planning Worksheet read them without extra steps.
Adjust before you send
Predicted values can be tidied in the worksheet, in Excel, or with planning expressions before the update.
See Update Demand Forecast on screen
Real screens from Enhanced Forecasting Worksheet, shown with demo data.
Details that matter on the floor
No custom planning path
The forecast lands in the standard place, so the rest of Business Central works as it always does.
Review before the plan sees it
The worksheet sits between Microsoft's forecast and the demand forecast, giving the planner a chance to check numbers first.
Who uses Update Demand Forecast
Supply chain planners
Load a reviewed forecast into the demand forecast for MRP and MPS.
Production planners
Plan production from forecast demand.
Purchasing managers
See forecast demand reflected in purchase suggestions.
Questions about Update Demand Forecast
How do I load a forecast into the Business Central demand forecast?
With Enhanced Forecasting Worksheet, calculate the forecast, choose Update Demand Forecast, pick the demand forecast to update, and confirm. The predicted values are written into that standard demand forecast.
Will MRP use the updated forecast?
Yes. Enhanced Forecasting Worksheet writes to the standard Business Central demand forecast, which MRP and MPS use when you run planning.
Can I check the numbers before they go into the demand forecast?
Yes. Results stay in the worksheet until you choose Update Demand Forecast and confirm, so you can review or adjust them first.
What if I do not want to use a demand forecast?
Use the forecast to set planning values instead. Update Item Planning writes calculated safety stock, reorder point, reorder quantity, and maximum inventory to item cards.
Related Enhanced Forecasting Worksheet features
All Enhanced Forecasting Worksheet features →Part of Enhanced Forecasting Worksheet
Precise, customizable inventory forecasting to prevent stockouts and optimize stock levels.
Have a question about Update Demand Forecast?
Send us a note and the Enhanced Forecasting Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

