Supplier invoice transaction report with payment date if invoice is paid

(2) Share

Report

Posted on by AZ-04091349-0

Hi,

I have a question regarding the invoice reports in D365. In the "Supplier Invoice Transaction Report," I can retrieve data about:

- Customer
- List of invoices with:
- Due date
- Amount

However, I also need to include the payment date if the invoice has been paid. How can I achieve this? Is it possible to do this without creating a custom data entity and report?

Thank you.

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

This is a SSRS report, any extra field requires customization.

Was this reply helpful? Yes No
Verified answer

BillurSamdancioglu 20,713 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can not. It is because of the rule that one invoice may not be paid by just one payment. More than one is possible. Also you can not change a report without a development.

Was this reply helpful? Yes No
Suggested answer

Vahid Ghafarpour 12,228 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You need to do customization for your requirements.

Customize Electronic reporting configurations to generate an electronic document - Finance & Operations | Dynamics 365 | Microsoft Learn

And you need to get max of invoice payment days to show the last payment date for one invoice.

Was this reply helpful? Yes No