BeyondERP.Newsletter
Menu

Inquiry page · Project management and accounting

Vendor invoices with retention

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.

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 isAn 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 hereUse it to answer 'which retained vendor amounts can we release now?' when a project or an agreed share of the work is complete.
ExampleBEAT'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.
Vendor invoices 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 › Vendor invoices with retention
Set up firstVendor payment retention terms Microsoft Learn All projects Microsoft Learn
Used next byProject invoice proposals Microsoft Learn
Related pagesVendor invoices with pay when paid 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

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

  1. Go to Project management and accounting > Inquiries and reports > Retention inquiries > Vendor invoices with retention.
  2. Enter the date range and the Vendor or Project, then select Search.
  3. Select an invoice in Vendor invoices to see its lines and the retained amount on each.
  4. Release the retained amount for the lines whose completion stage is reached, and check the payable amount before the next payment run.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
From date / To dateThe period of vendor invoices to search.Checked in Dynamics 3651 January to 31 December
Vendor / Project / Vendor invoice / Purchase orderFilters for the search; select at least one, then Search.Checked in Dynamics 365V-2040
Retained amountOn the Vendor invoice lines section: the amount held back on each line.Microsoft Learn 3,000.00
Percentage to releaseFrom the retention terms: the share of previously retained amounts released at a completion stage.Microsoft Learn 10.00

Common errors and fixes

MessageWhat to do
A released retention line can't be added to a customer invoice proposal.Released retention lines are nonchargeable by default; change the line property if the customer is to be billed. Microsoft Learn

Test checklist

  1. Post a vendor invoice of 15,000.00 EUR with 20.00 percent retention on PRJ-0063.
  2. Search the inquiry on V-2040 and select the invoice.
  3. Check 3,000.00 EUR retained on its lines.
  4. Release it and check that the retained amount becomes payable.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Release retained vendor amounts at a completion stageSearch 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.Who releases retained vendor amounts?Expecting released retention to flow to the customer invoice; it is nonchargeable by default.Test: Release makes retention payable

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 undonePartly 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 laterReleased 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 itemPSAVendorPaymentRetentionRelease Checked in Dynamics 365
FormPSAVendorPaymentRetentionRelease Checked in Dynamics 365
TablePSATmpVendInvoiceTableShown as “Temporary vendor invoices” 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=PSAVendorPaymentRetentionRelease
Data migrationLoad 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
Everyone

8Sources