BeyondERP.Newsletter
Menu

Setup step on the Category forecast transactions page · Project management and accounting

Plan spending by category from the forecast

Read forecast totals per category in one model or submodel.

Business process
Analyze project performance
Menu item
output:ProjListBudgetCategory
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 isA report that lists forecast transactions of one forecast model grouped by project category, for the dates you choose. The report design is ProjListBudget.
What you do hereUse it to answer 'how much do we forecast per kind of cost or revenue?' to plan spending on categories such as subcontracting or travel.
ExampleThe BEAT project assistant runs model FC-2026 with Expense on for the first quarter and sees SUBCON at 68,000.00 EUR and TRAVEL at 9,500.00 EUR across all projects, which the finance lead compares with the purchasing plan.
Category forecast transactions 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 processAnalyze project performance
Menu pathProject management and accounting › Inquiries and reports › Forecast transactions reports › Category forecast transactions
Set up firstForecast models Microsoft Learn Expense forecasts Microsoft Learn
Used next byCopy forecasts Microsoft Learn
Related pagesCategory actual transactions Microsoft Learn
In this process Check a forecast model per project before transfer · Compare forecast hours per person with capacity
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 each forecast round, when spending is planned by category.
How oftenQuarterly.
What the output showsForecast amounts per category for one model. The report design is ProjListBudget.

Source: Microsoft Learn

Setup steps on this page

Plan spending by category from the forecast

Read forecast totals per category in one model or submodel.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Forecast transactions reports > Category forecast transactions.
  2. Choose the Forecast model, or a submodel when you plan one region or department.
  3. Turn on only the transaction type whose categories you plan, such as Expense for subcontracting and travel.
  4. Read the category totals and compare them with the same categories on Category actual transactions for last year.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesWhich project types to include; the dialog toggles Time and material, Fixed-price, Investment, Internal and cost (Internal and Cost project types) and Time.Checked in Dynamics 365All but Time
Include transaction typesTurn on the types whose categories you plan, for example Expense.Checked in Dynamics 365Expense
(Project date) From date / To dateThe range of forecast project dates; forecasts have no fiscal period.Microsoft Learn 1 November to 31 December
(Ledger date) From date / To dateLimits the report to transactions within a range of ledger dates.Microsoft Learn
Project statementThe statement the amounts follow; the dialog suggests Profit and loss.Checked in Dynamics 365Profit and loss
Forecast modelThe model whose forecast lines the report lists; a submodel shows only that part of the forecast. Budgets store their original and remaining amounts in two models, so budget data shows here too.Microsoft Learn FC-2026
Skip zeroLeave out rows where the amounts are zero.Microsoft Learn
Show amountHow amounts are shown; the dialog suggests With decimals.Checked in Dynamics 365With decimals
Show hourChoose whether to show hour quantities, hour cost values, or both.Microsoft Learn
PL ratioChoose whether to add a profit and loss ratio column, such as gross margin.Microsoft Learn

Common errors and fixes

MessageWhat to do
A category is missing from the forecast.Its lines sit in a different forecast model or submodel; run the report for that model. Microsoft Learn

Test checklist

  1. Enter two expense forecasts in SUBCON of 4,000.00 EUR each in FC-2026.
  2. Run the report for FC-2026 with Expense on.
  3. Check that SUBCON shows 8,000.00 EUR.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Plan spending by category from the forecastChoose the model or submodel and turn on one transaction type.Submodels let you forecast by region or department; reporting on the parent or the submodel answers different questions.Are regional forecasts kept as submodels?Reading a submodel's totals as the company forecast.Test: Category total

Feature management and licence

Licence or add-inOn the live system, Project assistant is the role that runs this report. Feature management controls whether this report skips the reporting framework's transaction scope (ProjSSRSSkipReportTransactionFeature), which helps large runs.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: forecast models are shared setup, but the forecast lines belong to the projects of the current legal entity. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterThe report shows the model as it is when you run it; forecast reduction and edits change it without history, so keep a copy of the original model for comparisons. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListBudgetCategory Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject assistant ProjProjectClerkGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListBudgetCategory
Data migrationLoad order: The Category forecast transactions report has no data entity in Data management: it reads forecast lines. Load the forecasts with the forecast entities (for example ProjForecastEmplEntity for hours) and run the report to compare totals per model.Microsoft data model
Everyone

8Sources

To cite this step: PM-RA-350, Plan spending by category from the forecast. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RA-350