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

Last Invoice's payment

(0) Share

Report

Posted on by MarisolC

103

I need to know last amount and date paid by my customer for each invoice, and also if certain document has been fully paid when that happend. Where can I look for this info?

I need to pull al the information by invoice by customer at certain date.

Thanks in advance.

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Sort by

Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

Customer ledger entries and detailed customer ledger entries are the data sources to use
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

And on the Customer Ledger Account you can look at the Open field to see if the invoice is fully paid or not.

Remaining amount will tell you how much is unpaid.

Closed by will tell you what document no. the invoice was fully paid from.
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Marisun,

You can look here:

Customer List - Fact Box and Customer Card Fact Box

Credit Management -

Hope this helps.

Thanks,

Steve
Suggested answer

YUN ZHU 103,103 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, The easiest way is to use Customer Ledger Entries, you can add the filters you need.

PS: You can also save your filters as a new view.

https://docs.microsoft.com/en-us/dynamics365/business-central/ui-views

Hope this will help.

Thanks.

ZHU