Small and medium business | Business Central, N...

invoice payment dates report

(0) Share

Report

Posted on by vikasc

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)

All responses (4)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

look this

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

DAniele

Was this reply helpful? Yes No
vikasc 5 on at

Like (0)

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,593 Super User 2025 Season 2 on at

Like (0)

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.

Hopefully other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

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.

Was this reply helpful? Yes No