BeyondERP.Newsletter
Menu

Setup step on the Customer payment retention page · Project management and accounting

Choose the summary level for Customer payment retention

Show retained amounts at the level the release is agreed on.

Business process
Analyze project performance
Menu item
output:PSACustomerRetention
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 totals the payment retention customers hold back on project invoices, the retention percentage of the billing rules, summarized by customer, project contract, project or billing rule.
What you do hereUse it to see how much retained money each customer still owes on projects before you invoice a retention release.
ExampleWhen PRJ-0042 reaches handover in November 2026, BEAT's project accountant runs the report by Contract for PC-0042: 10% retention on billing rule BR-01 has held back 18,500.00 of 185,000.00 invoiced, which is the amount to release.
Customer payment retention 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 reports › Customer payment retention
Set up firstCustomer payment retention terms Microsoft Learn
Used next byProject invoice proposals Microsoft Learn
Related pagesCustomer retained payments Microsoft Learn
In this process Set the selection for Project on-account (actual vs. budget) · Choose the assessment level for Vendor payment retention
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 itWhen a project reaches the stage where retained amounts can be invoiced, or when a customer asks how much of their payments is still retained.
How oftenOn demand, at project milestones or before a retention release.
What the output showsRetained customer payment amounts summarized at the level you chose (customer, contract, project or billing rule). A retention you expected but don't see usually means the billing rule has no retention percentage.

Source: Microsoft Learn

Setup steps on this page

Choose the summary level for Customer payment retention

Show retained amounts at the level the release is agreed on.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Retention reports > Customer payment retention.
  2. Under Layout, choose the Customer payment retention summary to organize the report by customer, contract, project or billing rule.
  3. Choose a Customer account, Contract, Project or Billing rule if you want the retention of only one of them.
  4. Run the report and compare the retained amount per billing rule with the retention percentage set on the project contract's billing rules.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Customer payment retention summaryChoose how the report is organized: by customer, contract, project or billing rule.Microsoft Learn
Customer accountLimit the report to one customer.Microsoft Learn
ContractLimit the report to one project contract.Microsoft Learn
ProjectLimit the report to one project.Microsoft Learn
Billing ruleLimit the report to one billing rule.Microsoft Learn

Common errors and fixes

MessageWhat to do
A project contract shows no retention although invoices were posted.The billing rule has no retention percentage on its Payment retention terms; retention is deducted only from invoices posted after a percentage is set. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Choose the summary level for Customer payment retentionSet Customer payment retention summary to Contract (or Billing rule when one contract has several retention terms) and filter the contract you plan to release.The retention percentage is set per billing rule of the project contract, so contract or billing rule level matches how the release is agreed with the customer.At which level do you review customer retention?Reading the retained amount as already released: the money stays retained until an invoice proposal for the retained amount is posted.Test: Customer payment retention shows the retained 10%

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor, Project accountant, Chief executive officer and Project assistant 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 retained amounts on posted project invoices. Changing the retention percentage on a billing rule affects only invoices posted afterwards; the release is invoiced through an invoice proposal, after which the report shows a lower retained balance. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:PSACustomerRetention Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorProject accountant ProjProjectAccountantChief executive officer CompanyChiefExecutiveOfficerProject assistant ProjProjectClerkGive people one of these roles. On this system, 9 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:PSACustomerRetention
Data migrationLoad order: Customer payment retention has no data entity in Data management: it is an SSRS report (design PSACustomerRetention) that 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.Microsoft Learn
Everyone

8Sources

To cite this step: PM-RC-170, Choose the summary level for Customer payment retention. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RC-170