Small and medium business | Business Central, N...

How do i look for the payment date of a Posted Purchase Invoice?

(0) Share

Report

Posted on by Basitah

Hi there,

As per my subject header, is there a way for me to look for the payment date of a Posted PI easily without having to go to Last payment date and then clicking on each individual payment for its applied entries?

Like if i go into Posted Purchase Invoice, and i just want to be able to know in one view the payment date. Is there a way for this?

I have been googling for a while but there seemed to be no direct or helpful solution for it, so not sure if im questioning it wrong.

Thanks in advance for answering!

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

In the GB version at least that insight does require drilldown. Adding a field would come with limitations as you can have multiple payments per invoice i.e. only one payment date could be shown.

An alternative to try out would be a report called Vendor - Payment Receipt (Report ID 411). It is set to review the data from the POV of the payment though. With some tweaking the report could at least output a view where you in one page all payments and invoices stacked together, singular or multiple. As standard if you know which supplier you want to review and a date range the existing report might be fine for you.

Was this reply helpful? Yes No
Basitah 36 on at

Like (0)

Report

Ah so bottomline is, there really isnt a way for me to have a "bird's eye view" of it.

Im from the Account Payables side though and we do have this Vendor Detail Trial Balance which pulls out the invoices and the payment altogether but im not sure if it's the microsoft system itself, or if it's my company's modfication, but i always will have to tweak, filter and sort to eventually get what i need.

but anyway, thanks, Josh. Appreciate the reply.

Was this reply helpful? Yes No
Suggested answer

Nilesh Parekh 15 on at

Like (0)

Report

"Closed at Date" on Vendor ledger entry can be used as Payment date to eliminate going into detailed entries in case of closed entries.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

There is a hidden field called Closed at Date in the Vendor Ledger Entry. You can create extension to expose that to the page.

Was this reply helpful? Yes No