BeyondERP.Newsletter
Menu

Setup step on the Expense page · Project management and accounting

Review expense forecasts by category

Check forecast expenses per category and model before they feed cost control.

Used by
Project accountant, Project assistant, Project manager
Business process
Plan projects
Menu item
ProjForecastCost
Main table
ProjForecastCost
Data entity
ProjForecastCostEntity
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 expense forecast lines for all projects in the company, with forecast model, project date, project, activity, category, resource and amounts.
What you do hereUse it to answer 'which travel and other expenses do we expect, on which projects and in which model?' and to correct expense forecasts before they feed cost control or a ledger budget.
ExampleThe BEAT project assistant filters model FC-2026 on category TRAVEL and finds 4 expense lines on PRJ-0042 totalling 2,400.00 EUR for flights in December; one line for 600.00 EUR was entered on PRJ-0024 by mistake and is moved.
Expense 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 › Expense
Set up firstForecast models Microsoft Learn Project categories Microsoft Learn
Used next byCopy forecasts to ledger Microsoft Learn
Related pagesCategory forecast transactions Microsoft Learn
In this process Read hour forecasts for one model · Turn item forecasts into item requirements
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

Review expense forecasts by category

Check forecast expenses per category and model before they feed cost control.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Forecasts inquiries > Expense.
  2. Filter on the Forecast model and then on Category, so you review one kind of expense across projects.
  3. Use Edit forecast transactions to correct amounts or move a line to the right project.
  4. Select General ledger preview to see the cost the lines will post to a ledger budget, then run Copy forecasts to ledger if the model feeds the budget.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Forecast modelThe model that holds the expense line; filter on it so lines from copies and submodels don't add up.Microsoft Learn FC-2026
CategoryThe expense category of the forecast line, such as travel or hotel.Checked in Dynamics 365TRAVEL
Show report transactionsA check box above the list that also shows forecast lines flagged as report transactions.Checked in Dynamics 365Cleared

Common errors and fixes

MessageWhat to do
The ledger budget still shows the old expense forecast.Changes here don't reach the ledger budget by themselves; run Copy forecasts to ledger again for the model. Microsoft Learn

Test checklist

  1. Enter an expense forecast of 600.00 EUR on PRJ-0042, category TRAVEL, model FC-2026.
  2. Open the inquiry filtered on FC-2026 and TRAVEL.
  3. Check that the line shows with 600.00 EUR.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review expense forecasts by categoryFilter on the Forecast model, then on Category.Expense forecasts are amount lines per category; reviewing by category across projects shows misplaced or duplicated lines.Should expense forecasts be planned in project forecasts or project budgets?Correcting a line here and expecting the ledger budget to follow without running Copy forecasts to ledger again.Test: Expense forecast shows by category

Feature management and licence

Licence or add-inOn the live system, Project manager, Project accountant and Project assistant maintain this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: forecast lines belong to the legal entity of the project, and each line sits in one forecast model. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterEdits take effect at once for every report and cost control view that uses the model; forecasts have no approval workflow and keep no revision history. Microsoft Learn
Technical architect

6Technical

Menu itemProjForecastCost Checked in Dynamics 365
FormProjForecastCost Checked in Dynamics 365
TableProjForecastCostShown as “Expense forecast” in Record infoKey field: ModelId, StartDate, ProjId, ProjFundingSource, ProjFundingSource_ContractId, ProjFundingSource_FundingSourceId, ActivityNumber, CategoryId, Resource, Resource_Name, Resource_ResourceId, Resource_ResourceCompanyId, ResourceCategory, LinePropertyIdChecked in Dynamics 365
Data entitiesProjForecastCostEntityProject expense forecasts Microsoft data model
Who can open itPrivilegesMaintain expense forecasts ProjForecastCostMaintainView expense forecasts ProjForecastCostViewDutiesMaintain project budgets ProjProjectBudgetsMaintainMaintain project forecasts ProjProjectForecastMaintainInquire into project forecast status ProjProjectForecastStatusInquire
3 security rolesProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject manager ProjProjectManagerProject accountant ProjProjectAccountantProject assistant ProjProjectClerkGive people one of these roles. On this system, 3 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=ProjForecastCost
Integrate withProjForecastCostEntity data entity Microsoft data model
Data migrationProjForecastCostEntity Project expense forecasts; loads the lines of this page.Load order: Load forecast models, projects and expense categories, then expense forecasts with ProjForecastCostEntity.Load first: Forecast models, Project categoriesMicrosoft data model
Table definitionProjForecastCost columns and relations Microsoft data model
Everyone

8Sources

To cite this step: PM-RA-050, Review expense forecasts by category. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RA-050