Skip to content
Enhanced Forecasting Worksheet app icon

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

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.

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.

Ask a product question

Product Questions