BeyondERP.Newsletter
Menu

Inquiry page · Project management and accounting

On-account

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.

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 isAn 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 hereUse 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.
ExampleFor 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.
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

Business processAnalyze project performance
Menu pathProject management and accounting › Inquiries and reports › Transactions inquiries › On-account
Set up firstProject contracts Microsoft Learn
Used next byProject invoice proposals Microsoft Learn
Related pagesOn-account forecasts Microsoft Learn Project on-account Microsoft Learn
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.

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

  1. Go to Project management and accounting > Inquiries and reports > Transactions inquiries > On-account.
  2. Filter on the Fixed-price project and set Invoice status to see open milestones.
  3. Select Show deductions when you reconcile on-account amounts with the deductions made from them.
  4. Invoice the open milestone through an invoice proposal when it is reached.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Column displayChooses which group of columns the grid shows, for example prices.Checked in Dynamics 365Price
Invoice statusLimits the list to transactions in one invoicing state; All shows every state.Checked in Dynamics 365All
Show deductionsA 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
DescriptionThe milestone or on-account text, as it appears on the invoice.Checked in Dynamics 365First delivery 30%

Common errors and fixes

MessageWhat 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

  1. Create a billing schedule of 20,000.00 and 30,000.00 EUR on PRJ-0057.
  2. Invoice the first milestone.
  3. Open the inquiry filtered on PRJ-0057.
  4. Check one invoiced line of 20,000.00 EUR and one open line of 30,000.00 EUR.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Reconcile milestones on a Fixed-price projectFilter 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.How is Fixed-price revenue recognized?Reading open on-account lines as revenue; on Fixed-price projects revenue follows the revenue recognition method, not invoicing.Test: Milestone status shows

Feature management and licence

Licence or add-inOn 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.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: The inquiry changes no data. Microsoft Learn
If you change it laterWhen a milestone is invoiced, its invoice status changes; deductions on later invoices reduce what remains billable. Microsoft Learn
Technical architect

6Technical

Menu itemProjTransOnAcc Checked in Dynamics 365
FormProjTransOnAcc Checked in Dynamics 365
TableProjOnAccTransShown as “Project on-account transactions” in Record infoKey field: TransDate, ProjIDChecked in Dynamics 365
Who can open itPrivilegesDelete on-account transactions ProjTransOnAccMaintainView on-account transactions ProjTransOnAccViewDutiesMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPostReview project transactions ProjProjectTransactionsReviewInquire into project transaction status ProjProjectTransactionStatusInquire
6 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo 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 pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjTransOnAcc
Data migrationLoad 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
Table definitionProjOnAccTrans columns and relations Microsoft data model
Everyone

8Sources