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 it
After a period is closed, when you compare on-account invoicing per project with another period.
How often
On demand, at period close or for quarterly billing reviews.
What the output shows
One row per project with on-account amounts for Period 1 and Period 2. Unlike Project on-account, it shows two ledger ranges side by side; a gap usually means a milestone was billed in the other period.
Enter two closed periods of equal length under Ledger date - Period 1 and Period 2.Each column is a plain total of its range; unequal or overlapping ranges make the comparison meaningless.
On the live system, Project manager, Project supervisor, Chief executive officer and Chief financial officer can run this page.
Checked in Dynamics 365
Solution architect
5Design impact
Shared or per company
Per 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 undone
Reversible: Running or rerunning the report changes no data.
If you change it later
The report reads posted on-account invoices and, for budgets, forecast lines. Whether an on-account invoice hit WIP Invoiced - on account or Invoiced revenue - on account depends on the project cost and revenue profile at posting; a profile change affects only later invoices. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListProjOnAccountProj2ColumnPeriodChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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
Load order: Project on-account (2 periods) has no data entity in Data management: it is an SSRS report (design ProjOnAccProj2Prd) that 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.Microsoft Learn
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.
To cite this step: PM-RC-150, Set the selection for Project on-account (2 periods). Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RC-150