BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Vendor invoices with pay when paid

A report that lists project vendor invoices under pay-when-paid terms for a date range, optionally for one vendor, project or project contract, so you can see which vendor lines wait for the customer's payment.

Business process
Manage project financials
Menu item
output:PSAPayWhenPaid
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 lists project vendor invoices under pay-when-paid terms for a date range, optionally for one vendor, project or project contract, so you can see which vendor lines wait for the customer's payment.
What you do hereUse it when customer payments come in on pay-when-paid projects, to decide which vendor invoice lines you can release for payment.
ExampleBEAT's project accountant lists pay-when-paid vendor invoices dated 2026-10-01 to 2026-10-31 for PRJ-0042: VI-20877 from V-1020 for 9,000.00 still waits, because the customer has paid 42% of invoiced amounts against a 50% threshold.
Vendor invoices with pay when paid 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 reports › Vendor invoices with pay when paid
Set up firstAll projects (Vendor agreements with the PWP threshold percentage) Microsoft Learn
Used next byVendor invoices with pay when paid Microsoft Learn
Related pagesVendor payment 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 itWhen a vendor asks for payment on a project with pay-when-paid terms, before you decide which vendor invoice lines to release.
How oftenOn demand, when customer payments for pay-when-paid projects come in.
What the output showsVendor invoices with pay when paid in the date range, with the retention summary by vendor. An invoice still listed after the customer paid usually means its lines weren't released with Release vendor payment.

Source: Microsoft Learn

Setup steps on this page

List pay-when-paid vendor invoices per project

See which vendor invoice lines wait for customer payment on one project.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Retention reports > Vendor invoices with pay when paid.
  2. Under Date, enter the From date and To date of the vendor invoices to list.
  3. Under Layout, keep the summary field on Vendor to group the invoices by vendor; on this dialog that field carries the label Customer payment retention summary although the report lists vendor invoices.
  4. Choose a Vendor account, Project or Project contract to list only the pay-when-paid invoices for one of them, then run the report.
  5. For each line that still waits, check the customer payments on the project; when the threshold is met, release the line on the Vendor invoices with pay when paid inquiry.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
From dateFirst date of the vendor invoices to list.Checked in Dynamics 3652026-10-01
To dateLast date of the vendor invoices to list.Checked in Dynamics 3652026-10-31
Customer payment retention summaryLayout field that sets how the vendor invoices are grouped; it proposes Vendor. The label is the one shown on this dialog, even though the report is about vendor invoices.Checked in Dynamics 365Vendor
Vendor accountLimit the report to one vendor's pay-when-paid invoices.Checked in Dynamics 365V-1020
ProjectLimit the report to the pay-when-paid invoices of one project.Checked in Dynamics 365PRJ-0042
Project contractLimit the report to the projects of one project contract.Checked in Dynamics 365PC-0042

Common errors and fixes

MessageWhat to do
An invoice is still listed after the customer paid.The pay-when-paid condition is cleared only when the line is released: open Vendor invoices with pay when paid, select the line and select Release vendor payment. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
List pay-when-paid vendor invoices per projectFilter on the Project (or Project contract) whose customer has just paid, keep the summary on Vendor, and use the date range since the project started.The PWP threshold is set per project, so the customer payments of that project decide which of its vendor lines can be released.How do you decide what to release?Treating the report as the release: listing changes nothing; the line stays on hold until Release vendor payment is selected on the inquiry.Test: Pay-when-paid invoice is listed until released

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 report only lists pay-when-paid invoices; it releases nothing. Microsoft Learn
If you change it laterThe report only lists invoices; releasing is done on the inquiry. The PWP threshold percentage comes from the project's Vendor agreements and is copied to purchase order lines, so a threshold change affects only purchase orders created afterwards. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:PSAPayWhenPaid 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:PSAPayWhenPaid
Data migrationLoad order: Vendor invoices with pay when paid has no data entity in Data management: the menu item PSAPayWhenPaid 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