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)

Sort by

Verified answer

Ramit Paul 22,809 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 21,399 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,278 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