A 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.
Project management and accountingInquiries and reportsProject invoices reports
output:ProjInvoiceJournal
Business process
Manage project financials
Menu item
output:ProjInvoiceJournal
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 is
A 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 here
Use it at period end to tie posted project invoices to revenue and on-account balances in the general ledger.
Example
At 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.
The page in Dynamics 365. page title tab to open what to set or check
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
At period end, when you reconcile posted project invoices with revenue in the general ledger.
How often
Monthly, as part of the project period-end close.
What the output shows
One 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.
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
Go to Project management and accounting > Inquiries and reports > Project invoices reports > Project invoice journals.
Under Invoice date, enter the From date and To date of the posted invoices to list.
In Sorting under Layout - rows, choose the order of the rows, and turn on On-account to include on-account invoices.
Under Layout invoice totals columns, turn on the columns you need, such as Hour - quantity, Line discount, Subtotal amount, Sales tax or Invoice amount.
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.
Compare the invoice totals with the general ledger columns; a gap usually points to on-account amounts still held in WIP.
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
For 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.
On 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 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: the report changes no data: The Project invoice journals report only reads project data; running it changes nothing. Microsoft Learn
If you change it later
The 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 item
output:ProjInvoiceJournalChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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
Load 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