BeyondERP.Newsletter
Menu

Setup step on the Project invoice journals page · Project management and accounting

Pick the general ledger columns for the Project invoice journals report

Make the report show where each project invoice landed in the ledger.

Business process
Manage project financials
Menu item
output:ProjInvoiceJournal
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 posted project invoice journals with their invoice totals and, when you turn them on, the general ledger amounts each invoice posted, such as invoiced revenue and WIP invoiced on-account.
What you do hereUse it at period end to tie posted project invoices to revenue and on-account balances in the general ledger.
ExampleAt the October 2026 close BEAT's project accountant lists invoices dated 2026-10-01 to 2026-10-31 with Invoiced revenue and WIP - Invoiced - on-account turned on: 42 invoices total 312,880.00 before tax, and 75,000.00 of it sits in WIP invoiced on-account for fixed-price contract PC-0057.
Project invoice journals 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 processManage project financials
Menu pathProject management and accounting › Inquiries and reports › Project invoices reports › Project invoice journals
Set up firstPost project invoice proposals Microsoft Learn
Used next byLedger updates - on-account Microsoft Learn
Related pagesProject invoices report Microsoft Learn Project invoices Microsoft Learn
In this process Choose the invoice kinds and dates for the Project invoices report · List pay-when-paid vendor invoices per project
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, when you reconcile posted project invoices with revenue in the general ledger.
How oftenMonthly, as part of the project period-end close.
What the output showsOne line per posted project invoice journal, with the invoice totals and general ledger columns you turned on. Invoice amount minus Sales tax should match Subtotal amount; a difference in Invoiced revenue against the ledger usually means on-account invoices are still in WIP.

Source: Microsoft Learn

Setup steps on this page

Pick the general ledger columns for the Project invoice journals report

Make the report show where each project invoice landed in the ledger.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Project invoices reports > Project invoice journals.
  2. Under Invoice date, enter the From date and To date of the posted invoices to list.
  3. In Sorting under Layout - rows, choose the order of the rows, and turn on On-account to include on-account invoices.
  4. Under Layout invoice totals columns, turn on the columns you need, such as Hour - quantity, Line discount, Subtotal amount, Sales tax or Invoice amount.
  5. Under Layout general ledger columns, turn on Invoiced amount, WIP - Invoiced - on-account, Invoiced revenue, Cost amount or Gross margin when you want to tie the invoices to the ledger.
  6. Compare the invoice totals with the general ledger columns; a gap usually points to on-account amounts still held in WIP.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
On-accountInclude on-account invoices.Microsoft Learn
SortingChoose the order of rows on the report.Microsoft Learn
Layout invoice totals columnsChoose which invoice total columns to show.Microsoft Learn
Layout general ledger columnsChoose which general ledger columns to show.Microsoft Learn

Common errors and fixes

MessageWhat to do
Invoiced revenue is lower than the invoice subtotal.On-account invoices of a cost and revenue profile set to Balance post to WIP Invoiced - on account, not to revenue. Turn on WIP - Invoiced - on-account to see that part. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Pick the general ledger columns for the Project invoice journals reportFor the period close, turn on Invoiced revenue and WIP - Invoiced - on-account under Layout general ledger columns, next to Subtotal amount.An on-account invoice posts to WIP Invoiced - on account when the cost and revenue profile uses Balance and to Invoiced revenue - on account when it uses Profit and loss, so you need both columns to explain the total.Which columns does the close version of the report show?Comparing Invoice amount with revenue: Invoice amount includes sales tax, which is credited to a tax account, so compare Subtotal amount instead.Test: Project invoice journals splits revenue and WIP on-account

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 posted invoice journals. Which account each invoice hit was decided by the project cost and revenue profile and the ledger posting setup when it was posted; a setup change affects only invoices posted afterwards, so check the next period's run after any change. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjInvoiceJournal 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:ProjInvoiceJournal
Data migrationLoad order: Project invoice journals has no data entity in Data management: the menu item ProjInvoiceJournal 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-020, Pick the general ledger columns for the Project invoice journals report. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RC-020