Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

invoice payment dates report

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    Dallefeld Profile Picture
    175 User Group Leader on at
    RE: invoice payment dates report

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

  • Suggested answer
    YUN ZHU Profile Picture
    85,670 Super User 2025 Season 1 on at
    RE: invoice payment dates report

    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

  • vikasc Profile Picture
    5 on at
    RE: invoice payment dates report

    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
    DAnny3211 Profile Picture
    9,278 Moderator on at

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans