A Business Central demand forecast is a set of expected quantities per item per period that the planning engine treats as demand before any sales order exists. Microsoft Dynamics 365 Business Central stores it on the Demand Forecast page and nets it against real orders during planning. The engine then proposes supply ahead of demand. This article explains how the standard forecast works, where it stops, and how safety stock and reorder points follow from it. It closes with what an enhanced forecasting worksheet adds for teams that want the numbers calculated rather than typed.
How does the standard Business Central demand forecast work?
The Demand Forecast page is a matrix: items down the side, periods across the top, and a quantity in each cell. A forecast has a name, and the Forecast by Location and Forecast by Variant settings decide how much detail it carries. Each entry has a Forecast Type of Sales Item, Component, or Both; Sales Item and Component entries are editable, and Both is an overview. A manufacturer can therefore forecast finished goods and also forecast components sold as spares. Microsoft Learn documents the page under the title Create a demand forecast, and states that “during creation of the Master Production Schedule (MPS), the forecast is netted against the sales and production orders.”
The netting is what makes a forecast safe to use. Suppose next period’s forecast for an item is 400 and sales orders for that period total 250. Planning sees 150 of remaining forecast demand plus the 250 of firm orders. As real orders arrive, they consume the forecast rather than stacking on top of it. A Sales Item forecast is netted only by sales orders, and a Component forecast only by dependent demand from production order components. Microsoft Learn’s Run Full Planning, MPS, or MRP describes MPS as the calculation for end items that have a forecast or a sales order line.
Two setup details matter in practice. First, the forecast period must line up with how the planner thinks, because each entry’s date marks the start of the period it covers. Second, the forecast is netted during MPS, so the MPS switch has to be on in the calculation request. A forecast entered against an item with a blank reordering policy does nothing at all.
Where does the built-in Business Central demand forecast stop?
The standard forecast is a container, not a calculation. Every cell is typed by a person or imported. Nothing in the Demand Forecast page looks at sales history, detects seasonality, or suggests a number. For a company with 50 stocked items and a rolling 12-month horizon, that is 600 cells to maintain. The numbers age the day they are entered.
Business Central does include a forecasting extension. The Sales and Inventory Forecast extension sends posted sales history to Microsoft’s Azure AI forecasting service. It displays the result as a forecast chart in the Item Forecast pane on the item, warns of a projected stockout, and can suggest a replenishment quantity when a purchase order is created. Setup lives on the Sales and Inventory Forecast Setup page, where the Period Type and Historical Periods fields shape the data sent, and the Timeseries Model field selects the algorithm. Microsoft’s own documentation notes that it forecasts all locations and variants together rather than per location. The knowledge base covers the Sales and Inventory Forecast setup steps as a prerequisite for the enhanced tools.
The limit of that extension is what it feeds. The chart shows one item at a time, and it writes nothing to the Demand Forecast page or to the item’s planning parameters. A planner can look at it, agree with it, and then still type the numbers by hand. The earlier article on why built-in inventory forecasting falls short in Business Central covers this gap in more detail.
How do safety stock and reorder points follow from a demand forecast?
A forecast is only useful when it changes a planning parameter or creates a supply order. The two parameters most often derived from it are Safety Stock Quantity and Reorder Point on the item’s Planning FastTab. Microsoft Learn describes both in its design details for planning parameters.
The arithmetic is not complicated:
- Average daily usage comes from the forecast (or from history) divided by the days in the period.
- Safety stock is average daily usage multiplied by lead time, sometimes with a further factor for variability. An item selling 20 a day with a 10-day lead time carries 200 as a starting safety stock.
- Reorder point is expected demand during the lead time plus safety stock. For the same item, that is 200 plus 200, so 400.
- Reorder quantity or maximum inventory follows from how often the company wants to order, for example two weeks of usage.
Business Central does not calculate any of these fields. It uses them. So the practical question for most companies is who does the calculation and how often. Doing it once in a spreadsheet at go-live is common. It is also how reorder points end up frozen for three years while the business changes underneath them. The MRP for Business Central hub explains how those parameters then drive the Planning Worksheet.
What does an enhanced forecasting worksheet add to a Business Central demand forecast?
The Enhanced Forecasting Worksheet from Insight Works turns the chart into a worksheet that can act. The knowledge base describes it as giving “more control over the interaction between results coming from Azure ML (as configured on the Sales and Inventory Forecast Setup page) and demand forecasts in Business Central,” and states plainly that the worksheet “does not replace Microsoft’s forecasting engine.” What changes is scope and output.
A forecast run is configured rather than fixed. The planner sets an item filter or item category, a single location, and a period type. The run also takes the number of forecast and past periods, a confidence level, and a forecast algorithm drawn from the Timeseries Model options on the Sales and Inventory Forecast Setup page. Each result line carries the predicted value plus a delta and delta percentage showing the expected range around it. Items with too little posted sales history are flagged rather than forecast badly.
The worksheet then offers two outputs:
| Output | What it writes | When to use it |
|---|---|---|
| Update Demand Forecast | Raw forecast quantities into the standard Demand Forecast tables | Items planned with demand-driven policies where MPS should see the forecast |
| Update planning parameters | Safety Stock, Reorder Point, Reorder Quantity, and Maximum Inventory on the Planning FastTab, calculated from user-defined expressions | Items on reorder-point policies where the forecast should set the thresholds |
The expressions are the interesting part. They use variables such as avg_daily_usage, avg_daily_forecast, forecast_qty, and lead_time_days, where lead time is read from the stockkeeping unit, then the item, then the preferred vendor. Safety stock can be defined as average daily usage multiplied by lead time. Reorder point can be that figure plus lead-time demand. Once written, the standard planning engine picks the values up on the next run with no further intervention.
One operational detail matters before the first run. Update Demand Forecast inserts entries rather than replacing them, so sending the same results twice to the same forecast doubles the forecasted quantity for the period. Clear or review the target forecast before a rerun. A second detail: multi-location companies forecast one location at a time. Running across locations only updates the first stockkeeping unit correctly.
The app page states that one named user per Business Central online environment is free, with no time limit and no feature restriction, and that additional users or on-premises deployment require a paid subscription. The worksheet is also one of six components of the Enhanced Planning Pack for Business Central. The demand forecasting worksheet for Business Central page and the forecasting worksheet user guide cover the run options. For a walkthrough of the planning side, see forecasting inventory levels in Business Central.
Which approach fits which company?
A make-to-order shop with little repeat demand needs almost none of this. Order and Lot-for-Lot policies driven by real sales orders do the work. A distributor with hundreds of stocked items and a few locations is the opposite case. There, the choice has three options: maintain forecast cells by hand, review usage manually and edit reorder points item by item, or let a forecast calculate the parameters and review exceptions.
A sensible progression is to start with the standard Demand Forecast page for a handful of A items. Prove that planning reacts the way the team expects, and only then automate the calculation. The items that hurt when they stock out, and the items that tie up the most cash when overstocked, are where a calculated forecast earns its keep first.
Frequently asked questions about the Business Central demand forecast
Can I export the demand forecast, edit it in Excel, and import it back? The standard Demand Forecast page is designed to be edited directly as a matrix, and any spreadsheet round trip is a manual exercise. The Enhanced Forecasting Worksheet writes calculated quantities directly into the Demand Forecast tables, so no round trip is needed for those.
How do I set reorder points in Business Central? Enter Reorder Point on the item’s Planning FastTab, or on the stockkeeping unit for multi-location items. Pair it with Safety Stock Quantity and a reorder-point Reordering Policy. Business Central uses the value; it does not calculate it.
Does the built-in Sales and Inventory Forecast update planning? No. It displays a chart on the item, warns of projected stockouts, and can suggest a quantity on a purchase order. It does not write to the Demand Forecast page or to planning parameters.
Does the forecast double count sales orders? No. During the MPS run, the forecast is netted against sales and production orders, so the engine sees the larger of the two, not the sum.
Do I need posted sales history to forecast? Yes. Both the standard extension and the enhanced worksheet forecast from posted sales. New items and new locations cannot be forecast until history exists.
Is the Enhanced Forecasting Worksheet free? Per the app page, one named user per Business Central online environment gets the full feature set at no charge. Additional users or on-premises deployment require a paid subscription.