BeyondERP.Newsletter
Menu

Setup step on the Item forecast page · Project management and accounting

Turn item forecasts into item requirements

Review project item forecasts and create item requirements for the ones that are due.

Used by
Materials manager, Treasurer, Production manager and 5 more roles
Business process
Plan projects
Menu item
ForecastSalesProj
Main table
ForecastSales
Data entity
ProjForecastSalesEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry that lists project item forecasts, with WBS task, forecast model, date, project, item, site, warehouse and quantities, and lets you create item requirements from them.
What you do hereUse it to answer 'which materials will our projects need, when and from which warehouse?' and to turn approved item forecasts into item requirements.
ExampleThe BEAT project manager filters model FC-2026 on PRJ-0042 and sees 25.00 units of item CABLE-10 for 12 November from warehouse WH-01, then selects Create item requirement so the warehouse can reserve them.
Item 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

Business processPlan projects
Menu pathProject management and accounting › Inquiries and reports › Forecasts inquiries › Item forecast
Set up firstForecast models Microsoft Learn
Used next byItem requirements Microsoft Learn
Related pagesResource/item forecast transactions Microsoft Learn
In this process Review expense forecasts by category · Review fee forecasts for revenue planning
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

Turn item forecasts into item requirements

Review project item forecasts and create item requirements for the ones that are due.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Forecasts inquiries > Item forecast.
  2. Filter on Model and Project ID, and check item, date, site and warehouse on each line.
  3. On the Project tab, set the funding source when the project has more than one.
  4. Select Create item requirement for the lines that are ready, and confirm the message.
  5. Open Item requirements to reserve or pick the items.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Funding sourceThe invoice account to use for the item requirement created from the forecast.Microsoft Learn FundingSourceId
Forecast modelThe model that holds the forecast; every project forecast needs one.Microsoft Learn
ModelThe forecast model that holds the item forecast line.Microsoft Learn FC-2026
Item numberThe item forecast for the project.Checked in Dynamics 365CABLE-10
Site / WarehouseWhere the items are expected to come from; carried to the item requirement.Checked in Dynamics 365Site 1, WH-01
Item allocation keySpreads the forecast over several items by an allocation key instead of one item.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
No item requirement is created for a Cost project.Item requirements are sales order lines and need a customer; associate the Cost project with a customer first. Microsoft Learn

Test checklist

  1. Enter an item forecast of 25.00 CABLE-10 on PRJ-0042 in FC-2026.
  2. Select Create item requirement on the line.
  3. Open Item requirements filtered on PRJ-0042.
  4. Check that one requirement for 25.00 units exists.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Turn item forecasts into item requirementsFilter on Model and Project ID, check site and warehouse, then create item requirements line by line.The item requirement carries the forecast's item, quantity and warehouse; it is what the warehouse reserves and picks.When are item requirements created from forecasts?Changing the forecast after the item requirement exists and expecting the requirement to follow.Test: Item requirement from forecast

Feature management and licence

Licence or add-inOn the live system, Project manager, Project accountant, Project assistant, Sales manager and Production planner maintain this page; Treasurer and Materials manager view it.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: item forecast lines are stored in the demand forecast table of the legal entity, marked with the project. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterCreating an item requirement turns the forecast into demand that the warehouse acts on; editing the forecast afterwards does not change the requirement. Microsoft Learn
Technical architect

6Technical

Menu itemForecastSalesProj Checked in Dynamics 365
FormForecastSales Checked in Dynamics 365
TableForecastSalesShown as “Demand forecast” in Record infoKey field: ItemId, ItemGroupId, CustAccountId, CustGroupId, ModelId, ReportChecked in Dynamics 365
Data entitiesProjForecastSalesEntityProject 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 itProject manager ProjProjectManagerProject accountant ProjProjectAccountantProject assistant ProjProjectClerkSales manager TradeSalesManagerProduction planner ReqProductionPlannerTo use itTreasurer PaymTreasurerMaterials manager InventMaterialsManagerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ForecastSalesProj
Integrate withProjForecastSalesEntity data entity Microsoft data model
Data migrationProjForecastSalesEntity Project item forecasts.Load order: Load forecast models, projects and released products, then item forecasts with ProjForecastSalesEntity.Load first: Forecast models, Released products, Projects V2 (ProjProjectV2Entity)Microsoft data model
Table definitionForecastSales columns and relations Microsoft data model
Everyone

8Sources