News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Detailed Customer entr...

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

Suggested answer

Detailed Customer entries report

(0) Share

Report

Report

Posted on by Lee Raz-Nick

10

Hi

I'm looking for a report that will show all sales invoices per customer and the date that they were paid.

Currently i'm having to drill down on each invoice and select Detailed Customer Ledger Entries to see the allocation date.

I was hoping for a report that would show invoice details and also the payment date and ref of the allocation for that invoice all same the same row. eg.

Posting Date , Document Type, Document No./External Doc.No., Description, Amount, Remaining Amount, Balance (LCY), Payment Date, Payment Ref=Document No./External Doc.No

Many thanks

Lee

Categories:

Dynamics 365 Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Vaishnavi J 3,060 on at

Like (0)

Report

RE: Detailed Customer entries report

Hi ,

You can search Customer Detail Trial balance report which will pull invoice and payment details of the customers.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

Helpful resources

Quick Links

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

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans