---
title: "Enhanced Forecasting Worksheet"
app: "Enhanced Planning Pack"
section: "How-to guides"
last_updated: "2026-08-18"
url: "https://insight-works.com/kb/enhanced-planning-pack/enhanced-forecasting-worksheet/"
---

# Enhanced Forecasting Worksheet

The _Enhanced Forecasting Worksheet_ gives the user 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. The worksheet also allows for updating planning parameters on the Item card based on user-defined expressions that may involve forecasted quantities.

### Enhanced Forecast Setup

1. Navigate to _Enhanced Forecast Setup_in Business Central.
2. Select **Sales and Inventory Forecast Setup** and adjust the settings, as needed.
3. Close the page to return to the _Enhanced Forecast Setup_ page.
4. Input expressions for item planning parameter calculations into the following fields (Or use default expressions for an initial experiment):

   - Safety Stock Expression
   - Reorder Point Expression
   - Reorder Quantity Expression
   - Maximum Inventory Expression

1. Set the following fields as needed for the forecasted/calculated fields on the Enhanced Forecasting Worksheet:

   - Round Direction
   - Round Precision

Changes are automatically saved.

Note: The following variables can be used in an item planning calculation expression:

- avg\_daily\_usage: Average daily usage of an item. Average daily usage of an item over the given time range, this is based on the item’s average usage for the entire range (e.g., forecast\_days).Effectively usage\_qty divided by forecast\_days.
- avg\_daily\_forecast: Average daily forecast of an item. This is effectively forecast\_qty divided by forecast\_days.
- lead\_time\_days: Lead time of an item in days. This can come from multiple sources:

   - If there is a SKU and that SKU has a _Lead time Calculation_ field value specified on the SKU card, that value is used.
   - If that value is blank on the SKU card and the related Item card has a _Lead Time Calculation_ field value specified, that value is used.
   - If that value is blank on both SKU and Item cards, the item has a preferred vendor defined on the Item card, and that vendor card has a _Lead Time Calculation_ field value defined on it, that value is used.
   - If all the above _Lead Time Calculation_ fields are blank, a value of “1” is used.
- forecast\_qty: Forecast quantity of an item. This is the forecast value coming from the forecasting service.
- forecast\_days: Number of forecasted days. This is the number of days in the start and end date range.
- usage\_qty: Usage quantity of an item. Usage of the item over the time range.

### Enhanced Forecasting Worksheet

1. Navigate to _Enhanced Forecasting Worksheet_ in Business Central.
2. Set the following fields as needed:

   - Item Filter
   - Item Category
   - Item LocationNote: If your company is using multiple locations and SKUs, you must choose a single location to forecast; otherwise, the first SKU updates when applying the forecast.
   - Period Type
   - No. of Forecast Periods
   - No. of Past Periods
   - Confidence Level
   - Forecast Algorithm
3. Select **Calculate Forecast**.
4. Select **Update Demand Forecast**.
5. Select a demand forecast and select **OK** (sends results).
6. Select **Update Item Planning** (updates the following Planning FastTab fields with corresponding values: Safety Stock Quantity, Reorder Point, Reorder Quantity, and Maximum Inventory).

For information on calculated expression value capabilities, see _[Expression Evaluator](/kb/product-configurator/expression-evaluator/)._

Note: You may need to add _Confidence Level_ and _Forecast Algorithm_ fields to the page via Personalize/Design, and the options for the _Forecast Algorithm_ field are a subset of those in the _Timeseries Model_ field on the Sales and _Inventory Forecast Setup_ page.

Forecast result lines are returned for all items and periods specified by the field values in the _Filter Settings_ section. The lines contain values in the Safety Stock Quantity, Reorder Point, Maximum Inventory and Reorder Quantity columns equal to the evaluated expressions set on the Enhanced Forecast Setup page.

There must be sufficient sales history (posted Sale-type item ledger entries) that satisfies the field values in the _Filter Settings_ section. If a message is displayed about enough data not existing, this data must be created before running Calculate Forecast again.

**Update Demand Forecast** does not modify/delete existing demand forecast entries; the action inserts entries based on the results in the worksheet (due to the possibility of multiple forecast entries for the same item over periods greater than a day). For example, sending the same forecast results twice to the same demand forecast results in two times the forecasted quantity being added to the forecast entry for the appropriate period.

## Understanding the Forecast Results

After you select **Calculate Forecast**, the Enhanced Forecasting Worksheet displays the forecast results for each item, location, variant, and forecast period.

The forecast itself is generated using Microsoft Business Central forecasting functionality. The worksheet then presents those forecast results together with relevant item planning information such as Safety Stock Quantity, Reorder Point, Maximum Inventory, and Reorder Quantity.

Microsoft provides more information about the forecasting functionality here:

[Forecasting API overview – Business Central](https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/ml-forecasting-api-overview)

### Location Code

Identifies the location for which the forecast was calculated.

Forecasts can be calculated separately for different item, location, and variant combinations. This is especially useful when planning parameters differ by location.

### Item No.

Identifies the item being forecast.

The forecast is based on historical sales activity for the item over the number of past periods selected when calculating the forecast.

### Item Variant Code

Identifies the item variant for which the forecast was calculated, when variants are being used.

This allows forecast results to be separated by variant rather than combining all activity for an item into a single forecast.

### Item Description

Displays the description of the item being forecast.

This field is provided for identification and does not affect the forecast calculation.

### Forecast Starting Date

Shows the first date of the forecast period represented by the row.

For example, if **Period Type** is set to Month, each row represents one forecast month and the Forecast Starting Date identifies the beginning of that month.

Microsoft forecasting organizes historical and predicted values into consistent time periods. For more information, see:

[Forecasting API overview – Business Central](https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/ml-forecasting-api-overview)

