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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / invoice payment dates ...
Small and medium business | Business Central, N...
Suggested Answer

invoice payment dates report

(0) ShareShare
ReportReport
Posted on by vikasc 5

Hi Team,

I am struggling to get  a report where I can see the invoice number, along with the PAYMENT DATE of the invoice. I went to detailed customer ledger entries, customer ledger entries, customer trail balance, but none of these reports were serving the purpose. is there any work around for this issue, so that I will be able to generate a single report of invoice with its payment dates.

thanks in advance

Vikas

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,417 Super User 2026 Season 1 on at

    hi

    look this

    community.dynamics.com/.../how-do-i-look-for-the-payment-date-of-a-posted-purchase-invoice

    DAniele

  • vikasc Profile Picture
    vikasc 5 on at

    Thank you for the reply daniele. I have been to those reports already. the problem i was facing was, there is no single place where i can map the invoice number with the payment date. in customer receipts, and customer ledger entries, the document number showing is the number we have given in our "no series". if at all it is possible to fetch the invoice number in that area, the problem would have been solved i guess

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,086 Super User 2026 Season 1 on at

    Hi, as far as I know, there is no directly available Payment Date in BC. If it is Due Date, you can find it in Customer Ledger Entries. But the Payment Date you mentioned may be the actual payment date, one invoice may correspond to multiple Payment Dates, and there is also the case of prepayment.

    You can search for Applied Cust. Ledger Entry No. in Detailed Customer Ledger Entries to find the actual date, but it's a bit cumbersome.

    pastedimage1669765224249v1.png

    Hopefully other experts can give you better advice.

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 229 User Group Leader on at

    I think @zhu is correct, the only place to get the payment date is to see the Applied Customer Ledger Entry's posting date.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,005 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,148 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans