An inquiry, titled Inquiry for vendor retained payments, that lists project purchase orders with vendor retention, showing project, vendor, invoice amount, retained amount and vendor payable amount for a date range.
Project management and accountingInquiries and reportsRetention inquiries
PSASubContractRetainage
Used by
Project accountant, Project manager
Business process
Manage project financials
Menu item
PSASubContractRetainage
Main table
PSATmpSubcontractRetainage
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, titled Inquiry for vendor retained payments, that lists project purchase orders with vendor retention, showing project, vendor, invoice amount, retained amount and vendor payable amount for a date range.
What you do here
Use it to answer 'how much have we retained from each subcontractor, per purchase order, and what do we still owe them?'
Example
BEAT's subcontractor V-2040 has invoiced 15,000.00 EUR on PO-0912 for PRJ-0042; with 20.00 percent retention until 50.00 percent completion, the inquiry shows 3,000.00 EUR retained and 12,000.00 EUR vendor payable.
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
Check retention per subcontract
See retained and payable amounts on each project purchase order.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Retention inquiries > Purchase orders with retention.
Enter From date and To date, then select a Vendor, Project or Purchase order; select Include subprojects for project hierarchies.
Select Search and read Invoice amount, Retained amount and Vendor payable for each purchase order.
When the project reaches the completion stage in the retention terms, release the amount on Vendor invoices with retention.
The period of vendor invoices to include.Checked in Dynamics 365
1 October to 31 October
Include subprojects
Also includes purchase orders on subprojects of the selected project.Checked in Dynamics 365
Selected
Retained amount
The part of the invoiced amount held back under the vendor retention terms.Microsoft Learn
3,000.00
Vendor payable
The invoiced amount less retention: what the vendor is paid now.Microsoft Learn
12,000.00
Common errors and fixes
Message
What to do
A purchase order has no retention although the vendor agreed to it.
Retention terms apply through the project's Vendor agreements; add the vendor or vendor group there before the purchase order is created. Microsoft Learn
Test checklist
Apply 20.00 percent vendor retention terms to V-2040 on PRJ-0042.
Post a vendor invoice of 15,000.00 EUR on PO-0912.
Search the inquiry on PO-0912.
Check 3,000.00 EUR retained and 12,000.00 EUR vendor payable.
Search by Project with Include subprojects selected, for the whole contract period.Retention is held per vendor invoice; a short date range shows only part of what is retained.
Retention terms apply to purchase orders created for the vendor on that project; changing the terms later doesn't recalculate orders already invoiced. Microsoft Learn
Technical architect
6Technical
Menu item
PSASubContractRetainageChecked in Dynamics 365
Form
PSASubContractRetainageChecked in Dynamics 365
Table
PSATmpSubcontractRetainageShown as “Subcontract/Retainage” 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 Purchase orders with retention inquiry has no data entity in Data management: it calculates from purchase orders and vendor invoices. Vendor retention terms load with ProjVendorRetentionTermEntity; apply them to projects before migrating open purchase orders.Load first: Project vendor retention term (ProjVendorRetentionTermEntity)Microsoft data model