Enhanced Forecasting Worksheet for Microsoft Dynamics 365 Business Central
Free for One User
Turn sales history into forecasts that drive planning
Precise, customizable inventory forecasting to prevent stockouts and optimize stock levels.
Enhanced Forecasting Worksheet extends the Sales and Inventory Forecast feature in Microsoft Dynamics 365 Business Central into a worksheet you can act on. It forecasts many items at once with Microsoft's Azure AI forecasting model, then sends the results to the demand forecast or to each item's planning fields. It is free for one named user in a Business Central online environment, with every feature included.
- Business Central online
- Free for one user
- Microsoft Azure AI forecasting
Enhanced Forecasting Worksheet resources
How Enhanced Forecasting Worksheet helps
Forecast in bulk
Forecast a whole category in one pass
The sales forecast in Business Central appears one item at a time, in the item's fact box. Turning it into usable numbers means reviewing history and entering values item by item.
Enhanced Forecasting Worksheet sends posted sales history for a filtered set of items to Microsoft's Azure AI forecasting model and lists every result in one worksheet. Filter by item, item category, or location, and set the period type, number of forecast and past periods, confidence level, and forecasting algorithm.
See all Enhanced Forecasting Worksheet features ↓Demand forecast
Send the forecast straight to material requirements planning
A forecast only helps planning once it reaches the demand forecast that material requirements planning (MRP) reads. Copying values across by hand takes time and invites typing errors.
Update Demand Forecast writes the predicted values into the standard Business Central demand forecast for every period in the range, ready for MRP and the master production schedule (MPS). The Demand Forecast Overview then shows the result by item and month.
See all Enhanced Forecasting Worksheet features ↓Planning parameters
Set reorder points from your own formulas
Safety stock and reorder points that were set once drift away from real demand. Updating them item by item is slow enough that it gets put off.
Enhanced Forecasting Worksheet calculates safety stock, reorder point, reorder quantity, and maximum inventory from expressions you define, using variables such as average daily usage, lead time, and forecast quantity. Update Item Planning writes the results to the item cards in one step.
See all Enhanced Forecasting Worksheet features ↓Enhanced Forecasting Worksheet screenshots
Real screens from Enhanced Forecasting Worksheet in Business Central, shown with demo data.
Enhanced Forecasting Worksheet features
- Azure AI ForecastingSend posted sales history to Microsoft's Azure AI forecasting model and review the results in a worksheet.
- Flexible FilteringForecast by item, item category, or location.
- Forecast Periods and ConfidenceChoose week, month, quarter, or year, the number of forecast and past periods, and the confidence level.
- Multiple Forecasting AlgorithmsChoose from six forecasting algorithms to match your demand pattern.
- Update Demand ForecastWrite forecast values into the standard Business Central demand forecast used by MRP and MPS.
- Update Item PlanningWrite calculated safety stock, reorder point, reorder quantity, and maximum inventory to item cards in one step.
- Planning ExpressionsDefine planning formulas with variables such as average daily usage, lead time, and forecast quantity.
- Sales History CheckFlags items that do not have enough posted sales history to forecast.
Requirements and licensing
Free for one user
One named user in each Business Central online environment can use every feature at no cost, with no time limit. Additional users need a paid subscription.
Business Central online
The free single-user license applies to Business Central online.
Business Central license
Each user needs a Business Central user license.
Sales history and forecast setup
Enhanced Forecasting Worksheet uses the Sales and Inventory Forecast setup in Business Central and Microsoft's Azure AI forecasting model. Items need posted sales history before they can be forecast.
Multiple locations
Companies that use several locations with stockkeeping units forecast one location at a time.
Also in Enhanced Planning Pack
Enhanced Forecasting Worksheet is also included in Enhanced Planning Pack, Insight Works' bundle of six planning, forecasting, and production analysis apps.
PRICE
Free for One User
The free license covers one named user per Business Central online environment with full features; additional users or on-premises deployment need a paid subscription.
App details and prerequisites
- Business Central
- Business Central online
- Insight Works license
- Free for one named user; subscription for additional users
- Business Central license
- Business Central user license
- Forecasting model
- Microsoft Azure AI
- Languages
- English
- Availability
- All countries where Business Central is available
Questions about Enhanced Forecasting Worksheet?
Ready to plan a rollout? Contact your Microsoft Partner. For product questions, send us a note and the Enhanced Forecasting Worksheet team will reply by email.




