BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Forecast models

A setup page where you create forecast models, including the original, remaining and carry-forward budget models that project budgets use.

Used by
Project supervisor
Business process
Plan projects
Menu item
ProjForecastModel
Main table
ForecastModel
Data entity
ForecastModelEntity
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 create forecast models, including the original, remaining and carry-forward budget models that project budgets use.
What you do hereUse this page to name and set up the forecast models that project forecasts and budgets are recorded against.
ExampleFor example, BEAT creates ORIG-26 with Budget type Original budget and REM-26 with Remaining budget, so that the 250,000.00 budget of PRJ-0042 is committed to both and actual costs reduce only REM-26.
Forecast models 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 › Setup › Forecasts › Forecast models
Set up firstProject management and accounting parameters Microsoft Learn
Used next byCarry forward budgets Microsoft Learn
Related pagesAll project forecasts 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.

Step by step, with screenshots

Set up Forecast models1 screen

Use this page to name and set up the forecast models that project forecasts and budgets are recorded against.

  1. Screen 1

    Create a forecast model

    Go to Project management and accounting > Setup > Forecasts > Forecast models

    1. Select New
    2. Enter the model code and name
    3. Set the project forecast options, such as the invoice date and budget type, as needed
    4. Select Save
    1ModelBEAT-FM
    2NameForecast model
    Create a forecast model (zoomed on the outlined fields)
    Show the full screenCreate a forecast model
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Forecasts > Forecast models.
  2. Select New, and enter a model ID and name.
  3. Set Stopped to Yes if the forecast lines must not change.
  4. Set Include in Cash flow forecasts to Yes if the lines should create cash flow forecasts.
  5. Set Forecast Invoice date to Yes to use the project date as the invoice date.
  6. In the Budget type field, select Original budget, Remaining budget or Carry-forward.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
StoppedStops any changes to the model's forecast lines.Microsoft Learn NoBlocked
Include in Cash flow forecastsLets the model's forecast lines create cash flow forecasts in the general ledger.Microsoft Learn No
Forecast Invoice dateUses the project date as the invoice date.Microsoft Learn Yes
Budget typeWhether the model holds the original budget, the remaining budget or carry-forward amounts.Microsoft Learn Remaining budgetProjBudgetType
Forecast with WIPForecasts based on work in progress (WIP), with a WIP type.Microsoft Learn No
ModelA unique identifier for the forecast model.Microsoft Learn REM-26ModelId
NameThe name of the forecast model.Microsoft Learn Remaining budget 2026

Common errors and fixes

MessageWhat to do
A budget-control model can't be added as a submodel.A forecast model used for budget control can't have a submodel or be one. Use a separate model for forecasts. Microsoft Learn

Test checklist

  1. Create an Original budget model and a Remaining budget model.
  2. Create a project budget that uses both and submit it to workflow.
  3. Approve the budget and check forecast transactions are created in both models.
  4. Post actual costs and check the remaining budget model balance drops.
  5. Try to change the Budget type on a used model and check it's not allowed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Forecast modelsSeparate Original budget and Remaining budget models for budget control, with no submodels on themA budget-controlled project needs both an original and a remaining budget model, and a model used for budget control can't have or be a submodel.Should projects be controlled with forecasts or with budgets?Changing the default Budget type on an existing model. After that you can't update its other options or reuse the model.Test: Remaining budget is reduced by actuals

Feature management and licence

Licence or add-inOn the live system, Project supervisor maintains this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneOne-way: Warning: you can't change a forecast model's Budget type after it is set, and changing the default Budget type blocks further option changes and reuse of that model. Create a new model instead. Microsoft Learn
If you change it laterThe budget type can't be changed later, and a model used for budget control can't have or be a submodel. Microsoft Learn
Technical architect

6Technical

Menu itemProjForecastModel Checked in Dynamics 365
FormForecastModel Checked in Dynamics 365
TableForecastModelShown as “Forecast models” in Record infoKey field: Type, ModelId, SubModelIdChecked in Dynamics 365
Data entitiesForecastModelEntityForecast models Microsoft data model ForecastSubModelEntityForecast sub models Microsoft data model
Who can open itPrivilegesMaintain project forecast models ProjForecastModelMaintainDutiesEnable project accounting process ProjProjectAccountingProcessEnable
1 security roleProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject supervisor ProjProjectSupervisorGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjForecastModel
Integrate withForecastModelEntity data entity Microsoft data model
Data migrationForecastModelEntity (Forecast models): loaded for each company, in Microsoft's default template 430 - Master planning.ForecastSubModelEntity (Forecast sub models): loaded for each company, in Microsoft's default template 430 - Master planning.Load order: Microsoft's default template 430 - Master planning loads Forecast models at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionForecastModel columns and relations Microsoft data model
Everyone

8Sources