Skip to content
Enhanced Forecasting Worksheet app iconEnhanced Forecasting WorksheetFeature

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

  1. The planner calculates a forecast for the period the values should cover, such as the next quarter.
  2. The worksheet shows calculated planning values for each item.
  3. The planner reviews the values and adjusts expressions or results if needed.
  4. 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.

Enhanced Forecasting Worksheet app icon

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.

Ask a product question

Product Questions