BeyondERP.Newsletter
Menu

Inquiry page · Project management and accounting

Purchase orders with retention

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.

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 isAn 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 hereUse it to answer 'how much have we retained from each subcontractor, per purchase order, and what do we still owe them?'
ExampleBEAT'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.
Purchase orders with 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 processManage project financials
Menu pathProject management and accounting › Inquiries and reports › Retention inquiries › Purchase orders with retention
Set up firstVendor payment retention terms Microsoft Learn All projects (vendor agreements) Microsoft Learn
Used next byVendor invoices with retention Microsoft Learn
Related pagesVendor 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 retention per subcontract

See retained and payable amounts on each project purchase order.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Retention inquiries > Purchase orders with retention.
  2. Enter From date and To date, then select a Vendor, Project or Purchase order; select Include subprojects for project hierarchies.
  3. Select Search and read Invoice amount, Retained amount and Vendor payable for each purchase order.
  4. When the project reaches the completion stage in the retention terms, release the amount on Vendor invoices with retention.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
From date / To dateThe period of vendor invoices to include.Checked in Dynamics 3651 October to 31 October
Include subprojectsAlso includes purchase orders on subprojects of the selected project.Checked in Dynamics 365Selected
Retained amountThe part of the invoiced amount held back under the vendor retention terms.Microsoft Learn 3,000.00
Vendor payableThe invoiced amount less retention: what the vendor is paid now.Microsoft Learn 12,000.00

Common errors and fixes

MessageWhat 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

  1. Apply 20.00 percent vendor retention terms to V-2040 on PRJ-0042.
  2. Post a vendor invoice of 15,000.00 EUR on PO-0912.
  3. Search the inquiry on PO-0912.
  4. Check 3,000.00 EUR retained and 12,000.00 EUR vendor payable.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check retention per subcontractSearch 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.How are vendor retention terms applied?Reading Vendor payable as the amount still to pay in total; retained amounts are paid later on release.Test: Retention on a vendor invoice

Feature management and licence

Licence or add-inOn the live system, Project manager and Project accountant maintain 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 laterRetention 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 itemPSASubContractRetainage Checked in Dynamics 365
FormPSASubContractRetainage Checked in Dynamics 365
TablePSATmpSubcontractRetainageShown as “Subcontract/Retainage” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain vendor retention PSAVendorRetentionProjAccountantInquire vendor retention PSAVendRetentionInquireMaintain vendor retention PSAVendRetentionProjManagerDutiesMaintain vendor retention PSAVendorRetentionProjAccountantMaintain vendor retention PSAVendRetentionProjManager
2 security rolesProject accountant ProjProjectAccountantProject manager ProjProjectManager
Checked in Dynamics 365
Roles to set it up and use itTo 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 pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PSASubContractRetainage
Data migrationLoad 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
Everyone

8Sources