BeyondERP.Newsletter
Menu

Transaction page · Master planning

Demand forecast lines

A page that lists demand forecast lines: expected demand entered by item, item group, item allocation key, customer, or customer group.

Used by
Materials manager, Treasurer, Production manager and 5 more roles
Business process
Forecast demand
Menu item
ForecastSalesMenu
Main table
ForecastSales
Data entity
ForecastDemandForecastEntryEntity
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 page that lists demand forecast lines: expected demand entered by item, item group, item allocation key, customer, or customer group.
What you do hereUse this page to enter, view, and spread demand forecast lines over time so that master planning can include expected demand.
ExampleFor example, you enter a yearly quantity for an item and use the Period method with one-month intervals to create one forecast line for each month.
Demand forecast lines 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 › Forecasting › Manual forecast entry › Demand forecast lines
Used next byMaster plans Microsoft Learn
Related pagesSupply forecast lines Microsoft Learn Customer groups 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.

Steps from Microsoft

  1. Go to Master planning > Forecasting > Manual forecast entry > Demand forecast lines.
  2. On the Action Pane, select New.
  3. In the Model field, select the forecast model, and then enter the item or customer details and the quantity.
  4. On the Overview tab, select Allocate forecast on the toolbar.
  5. Review the time horizon and intervals in the Allocation grid.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
ModelThe forecast model that the line belongs to.Microsoft Learn
DateThe start date of the forecast line.Microsoft Learn
Customer accountThe customer the forecast line is for.Microsoft Learn
Customer groupThe customer group the forecast line is for.Microsoft Learn
Item allocation keyThe item allocation key used to spread the forecast over items.Microsoft Learn
Sales quantityThe forecast quantity in the sales unit.Microsoft Learn
MethodHow the line is spread over time: None, Period, or Key.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
If you change it laterWhen you use Bulk update without first filtering, every forecast line is selected and updated, which can duplicate or remove lines. Microsoft Learn
Technical architect

5Technical

Menu itemForecastSalesMenu Checked in Dynamics 365
FormForecastSales Checked in Dynamics 365
TableForecastSalesShown as “DEMAND FORECAST” in Record infoChecked in Dynamics 365
Data entitiesForecastDemandForecastEntryEntityDemand forecast entries Microsoft data model ProjForecastSalesEntityProject item forecasts Microsoft data model
Who can open itPrivilegesMaintain demand forecasts for item groups ForecastSalesMaintainView demand forecasts for item groups ForecastSalesViewDutiesCash flow position details drill down CashflowPositionDetailsDrillDownMaintain demand forecasts ForecastDemandForecastMaintainInquire into demand forecasts ForecastDemandForecastProgressInquireMaintain project budgets ProjProjectBudgetsMaintainMaintain project forecasts ProjProjectForecastMaintainInquire into project forecast status ProjProjectForecastStatusInquireMaintain authorization of adjusted demand forecasts ReqDemPlanImportMaintainEnable the demand forecasting process ReqDemPlanProcessEnable
8 security rolesMaterials manager InventMaterialsManagerTreasurer PaymTreasurerProduction manager ProdProductionManagerProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProduction planner ReqProductionPlannerSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProduction planner ReqProductionPlannerProduction manager ProdProductionManagerProject manager ProjProjectManagerSales manager TradeSalesManagerProject accountant ProjProjectAccountantTo use itMaterials manager InventMaterialsManagerTreasurer PaymTreasurerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Forecast balances, Cash flow forecasts, Display dimensions, General ledger preview, Transfer quotation lines, Engineering changeChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=ForecastSalesMenu
Integrate withForecastDemandForecastEntryEntity data entity Microsoft data model
Data migrationForecastDemandForecastEntryEntity (Demand forecast entries): loaded for each company.ProjForecastSalesEntity (Project item forecasts): loaded for each company.Microsoft Learn
Table definitionForecastSales columns and relations Microsoft data model
Everyone

7Sources