BeyondERP.Newsletter
Menu

Inquiry page · Project management and accounting

Vendor invoices with pay when paid

An inquiry page that lists vendor invoices under pay-when-paid terms, where you can release invoice lines for payment.

Used by
Project accountant, Project manager
Business process
Manage project financials
Menu item
PSAPwpInvoiceInquiry
Main table
VendTrans
Data entity
VendPaymentBIVendTrans
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 page that lists vendor invoices under pay-when-paid terms, where you can release invoice lines for payment.
What you do hereUse this page to release vendor invoice lines for payment when the customer has paid, or to override the pay-when-paid terms.
ExampleBEAT buys 20 laptops for 18,000.00 EUR from vendor V-3300 for customer project PRJ-0071 under pay-when-paid terms; when the customer pays its invoice, the project accountant finds the vendor invoice here and releases its lines, so Ready for payment changes to Yes.
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 inquiries › Vendor invoices with pay when paid
Set up firstAll projects Microsoft Learn
Used next byVendor invoices with pay when paid (report) Microsoft Learn
Related pagesVendor invoices with 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.

Setup steps on this page

Release pay-when-paid vendor lines after the customer pays

Make vendor invoice lines payable once the customer's payment is received.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Retention inquiries > Vendor invoices with pay when paid.
  2. Enter values in the search field to find the vendor invoice, and then select Search.
  3. On the Vendor invoice lines FastTab, select the lines that you want to change.
  4. If the pay-when-paid conditions are met for a line, select Release vendor payment.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Pay when paidShows that the invoice line is held until the customer pays; it's cleared when you release the payment.Microsoft Learn Yes
Ready for paymentShows whether the invoice line can now be paid; it changes to Yes when you release the payment.Microsoft Learn NoReadyForPayment

Common errors and fixes

MessageWhat to do
The vendor invoice can't be paid although goods were received.Under pay-when-paid terms the line is held until the customer pays; release it here, or override the terms if the vendor must be paid first. Microsoft Learn

Test checklist

  1. Post a vendor invoice of 18,000.00 EUR under pay-when-paid terms on PRJ-0071.
  2. Search it on this page and check Ready for payment is No.
  3. Release the vendor payment on its lines.
  4. Check Ready for payment is Yes.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Release pay-when-paid vendor lines after the customer paysSearch the vendor invoice, select the lines whose customer invoice is paid, and select Release vendor payment.Pay-when-paid holds the vendor line until the customer pays; releasing early takes on the cash risk the terms were meant to avoid.When may a pay-when-paid line be released before the customer pays?Releasing all lines of the invoice when the customer paid only part of its invoice.Test: Release sets ready for payment

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: each legal entity has its own records. Microsoft data model
Can it be undonePartly reversible: Searching changes nothing; a released line is ready for payment and is picked up by the next payment proposal. Microsoft Learn
If you change it laterReleasing a line clears the pay-when-paid hold and sets it ready for payment, so the next vendor payment run picks it up. Microsoft Learn
Technical architect

6Technical

Menu itemPSAPwpInvoiceInquiry Checked in Dynamics 365
FormPSAPwpInvoiceInquiry Checked in Dynamics 365
TableVendTransShown as “Vendor transactions” in Record infoKey field: AccountNum, Voucher, TransDateChecked in Dynamics 365
Data entitiesVendPaymentBIVendTransVendor transactions Microsoft data model
Who can open itPrivilegesInvoice Inquiry for Pay When Paid PSAPwpInvoiceInquiryMaintain invoices for pay when paid PSAPwpInvoiceInquiryMaintainDutiesVendor invoices PSAPwpInvoiceInquiry
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, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PSAPwpInvoiceInquiry
Integrate withVendPaymentBIVendTrans data entity Microsoft data model
Data migrationVendPaymentBIVendTrans Vendor transactions; read for analysis, not used to set pay-when-paid holds.Load order: Pay-when-paid holds come from vendor invoices posted under PWP terms; migrate open vendor invoices first, then set the project's PWP terms before new invoices are posted.Microsoft Learn
Table definitionVendTrans columns and relations Microsoft data model
Everyone

8Sources