BeyondERP.Newsletter
Menu

Setup page · Master planning

Outlier removal

A setup page where you build queries that select historical transactions to leave out when the baseline demand forecast is calculated.

Business process
Forecast demand
Menu item
ReqDemPlanOutlierQuerySetup
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you build queries that select historical transactions to leave out when the baseline demand forecast is calculated.
What you do hereUse this page to exclude unusual transactions from forecast history so that the forecast is more accurate.
ExampleFor example, you exclude a specific item or order transaction that does not reflect normal demand.
Outlier removal page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processConduct sales and operations planning › Forecast demand
Menu pathMaster planning › Setup › Demand forecasting › Outlier removal
Used next byOutlier transactions Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Outlier removal

Use this page to exclude unusual transactions from forecast history so that the forecast is more accurate.

Steps from Microsoft

  1. Go to Master planning > Setup > Demand forecasting > Outlier removal.
  2. Select the company that the query applies to, and enter a name and description.
  3. Select the Active check box.
  4. On the Outlier removal query page, add or change the criteria for the transactions to exclude.
  5. Select Display transactions to check which transactions are excluded.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Query dateSet to the current date when the query is created; it identifies the query version.Microsoft Learn createdDateTime
ActiveWhen selected, the transactions the query finds are excluded from forecast history.Microsoft Learn Active

Test checklist

  1. Create an outlier removal query for the company that selects one known unusual sales order.
  2. Select Display transactions and check that only that order's transactions are listed.
  3. Select Active.
  4. Generate a statistical baseline forecast for the item and compare it with a forecast generated without the query.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Outlier removalOne query per unusual event (for example a one-off bulk order), checked with Display transactions before you select Active.Display transactions lists exactly the transactions the query will exclude from history, so you can confirm the scope before the next baseline forecast uses it.Building the query but leaving Active cleared. The transactions are excluded only for active queries, and only when a baseline forecast is created.
Solution architect

5Design impact

Can it be undoneReversible: Clear Active or change the query criteria. The next baseline forecast uses the updated selection. Microsoft Learn
If you change it laterAn active query takes effect the next time a baseline forecast is created. Microsoft Learn
Technical architect

6Technical

Menu itemReqDemPlanOutlierQuerySetup Checked in Dynamics 365
FormReqDemPlanOutlierQuerySetup Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProduction planner ReqProductionPlannerProduction manager ProdProductionManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Edit query, Duplicate, Display transactionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ReqDemPlanOutlierQuerySetup
Everyone

8Sources