An inquiry that lists on-account transactions on projects, with project date, project, transaction origin, description, sales currency, sales price, activity and invoice status, with an option to show deductions.
Project management and accountingInquiries and reportsTransactions inquiries
ProjTransOnAcc
Used by
Chief executive officer, Field Service Integration User, Project accountant and 3 more roles
Business process
Analyze project performance
Menu item
ProjTransOnAcc
Main table
ProjOnAccTrans
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
An inquiry that lists on-account transactions on projects, with project date, project, transaction origin, description, sales currency, sales price, activity and invoice status, with an option to show deductions.
What you do here
Use it to answer 'which milestone or on-account amounts are billed, which are still open, and what has been deducted?', mainly for Fixed-price projects.
Example
For Fixed-price project PRJ-0057 the BEAT project accountant finds 20,000.00 EUR invoiced on signing and 30,000.00 EUR for first delivery still open, so the first-delivery milestone goes on the next invoice proposal.
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.
Setup steps on this page
Reconcile milestones on a Fixed-price project
See which on-account amounts are billed, open or deducted.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Transactions inquiries > On-account.
Filter on the Fixed-price project and set Invoice status to see open milestones.
Select Show deductions when you reconcile on-account amounts with the deductions made from them.
Invoice the open milestone through an invoice proposal when it is reached.
Chooses which group of columns the grid shows, for example prices.Checked in Dynamics 365
Price
Invoice status
Limits the list to transactions in one invoicing state; All shows every state.Checked in Dynamics 365
All
Show deductions
A check box above the list that also lists deduction lines, so you see on-account amounts and what was deducted from them together.Checked in Dynamics 365
Description
The milestone or on-account text, as it appears on the invoice.Checked in Dynamics 365
First delivery 30%
Common errors and fixes
Message
What to do
On-account lines are missing for a Time and material project.
Only Fixed-price projects are invoiced through on-account transactions by default; Time and material projects bill their hours, expenses, items and fees. Microsoft Learn
Test checklist
Create a billing schedule of 20,000.00 and 30,000.00 EUR on PRJ-0057.
Invoice the first milestone.
Open the inquiry filtered on PRJ-0057.
Check one invoiced line of 20,000.00 EUR and one open line of 30,000.00 EUR.
Filter on the project and set Invoice status before reading amounts.Open and invoiced on-account lines answer different questions: what is still to bill, and what the customer has already received.
On the live system, Project accountant and Project assistant maintain this page; Project manager, Project supervisor, Chief executive officer and Field Service Integration User view it.
When a milestone is invoiced, its invoice status changes; deductions on later invoices reduce what remains billable. Microsoft Learn
Technical architect
6Technical
Menu item
ProjTransOnAccChecked in Dynamics 365
Form
ProjTransOnAccChecked in Dynamics 365
Table
ProjOnAccTransShown as “Project on-account transactions” in Record infoKey field: TransDate, ProjIDChecked in Dynamics 365
Who can open it
PrivilegesDelete on-account transactions ProjTransOnAccMaintainView on-account transactions ProjTransOnAccViewDutiesMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPostReview project transactions ProjProjectTransactionsReviewInquire into project transaction status ProjProjectTransactionStatusInquire6 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChecked in Dynamics 365
Roles to set it up and use it
To set it up or change itProject accountant ProjProjectAccountantProject assistant ProjProjectClerkTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserGive people one of these roles. On this system, 6 roles can open this page.Checked in Dynamics 365
Actions on the page
Options: Personalize, Page options, ShareChecked in Dynamics 365
Developer
7Developer
Open it by URL
https://<your-environment>/?mi=ProjTransOnAcc
Data migration
Load order: The On-account transactions inquiry has no data entity in Data management that writes posted transactions: lines are created by posting journals, timesheets or source documents. Open on-account amounts from a former system are loaded as on-account beginning balance lines (ProjBeginningBalanceOnAccEntity).Microsoft Learn