web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Supplier invoice transaction report with payment date if invoice is paid

(2) ShareShare
ReportReport
Posted on by 6
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)
  • Suggested answer
    Vahid Ghafarpour Profile Picture
    11,928 Super User 2025 Season 2 on at
    Supplier invoice transaction report with payment date if invoice is paid
    You need to do customization for your requirements.
     
    And you need to get max of invoice payment days to show the last payment date for one invoice.
  • Verified answer
    BillurSamdancioglu Profile Picture
    18,192 Most Valuable Professional on at
    Supplier invoice transaction report with payment date if invoice is paid
    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.
  • Verified answer
    Ramit Paul Profile Picture
    22,778 Most Valuable Professional on at
    Supplier invoice transaction report with payment date if invoice is paid
    Hi,
     
    This is a SSRS report, any extra field requires customization.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans