BeyondERP.Newsletter
Menu

Setup step on the On-account invoice schedule page · Project management and accounting

Select the on-account transactions for the billing run

List exactly the milestones and prepayments that are due for invoicing.

Business process
Analyze project performance
Menu item
output:ProjOnAccount
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that lists the on-account transactions of time and material and fixed-price projects, such as billing milestones and prepayments, for a project date range, showing which are already invoiced and which can still be invoiced.
What you do hereUse it before an on-account billing run to see which milestones and prepayments are due and which were billed already.
ExampleBefore the November 2026 billing run BEAT's project assistant lists fixed-price on-account transactions dated 2026-11-01 to 2026-11-30: PRJ-0057 milestone 3 for 30,000.00 is chargeable and not yet invoiced, milestone 2 for 25,000.00 shows as invoiced.
On-account invoice schedule 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 itBefore you create invoice proposals for on-account billing, or when a customer asks which on-account amounts are scheduled or already billed.
How oftenOn demand, before each on-account billing run.
What the output showsThe on-account invoice lines per project, sorted by the level you chose, with dates and amounts. A scheduled amount that is missing usually has a project date outside the range or isn't marked chargeable.

Source: Microsoft Learn

Setup steps on this page

Select the on-account transactions for the billing run

List exactly the milestones and prepayments that are due for invoicing.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > On account reports > On-account invoice schedule.
  2. Under Include project types, turn on Time and material or Fixed-price for the projects whose on-account invoices you want to see.
  3. Under Data, turn on Invoiced to include transactions already invoiced, and Chargeable to include chargeable transactions.
  4. Enter the From date and To date under Project date, and choose the first Sorting level under Layout - rows.
  5. Run the report and compare the scheduled on-account amounts with what the project contract says should be billed.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
InvoicedInclude on-account transactions that are already on a posted project invoice.Microsoft Learn Yes
ChargeableInclude on-account transactions that are not invoiced yet and can still go on an invoice proposal.Microsoft Learn Yes
SortingFirst sort level of the rows; the dialog proposes Invoice date.Checked in Dynamics 365Invoice date
Time and materialInclude on-account transactions of time and material projects, which are prepayments.Checked in Dynamics 365No
Fixed-priceInclude on-account transactions of fixed-price projects, which are milestone, unit of delivery or progress billings.Checked in Dynamics 365Yes
From dateFirst project date of the on-account transactions to include.Checked in Dynamics 3652026-11-01
To dateLast project date of the on-account transactions to include.Checked in Dynamics 3652026-11-30

Common errors and fixes

MessageWhat to do
A milestone you expect to bill is not listed.Check that the on-account transaction exists on the project, that its date is in the project date range and that the project type (Time and material or Fixed-price) is turned on. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Select the on-account transactions for the billing runTurn on Fixed-price (and Time and material if you bill prepayments), turn on Chargeable and leave Invoiced off, and enter the billing period as project dates.Chargeable without Invoiced leaves only the on-account transactions that still have to go on an invoice proposal, which is the list the billing run needs.Which on-account transactions does the pre-billing list show?Reading the schedule as amounts earned: on-account amounts come from the contract terms and billing schedule, not from hours or items posted on the project.Test: On-account invoice schedule lists a due milestone

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor, Project assistant, Accounts receivable clerk and Accounts receivable centralized payments clerk 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: Running or rerunning the report changes no data.
If you change it laterThe report reads on-account transactions. An on-account amount is set on the transaction, not calculated from posted hours or items, so if a milestone amount changes before invoicing, update the on-account transaction and run the report again. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjOnAccount Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorProject assistant ProjProjectClerkAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjOnAccount
Data migrationLoad order: On-account invoice schedule has no data entity in Data management: the menu item ProjOnAccount 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

To cite this step: PM-RC-130, Select the on-account transactions for the billing run. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RC-130