BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Vendor payment retention

A report that totals the amounts retained from project vendor invoices under vendor payment retention terms, summarized by vendor or by project, for a date range.

Business process
Analyze project performance
Menu item
output:PSAVendorRetention
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 isA report that totals the amounts retained from project vendor invoices under vendor payment retention terms, summarized by vendor or by project, for a date range.
What you do hereUse it before releasing retention to a vendor to see how much is still held per vendor or project.
ExampleWhen PRJ-0042 reaches 80% completion in October 2026, BEAT's project accountant runs the report by vendor for V-1020: 3,000.00 was retained on phase 1 and 900.00 on phase 2, and 300.00 is due for release under term VRT-20.
Vendor 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 › Vendor payment retention
Set up firstVendor payment retention terms Microsoft Learn
Used next byVendor invoices with retention Microsoft Learn
Related pagesPurchase orders with retention 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.

When to run it

When to run itBefore you release retained amounts to a vendor, or when a project reaches a percentage of completion set in the vendor retention terms.
How oftenOn demand, at project milestones or before vendor payments are released.
What the output showsAmounts retained from vendor invoices, summarized by vendor or by project. A vendor with no retention usually has no vendor retention terms on the project's Vendor agreements.

Source: Microsoft Learn

Setup steps on this page

Choose the assessment level for Vendor payment retention

Show the retained vendor amounts at the level you release them.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Retention reports > Vendor payment retention.
  2. Under Include project types, turn on the project types you want: Time and material, Fixed-price, Investment, Cost project or Internal.
  3. Under Layout, set Assessment to organize the report by vendor or by project, and choose a Vendor or Project to narrow it.
  4. Enter the From date and To date under Date, run the report, and compare the retained amounts with the vendor retention terms on the project.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
AssessmentChoose whether the report is organized by vendor or by project.Microsoft Learn
VendorLimit the report to one vendor when it is organized by vendor.Microsoft Learn
ProjectLimit the report to one project when it is organized by project.Microsoft Learn
From dateSet the start of the date range.Microsoft Learn

Common errors and fixes

MessageWhat to do
A vendor shows no retention on a project.No vendor retention terms are on the project's Vendor agreements for that vendor (or its vendor group); add the term there. Retention applies to purchase orders created afterwards. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Choose the assessment level for Vendor payment retentionSet Assessment to Vendor and select the vendor you plan to pay, with the date range from the start of the project.Retention terms are applied per vendor (or vendor group) on the project's Vendor agreements and released by percentage of completion, so a vendor view shows what that vendor is still owed.At which level do you review vendor retention?Using a date range of only the last period: retention from earlier phases is then left out although it is still held.Test: Vendor payment retention shows the phase 1 retention

Feature management and licence

Licence or add-inOn the live system, Project manager and Project accountant 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: the report changes no data: The vendor retention report only reads vendor invoice data; it changes nothing. Microsoft Learn
If you change it laterThe report reads retained amounts on posted vendor invoices. A change to the retention terms or to the project's Vendor agreements applies to purchase orders and invoices created afterwards, so amounts already retained stay as they are. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:PSAVendorRetention Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject accountant ProjProjectAccountantGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:PSAVendorRetention
Data migrationLoad order: Vendor payment retention has no data entity in Data management: the menu item PSAVendorRetention 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
Everyone

8Sources