BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Fixed price projects - consumption backlog report

A report that shows, per fixed-price revenue recognition project, the consumption (cost) still to come: the estimated cost of the project minus the cost already consumed, at an estimate date.

Business process
Analyze project performance
Menu item
output:ProjListEstimateprodBacklogConsum
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 fixed-price revenue recognition project, the consumption (cost) still to come: the estimated cost of the project minus the cost already consumed, at an estimate date.
What you do hereUse it to see how much cost is still expected on fixed-price projects, which drives their percentage of completion.
ExampleFor estimate date 2026-10-31 BEAT's project manager sees PRJ-0057 with an estimated cost of 66,880.00 and 41,800.00 consumed, so 25,080.00 of cost is still to come and the project is 62.50% complete.
Fixed price projects - consumption 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 - consumption backlog report
Set up firstCalculate revenue recognition Microsoft Learn
Used next byRevenue recognition inquiry Microsoft Learn
Related pagesFixed price projects - profit and loss report Microsoft Learn Fixed price projects - profit and loss 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 calculated, when you want to see item consumption still to come on fixed-price projects.
How oftenAt each period end, when fixed-price estimates are reviewed.
What the output showsThe backlog of item consumption per fixed-price project: what is estimated but not yet consumed. A backlog that never shrinks usually means item consumption is posted to another project.

Source: Microsoft Learn

Setup steps on this page

Set period code and estimate date for Fixed price projects - consumption 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 - consumption backlog report.
  2. Choose the Period code that sets the date range of the fixed-price projects.
  3. Enter the Estimate date of the period whose item consumption backlog you want.
  4. Run the report and compare the consumption still to come with the cost lines of the project's revenue recognition estimate.

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 range to report on.Microsoft Learn

Common errors and fixes

MessageWhat to do
The backlog never shrinks although work goes on.Costs are probably posted to another project than the one attached to the revenue project; check the Selected projects of the revenue recognition project. 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 - consumption backlog reportRun it for the estimate date of the period you are about to calculate, before you post revenue recognition.With the completed percentage method the percentage of completion comes from cost consumed against estimated cost, so a wrong remaining cost changes the revenue posted.When do you review the consumption backlog?Leaving the cost estimate at its first value: when the remaining cost is too low the project shows as nearly complete and revenue is recognized too early.Test: Fixed price projects - consumption 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 consumption backlog report only reads data; it changes nothing. Microsoft Learn
If you change it laterThe report reads revenue recognition data. A higher cost estimate lowers the percentage of completion and so the revenue recognized at the next calculation; rerun the report after Calculate revenue recognition. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListEstimateprodBacklogConsum 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:ProjListEstimateprodBacklogConsum
Data migrationLoad order: Fixed price projects - consumption backlog report has no data entity in Data management: the menu item ProjListEstimateprodBacklogConsum 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