BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Project on-account

A report that totals the on-account amounts invoiced per project, such as milestone billings and prepayments, for a project date and ledger date range.

Business process
Analyze project performance
Menu item
output:ProjListProjOnAccountProj
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 totals the on-account amounts invoiced per project, such as milestone billings and prepayments, for a project date and ledger date range.
What you do hereUse it at period end to see how much each project has billed on-account and to explain the WIP invoiced on-account or on-account revenue accounts.
ExampleAt the October 2026 close BEAT's controller sees PRJ-0057 with 55,000.00 invoiced on-account (milestones 1 and 2) and PRJ-0061 with a 10,000.00 prepayment less a 4,000.00 deduction, so 6,000.00 net.
Project on-account 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

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 period end or before a customer review, when you want the on-account amounts invoiced per project for a date range.
How oftenOn demand, at period close or before customer billing reviews.
What the output showsOne row per project (grouped by Project view) with the on-account amount for the period. A project with zero usually has no posted on-account invoice in the ledger date range.

Source: Microsoft Learn

Setup steps on this page

Set the selection for Project on-account

Get on-account billing per project that can be checked against the ledger or the plan.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > On account reports > Project on-account.
  2. Under Include project types, turn on Time and material or Fixed-price to choose the projects with on-account invoicing.
  3. Enter the From date and To date under Project date and Ledger date for the on-account transactions to analyze.
  4. Under Data, set Actual vs. budget and, for budget figures, the Forecast model.
  5. Under Layout - rows, choose the Project view and Project level, turn on Skip blank ID or Skip zero to shorten the list, then run the report and check the on-account total per project.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Include project typesChoose which project types the report covers.Microsoft Learn
Actual vs. budgetChoose whether the report shows actual values or budgeted values.Microsoft Learn
Forecast modelChoose the forecast model that supplies the budget figures; with project budget control, use the project's budget forecast model.Microsoft Learn
Project viewChoose how the first column of the report is grouped, for example by project group or customer.Microsoft Learn
Project levelSet how many levels of subprojects the report shows.Microsoft Learn
Skip blank IDLeave out transactions that have no ID for the grouping the report uses.Microsoft Learn
Skip zeroLeave out rows where the amounts are zero.Microsoft Learn
Show amountChoose how amounts are shown, such as with decimals, without decimals, or in thousands or millions.Microsoft Learn

Common errors and fixes

MessageWhat to do
A project shows zero although a milestone was billed.The on-account invoice probably has a ledger date outside the range or the project type is not turned on; check the posted invoice and the Include project types options. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set the selection for Project on-accountUse the ledger date range of the closed period, actual values, and Project view by project.On-account invoices post on their ledger date to WIP Invoiced - on account or Invoiced revenue - on account, so ledger dates make the totals comparable with those accounts.Which date range selects on-account amounts?Netting time and material prepayments against the total: prepayment deductions are entered as negative lines, so a small net amount can hide a large prepayment.Test: Project on-account shows a billed milestone

Feature management and licence

Licence or add-inOn 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 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 Project on-account report only reads posted data; it changes nothing. Microsoft Learn
If you change it laterThe 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 itemoutput:ProjListProjOnAccountProj 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:ProjListProjOnAccountProj
Data migrationLoad order: Project on-account has no data entity in Data management: it is an SSRS report (design ProjOnAccProj) 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
Everyone

8Sources