Forecast-Based Item Planning Update for Microsoft Dynamics 365 Business Central
Not every company plans from a demand forecast. Many run on reorder points and maximum inventory, and those values go stale as demand changes.
Enhanced Forecasting Worksheet uses the forecast to calculate safety stock, reorder point, reorder quantity, and maximum inventory, then writes them to item cards in one step with Update Item Planning.
How Forecast-based item planning update works in Enhanced Forecasting Worksheet
- The planner calculates a forecast for the period the values should cover, such as the next quarter.
- The worksheet shows calculated planning values for each item.
- The planner reviews the values and adjusts expressions or results if needed.
- The planner chooses Update Item Planning to write the values to the items.
Key capabilities
Calculated on each row
Each forecast row shows calculated safety stock quantity, reorder point, maximum inventory, and reorder quantity beside the predicted value.
Your formulas
The calculations come from planning expressions on Enhanced Forecast Setup, for example reorder point as average daily forecast times lead time in days.
One action
Update Item Planning writes the calculated values to the item card, or to the stockkeeping unit.
Forecast-driven, not forecast-dependent
Planning keeps running on reorder points and maximums, but those values now reflect the forecast instead of an old estimate.
Review with Excel if needed
Results can be exported to Excel for review, then applied.
See Forecast-based item planning update on screen
Real screens from Enhanced Forecasting Worksheet, shown with demo data.
Details that matter on the floor
Two outcomes from one forecast
The same forecast can feed the demand forecast or set planning parameters. Teams that do not use demand forecasts still get value from the prediction.
Same values a planner would set
The fields updated are the ones on the item's Planning FastTab, so planning behaves as before with fresher numbers.
Who uses Forecast-based item planning update
Inventory managers
Refresh reorder points and maximums from the forecast each period.
Purchasing managers
Order against reorder points that reflect expected demand.
Supply chain planners
Use the forecast without moving to demand-forecast planning.
Questions about Forecast-based item planning update
Can Business Central set reorder points from a forecast?
With Enhanced Forecasting Worksheet, yes. The worksheet calculates safety stock, reorder point, reorder quantity, and maximum inventory from the forecast using your formulas, and Update Item Planning writes them to item cards.
Which fields are updated?
Safety stock quantity, reorder point, reorder quantity, and maximum inventory on the item, or on the stockkeeping unit.
Do I have to use the demand forecast as well?
No. Update Item Planning is an alternative to Update Demand Forecast. Use either or both.
Is there a tool to review planning values against past usage?
Yes. Item Planning Review, also in Enhanced Planning Pack, shows average usage beside each item's planning parameters.
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 Forecast-based item planning update?
Send us a note and the Enhanced Forecasting Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
