Azure AI Forecasting for Microsoft Dynamics 365 Business Central
Business Central's Sales and Inventory Forecast feature shows an item's forecast as a chart, one item at a time. Planners who want to use that forecast across a whole category, or act on it, have no worksheet to do it in.
Enhanced Forecasting Worksheet extends the Sales and Inventory Forecast feature into a worksheet. It sends posted sales history for many items at once to Microsoft's Azure AI forecasting model and lists the predicted values by item and period.
How Azure AI forecasting works in Enhanced Forecasting Worksheet
- The planner sets filters for items, item category, or location, and chooses the period type and number of forecast and past periods.
- The planner chooses Calculate Forecast.
- Enhanced Forecasting Worksheet sends the matching sales history to Microsoft's Azure AI forecasting model.
- Predicted values return to the worksheet by item and period.
- The planner sends the results to the demand forecast, or updates item planning values.
Key capabilities
Microsoft's model, your history
Enhanced Forecasting Worksheet takes the posted sales history that matches your filters and sends it to Microsoft's Azure AI forecasting model through the Sales and Inventory Forecast setup in Business Central. Insight Works does not run a separate prediction engine.
A worksheet of results
Each row shows the item, forecast starting and ending dates, and the predicted value. Calculated safety stock, reorder point, maximum inventory, and reorder quantity sit on the same row.
More detail when you want it
Fields such as the confidence level, deltas, and the algorithm used can be shown through personalization.
Two ways to act
Send predicted values to the demand forecast used by planning, or use them to update item planning values on the item card.
Extensible
Insight Works provides events that developers can use, for example to filter on other criteria.
See Azure AI forecasting on screen
Real screens from Enhanced Forecasting Worksheet, shown with demo data.
Details that matter on the floor
The model is Microsoft's
The forecast is calculated by Microsoft's Azure AI forecasting model, documented by Microsoft for Business Central. Enhanced Forecasting Worksheet is the worksheet and the actions around it.
History in, forecast out
Enhanced Forecasting Worksheet forecasts from posted sales history. It does not set service levels or fill-rate targets; those decisions stay with the planner.
Results you can still adjust
Once results are in Business Central, they can be edited, exported to Excel, or adjusted with formulas before anything is updated.
Who uses Azure AI forecasting
Inventory managers
Forecast a whole category instead of one item at a time.
Supply chain planners
Feed planning with a forecast built from real sales history.
Purchasing managers
See expected demand by period before planning purchases.
Questions about Azure AI forecasting
Does Business Central have AI forecasting?
Business Central's Sales and Inventory Forecast feature uses Microsoft's Azure AI forecasting model. Enhanced Forecasting Worksheet extends it into a worksheet that forecasts many items at once and can send the results to the demand forecast or to item planning fields.
Does Insight Works build its own forecasting model?
No. Enhanced Forecasting Worksheet sends sales history to Microsoft's Azure AI forecasting model and works with the results. How the model calculates is described in Microsoft's Business Central documentation.
What do I need set up first?
The Sales and Inventory Forecast setup in Business Central, and items with posted sales history. Enhanced Forecast Setup has a link to the Sales and Inventory Forecast Setup page.
Is Enhanced Forecasting Worksheet part of Enhanced Planning Pack?
Yes. Enhanced Forecasting Worksheet is its own app and is also included in Enhanced Planning Pack. Licensing depends on the setup; see the licensing FAQ.
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 Azure AI forecasting?
Send us a note and the Enhanced Forecasting Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
