BeyondERP.Newsletter
Menu

Inquiry page · Project management and accounting

Customer retained payments

An inquiry, titled Inquire customer retained payments, that shows how much customers have retained on project invoices, by project or billing rule, by funding source and by invoice: invoiced, retained, retained amount invoiced and remaining.

Used by
Project accountant, Project assistant, Project manager and 1 more role
Business process
Analyze project performance
Menu item
PSACustomerPaymentRetentionInquiry
Main table
PSATmpRetentionReleaseLine
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, titled Inquire customer retained payments, that shows how much customers have retained on project invoices, by project or billing rule, by funding source and by invoice: invoiced, retained, retained amount invoiced and remaining.
What you do hereUse it to answer 'how much does the customer still hold back, and how much can we invoice when the agreed stage is reached?'
ExampleContract CON-0107 keeps back 10.00 percent of each BEAT invoice; after invoices of 120,000.00 EUR the inquiry shows 12,000.00 EUR retained, 4,000.00 EUR already invoiced as a release and 8,000.00 EUR remaining.
Customer retained payments 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 › Retention inquiries › Customer retained payments
Set up firstCustomer payment retention terms Microsoft Learn Project contracts Microsoft Learn
Used next byProject invoice proposals Microsoft data model
Related pagesCustomer payment retention (report) 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

Check retained amounts before releasing them

See what the customer still holds back before you invoice the release.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Retention inquiries > Customer retained payments.
  2. Select the Customer, Project contract, Project or Billing rule, then Search.
  3. Read the Customer payment retention summary, then the Funding sources and Invoices sections for the split by funder and by invoice.
  4. When the agreed stage is reached, release the remaining amount on the next project invoice proposal.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Total retained amountThe amount the customer has retained so far on the selected projects or billing rules.Checked in Dynamics 36512,000.00
Total retained amount invoicedHow much of the retained amount has already been invoiced as a release.Microsoft data model 4,000.00
Remaining retained amountThe retained amount still to be invoiced.Checked in Dynamics 3658,000.00
Customer / Project contract / Project / Billing ruleThe filter fields at the top; select at least one and then Search.Checked in Dynamics 365CON-0107

Common errors and fixes

MessageWhat to do
The page stays empty after it opens.Nothing shows until you select a filter value and select Search. Checked in Dynamics 365

Test checklist

  1. Set a 10.00 percent retention on the billing rule of CON-0107.
  2. Post an invoice of 10,000.00 EUR.
  3. Search the inquiry on CON-0107.
  4. Check 1,000.00 EUR retained and 1,000.00 EUR remaining.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check retained amounts before releasing themSearch by Project contract, then read the summary, funding sources and invoices sections.Retention is deducted per invoice and per funding source; the remaining amount is what you can release.Where is customer retention set?Releasing the total retained amount when part of it was already invoiced as a release.Test: Retention per invoice

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor, Project accountant and Project assistant view this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: retained amounts belong to the legal entity of the project and its contract. Microsoft data model
Can it be undoneReversible: The inquiry changes no data. Microsoft Learn
If you change it laterThe retention percentage is set on the billing rule and deducted from each customer invoice until the agreed stage; changing it affects only invoices created afterwards. Microsoft Learn
Technical architect

6Technical

Menu itemPSACustomerPaymentRetentionInquiry Checked in Dynamics 365
FormPSACustomerPaymentRetentionInquiry Checked in Dynamics 365
TablePSATmpRetentionReleaseLineShown as “Retainage records at the project/task level for a proposal” in Record infoChecked in Dynamics 365
Who can open itPrivilegesInquire customer retention PSACustomerRetentionInquireMaintain customer retention PSACustRetentionMaintainDutiesInquire into project contract master ProjProjectContractMasterInquireInquire customer retention PSACustomerRetentionForAccMaintain customer retention PSACustomerRetentionForManager
4 security rolesProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorProject accountant ProjProjectAccountantProject assistant ProjProjectClerkGive people one of these roles. On this system, 4 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=PSACustomerPaymentRetentionInquiry
Data migrationLoad order: The Customer retained payments inquiry has no data entity in Data management: it fills a temporary table from posted invoices. Retention terms load with ProjCustomerRetentionTermEntity; retained amounts come only from invoices posted in the system.Load first: Project customer retention term (ProjCustomerRetentionTermEntity)Microsoft data model
Everyone

8Sources