An inquiry that lists project vendor invoices where part of the payment is retained, with their lines and retained amounts, and where retained amounts are released for payment.
Project management and accountingInquiries and reportsRetention inquiries
PSAVendorPaymentRetentionRelease
Used by
Project accountant, Project manager
Business process
Manage project financials
Menu item
PSAVendorPaymentRetentionRelease
Main table
PSATmpVendInvoiceTable
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 project vendor invoices where part of the payment is retained, with their lines and retained amounts, and where retained amounts are released for payment.
What you do here
Use it to answer 'which retained vendor amounts can we release now?' when a project or an agreed share of the work is complete.
Example
BEAT's training project PRJ-0063 reaches 80.00 percent completion; the project accountant searches vendor V-2040 and releases 10.00 percent of the 3,000.00 EUR retained in phase 1, so 300.00 EUR becomes payable with the 9,000.00 EUR phase 2 invoice less 900.00 EUR new retention.
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
Release retained vendor amounts at a completion stage
Release the share of retention that the terms allow when the project reaches a stage.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Retention inquiries > Vendor invoices with retention.
Enter the date range and the Vendor or Project, then select Search.
Select an invoice in Vendor invoices to see its lines and the retained amount on each.
Release the retained amount for the lines whose completion stage is reached, and check the payable amount before the next payment run.
Search by Project, select the invoices of the completed phase, and release the percentage in the retention terms.Each terms line sets a completion percentage, a retention percentage and a release percentage; releasing more than the terms allow pays the vendor early.
On the live system, Project manager and Project accountant maintain this page.
Checked in Dynamics 365
Solution architect
5Design impact
Shared or per company
Per company: retained amounts belong to the legal entity of the project and its contract. Microsoft data model
Can it be undone
Partly reversible: Searching changes nothing; a release makes the amount payable and is undone only by a correction on the vendor side. Microsoft Learn
If you change it later
Released retention lines are not chargeable by default, so they can't be added to a customer invoice proposal; releasing makes the amount payable to the vendor. Microsoft Learn
Technical architect
6Technical
Menu item
PSAVendorPaymentRetentionReleaseChecked in Dynamics 365
Form
PSAVendorPaymentRetentionReleaseChecked in Dynamics 365
Table
PSATmpVendInvoiceTableShown as “Temporary vendor invoices” in Record infoChecked in Dynamics 365
To set it up or change itProject manager ProjProjectManagerProject accountant ProjProjectAccountantGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page
Options: Personalize, Page options, ShareChecked in Dynamics 365
Load order: The Vendor invoices with retention inquiry has no data entity in Data management: it fills a temporary table from posted vendor invoices. Load retention terms with ProjVendorRetentionTermEntity; amounts retained in a former system are paid there or settled before go-live.Load first: Project vendor retention term (ProjVendorRetentionTermEntity)Microsoft data model