Edit

Share via

Remove outliers from historical transaction data when calculating a demand forecast

  • Article

Tip

This article describes demand forecasting functionality that's built into Microsoft Dynamics 365 Supply Chain Management. For an even better planning and forecasting experience, we recommend that you try Demand planning in Microsoft Dynamics 365 Supply Chain Management, which is Microsoft's next-generation collaborative demand planning solution. For details, see the Demand planning home page.

This article describes how to exclude outliers from the historical data that is used to calculate a demand forecast. By excluding outliers, you can improve forecast accuracy.

You can exclude outliers to improve forecast accuracy. This is an optional task. Here is an overview of the process:

  1. Go to Master planning > Setup > Demand forecasting > Outlier removal to open the Outlier removal page, where you can use a query to select the transactions to exclude.
  2. Select the company that the query applies to, and then enter a name and description. The Query date field is automatically set to the current date.
  3. Select the Active checkbox to exclude the transactions that the query finds from the historical data. This setting will take effect when you create a baseline forecast.
  4. On the Outlier removal query page, you can add, remove, and select the criteria that define which transactions will be excluded when the baseline forecast is calculated. For example, select a specific item or order transaction to exclude.
  5. Select Display transactions. The Outlier transactions page lists the transactions that meet the criteria that you defined in the query, and that will be excluded from the historical data when the demand forecast is calculated.

Note

You can also create a query that is based on an existing query. Select the query to copy, and then select Duplicate. The Query date field identifies the version. You can use the query as it is, or you can select Edit query to modify the criteria. You can optionally modify the name and description of the new query.