Skip to content
Enhanced Forecasting Worksheet app iconEnhanced Forecasting WorksheetFeature

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

  1. The planner calculates and reviews the forecast in Enhanced Forecasting Worksheet.
  2. The planner chooses Update Demand Forecast and picks the demand forecast to update.
  3. The planner confirms sending the predicted values.
  4. 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.

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 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.

Ask a product question

Product Questions