### Forecast Ending Date

Shows the end of the forecast period represented by the row.

Together with **Forecast Starting Date**, this makes it clear which date range the predicted quantity applies to.

### Predicted Value

The quantity that the forecasting model predicts will be required during the forecast period.

For example:

**Predicted Value = 100**

means that the forecasting model predicts demand of approximately 100 units during that forecast period.

The predicted quantity ultimately comes from Microsoft Business Central forecasting functionality.

The worksheet presents forecast demand as a positive quantity, even though Business Central may internally represent outbound sales quantities using negative values.

For more information about Microsoft’s forecast results, see:

[Forecasting API overview – Business Central](https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/ml-forecasting-api-overview)

### Delta

**Delta** indicates the expected variance around the Predicted Value.

For example, if:

- Predicted Value = **100**
- Delta = **10.5**

then the predicted value is expected to fall approximately within the range:

**89.5 to 110.5**

This can also be thought of as:

**Predicted Value – Delta** through **Predicted Value + Delta**

A smaller Delta means the forecasting model has produced a narrower expected range. A larger Delta indicates greater uncertainty around the predicted value.

Microsoft describes this uncertainty as part of the forecast result and uses it to indicate the likely range around the prediction.

For more information, see:

[Forecasting API overview – Business Central](https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/ml-forecasting-api-overview)

### Delta %

**Delta %** expresses the Delta relative to the Predicted Value as a percentage.

For example:

- Predicted Value = **100**
- Delta = **10.5**
- Delta % = approximately **10.5%**

This makes it easier to compare forecast uncertainty between items with very different forecast quantities.

For example, a Delta of 10 units is relatively small when the Predicted Value is 1,000 units, but much more significant when the Predicted Value is only 20 units.

In general, **the smaller the Delta % the better**. A smaller percentage indicates that the predicted range is narrower relative to the forecast quantity, while a larger percentage indicates greater uncertainty.

Microsoft notes that forecasts with a relatively wide prediction range may be less useful, depending on the business scenario and the type of value being forecast.

See:

[Forecasting API overview – Business Central](https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/ml-forecasting-api-overview)

### Safety Stock Quantity

Displays the **Safety Stock Quantity** currently associated with the item or Stockkeeping Unit.

This is a standard Business Central planning parameter rather than a forecast result.

Safety Stock Quantity represents inventory that is maintained to help protect against fluctuations in supply and demand.

For more information, see:

[Design details: Planning parameters](https://learn.microsoft.com/dynamics365/business-central/design-details-planning-parameters)

### Reorder Point

Displays the **Reorder Point** currently associated with the item or Stockkeeping Unit.

This is a standard Business Central planning parameter rather than a forecast result.

The Reorder Point identifies the inventory level at which replenishment should be considered for reordering policies that use a reorder point.

For more information, see:

[Design details: Handling reordering policies](https://learn.microsoft.com/dynamics365/business-central/design-details-handling-reordering-policies)

### Maximum Inventory

Displays the **Maximum Inventory** quantity currently associated with the item or Stockkeeping Unit.

This is a standard Business Central planning parameter rather than a forecast result.

Maximum Inventory is primarily used with the **Maximum Qty.** reordering policy. When replenishment is required, Business Central can calculate a quantity intended to restore projected inventory toward the configured maximum level.

For more information, see:

[Design details: Handling reordering policies](https://learn.microsoft.com/dynamics365/business-central/design-details-handling-reordering-policies)

### Reorder Quantity

Displays the **Reorder Quantity** currently associated with the item or Stockkeeping Unit.

This is a standard Business Central planning parameter rather than a forecast result.

Reorder Quantity is commonly used with the **Fixed Reorder Qty.** reordering policy as the standard replenishment quantity when planning determines that additional supply is required.

For more information, see:

[Design details: Planning parameters](https://learn.microsoft.com/dynamics365/business-central/design-details-planning-parameters)

## Where the Values Come From

| Field | Source |
| --- | --- |
| Location Code | Business Central item/location information |
| Item No. | Business Central item information |
| Item Variant Code | Business Central item variant information |
| Item Description | Business Central Item |
| Forecast Starting Date | Microsoft forecast period |
| Forecast Ending Date | Forecast period displayed by the Enhanced Forecasting Worksheet |
| Predicted Value | Microsoft Business Central forecasting |
| Delta | Microsoft Business Central forecasting |
| Delta % | Microsoft Business Central forecasting |
| Safety Stock Quantity | Business Central Item/SKU planning parameters |
| Reorder Point | Business Central Item/SKU planning parameters |
| Maximum Inventory | Business Central Item/SKU planning parameters |
| Reorder Quantity | Business Central Item/SKU planning parameters |

The Enhanced Forecasting Worksheet does not replace Microsoft’s forecasting engine. It uses Business Central’s forecasting functionality to generate the underlying prediction and uncertainty values, then gives planners a clearer way to review those results before updating a Demand Forecast or item planning parameters.

### Additional Microsoft Documentation

- [Forecasting API overview](https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/ml-forecasting-api-overview) – Explains the forecast results and prediction ranges.
- [Sales and Inventory Forecast extension](https://learn.microsoft.com/dynamics365/business-central/ui-extensions-sales-forecast) – Provides an overview of Microsoft’s sales and inventory forecasting functionality.
- [Design details: Planning parameters](https://learn.microsoft.com/dynamics365/business-central/design-details-planning-parameters) – Explains Safety Stock Quantity, Reorder Point, Maximum Inventory, Reorder Quantity, and related planning parameters.
- [Design details: Handling reordering policies](https://learn.microsoft.com/dynamics365/business-central/design-details-handling-reordering-policies) – Explains how planning parameters are used by Business Central reordering policies.
