BeyondERP.Newsletter
Menu

Job page · Master planning

Generate statistical baseline forecast

A dialog box where you set the parameters and filters that are used to calculate a statistical baseline demand forecast.

Business process
Forecast demand
Menu item
ReqDemPlanGenerateBaselineForecast
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA dialog box where you set the parameters and filters that are used to calculate a statistical baseline demand forecast.
What you do hereUse this page to generate a baseline forecast from historical demand for a chosen historical period, set of items, forecast bucket, and forecast horizon.
ExampleFor example, a planner creates a baseline forecast for the coming month for a selected group of items, based on transaction data from the past year.
Generate statistical baseline forecast 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

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.

When to run it

When to run itAt the start of each forecasting cycle, after historical demand for the period has been posted or imported.
How oftenOnce per forecasting cycle, at the bucket you plan in (for example monthly).
Batch settingsRun it in the background for large item sets, or split it by item allocation key so each run stays manageable.
What the output showsA statistical baseline forecast per item or item allocation key, for the number of buckets in Forecast horizon. A flat forecast usually means the history is too short; no forecast for an allocation key usually means the key isn't linked to an intercompany planning group.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Master planning > Forecasting > Demand forecasting > Generate statistical baseline forecast.
  2. Under Historical horizon, enter the From date and To date of the demand history to learn from; use at least three periods of history to pick up patterns.
  3. Set Forecast bucket to Day, Week or Month, enter the number of buckets in Forecast horizon, and enter Freeze time fence for buckets that planners shouldn't change.
  4. Enter Baseline forecast start date - From date. It can be in the past, and it is moved to the start of a bucket.
  5. Select Transfer manual adjustments to the demand forecast if adjustments from earlier forecasts should carry over, and filter on intercompany planning group or item allocation key to split large runs.
  6. Open the adjusted demand forecast and the Statistical baseline forecast generation history to review the result.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Forecast bucketThe time unit of each forecast period: Day, Week, or Month.Microsoft Learn
Forecast horizonThe number of buckets to forecast.Microsoft Learn
Freeze time fenceThe number of forecast buckets that are frozen and shouldn't be changed.Microsoft Learn
Baseline forecast start date - From dateThe start date of the baseline forecast; it can be in the past and is moved to the start of a bucket.Microsoft Learn
Transfer manual adjustments to the demand forecastApplies manual adjustments from earlier forecast iterations to the new baseline forecast.Microsoft Learn

Test checklist

  1. The generation history shows the run with your name and comment.
  2. Forecast lines start at the first bucket on or after the start date you entered.
  3. Frozen buckets can't be edited on the adjusted demand forecast.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneYes, before authorization: Generate the forecast again to replace it. Nothing reaches master planning until you authorize it. Microsoft Learn
If you change it laterManual adjustments to a forecast are saved only when the forecast is authorized; adjustments that are not authorized are lost. Microsoft Learn
Technical architect

5Technical

Menu itemReqDemPlanGenerateBaselineForecast Checked in Dynamics 365
FormReqDemPlanCreateForecastDialog Checked in Dynamics 365
Roles to set it up and use itTo use itProduction planner ReqProductionPlannerProduction manager ProdProductionManagerGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources