Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Supplier invoice transaction report with payment date if invoice is paid

(1) 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.
 
  • Suggested answer
    VaHiX Profile Picture
    VaHiX 3,976 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
    BillurSamdancioglu 16,312 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
    Ramit Paul 22,295 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans