BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Project forecast transactions

A report that lists forecast transactions of one forecast model grouped by project, with amounts per transaction type for the dates you choose. The report design is ProjListBudget.

Business process
Analyze project performance
Menu item
output:ProjListBudgetProj
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 report that lists forecast transactions of one forecast model grouped by project, with amounts per transaction type for the dates you choose. The report design is ProjListBudget.
What you do hereUse it to answer 'what does this forecast model expect per project?' before a forecast is approved, copied or transferred to a ledger budget.
ExampleBefore sending model FC-2026 to the ledger budget, the BEAT project assistant runs the report for November to December and finds PRJ-0042 at 42,000.00 EUR cost and 56,000.00 EUR revenue, and PRJ-0057 with no lines because its forecast sits in FC-2026-B.
Project 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 › Project forecast transactions
Set up firstForecast models Microsoft Learn
Used next byCopy forecasts to ledger Microsoft Learn
Related pagesCategory forecast transactions Microsoft Learn Project actual transactions 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.

When to run it

When to run itBefore a forecast is approved, copied or transferred to the ledger budget.
How oftenMonthly or at each forecast round.
What the output showsForecast amounts per project for one model. The report design is ProjListBudget.

Source: Microsoft Learn

Setup steps on this page

Check a forecast model per project before transfer

Confirm each project's forecast in one model before it goes to the ledger budget.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Forecast transactions reports > Project forecast transactions.
  2. Choose the Forecast model you are about to approve or transfer; run once per model, never across models.
  3. Turn on all five transaction types so revenue (fee and on-account) and cost (hour, expense, item) both show per project.
  4. Read each project's forecast; a project with no lines usually has its forecast in another model.
  5. When the totals are right, run Copy forecasts to ledger for the model.

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 365Time and material, Fixed-price
Include transaction typesHour, Expense, Item, Fee and On-account forecast lines.Checked in Dynamics 365All five
(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 project shows no forecast lines.Its forecast is in another forecast model or outside the project date range. Microsoft Learn

Test checklist

  1. Enter 100.00 forecast hours on PRJ-0042 in FC-2026.
  2. Run the report for FC-2026 with Hour on.
  3. Check that PRJ-0042 shows 100.00 hours.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check a forecast model per project before transferChoose one Forecast model and turn on all five transaction types.Each model is a separate budget; mixing models or leaving out revenue types gives a forecast nobody approved.Which model is transferred to the ledger budget?Transferring a model whose report shows projects without lines because their forecast is in another model.Test: Forecast per project

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: The report changes no data. Microsoft Learn
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:ProjListBudgetProj 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:ProjListBudgetProj
Data migrationLoad order: The Project 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