BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Fixed price projects - profit and loss backlog report

A report that shows, per current fixed-price revenue recognition project, the profit still to be posted to profit and loss: the total estimated amount minus the amount already accumulated.

Business process
Analyze project performance
Menu item
output:ProjListEstimateprodBacklogPL
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 shows, per current fixed-price revenue recognition project, the profit still to be posted to profit and loss: the total estimated amount minus the amount already accumulated.
What you do hereUse it to see how much margin is still to come on fixed-price projects that are in progress.
ExampleFor estimate date 2026-10-31 BEAT's controller sees PRJ-0057 with a total estimated profit of 18,120.00, of which 11,325.00 is accumulated, so 6,795.00 is still to be posted.
Fixed price projects - profit and loss backlog report 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 › Revenue recognition inquiries and reports › Fixed price projects - profit and loss backlog report
Set up firstFixed price projects - profit and loss report Microsoft Learn
Used next byCalculate revenue recognition Microsoft Learn
Related pagesFixed price projects - profit and loss report Microsoft Learn Fixed price projects - consumption backlog report Microsoft Learn Revenue recognition inquiry 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 itAfter revenue recognition for the period is posted, when you want to see how much profit is still to be posted to profit and loss on current fixed-price projects.
How oftenAt each period end, after revenue recognition is posted.
What the output showsRemaining profit per project: the total estimated amount minus the amount already accumulated. A negative remaining profit usually means the total estimate is out of date.

Source: Microsoft Learn

Setup steps on this page

Set period code and estimate date for Fixed price projects - profit and loss backlog report

Report on the right revenue recognition period.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Revenue recognition inquiries and reports > Fixed price projects - profit and loss backlog report.
  2. Choose the Period code; it sets the date range of the fixed-price revenue recognition projects.
  3. Enter the Estimate date to report on.
  4. Turn on Include eliminated projects if you also want projects that are already eliminated, then run the report and look at the remaining profit per project.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Period codeChoose the period code; it sets the date range.Microsoft Learn
Estimate dateChoose the date to report on.Microsoft Learn
Include eliminated projectsAlso show projects that were already eliminated.Microsoft Learn

Common errors and fixes

MessageWhat to do
The remaining profit is negative.The total estimate of the project is out of date; update the forecast or cost template that drives the estimate and calculate revenue recognition again. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set period code and estimate date for Fixed price projects - profit and loss backlog reportRun it for the period code of the projects and the estimate date of the last calculated period; leave Include eliminated projects off.Eliminated projects have no backlog left; including them adds rows with nothing remaining.Which projects does the backlog review include?Reading the backlog as cash to come: it is profit still to be posted to profit and loss, not unbilled amounts.Test: Fixed price projects - profit and loss backlog report shows PRJ-0057

Feature management and licence

Feature to turn onUpdate labels for revenue recognition and related forms and processes in Project Operations (mandatory since version 10.0.36; it renamed Estimates to Revenue recognition in these menus)
Licence or add-inOn the live system, Project manager, Project supervisor, Chief executive officer and Chief financial officer can run this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer legal entity: the report reads only the project data of the company you are signed in to, so run it in each company you close. Checked in Dynamics 365
Can it be undoneReversible: the report changes no data: The backlog report only reads estimate data; it changes nothing. Microsoft Learn
If you change it laterThe report reads revenue recognition data. When the project's estimate changes, the remaining profit changes only after Calculate revenue recognition runs again for the period. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListEstimateprodBacklogPL Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListEstimateprodBacklogPL
Data migrationLoad order: Fixed price projects - profit and loss backlog report has no data entity in Data management: the menu item ProjListEstimateprodBacklogPL opens a report that only reads posted project data. There is nothing to migrate for the report itself; load the project data it reads, for example opening balances through Journals > Beginning balance, then run the report in the new system and compare its totals with the old one.Checked in Dynamics 365
Everyone

8Sources