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

How to Track Overpayment Received from Customers in Business Central

(2) Share

Report

Posted on by PS-20050952-0

Hello,

My client requires a solution to track overpayments received from customers against specific posted sales invoices for reporting purposes. As a functional consultant, I need to guide our technical consultant on how to identify and retrieve overpayment details from the system, specifically from the Customer Ledger Entries.

Scenario:

A customer makes a payment via the Cash Receipt Journal.
The posted invoice amount is ₹100, but the customer pays ₹125 against the invoice.
This results in an additional payment of ₹25, which needs to be tracked as an overpayment.

Client Requirement:
The client wants to:

Track and identify the overpayment received (₹25 in this case) against the specific posted sales invoice in Customer Ledger Entries.
Reflect this information in a custom report for better visibility.

I would appreciate guidance on:

How to identify overpayments in Customer Ledger Entries.
Any specific fields or methods that could help track and segregate such entries.
Suggestions on handling such cases functionally to streamline reporting for overpayments.

Looking forward to your inputs.

Thank you!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Valentin Castravet 31,485 Super User 2025 Season 2 on at

Like (0)

Report

In the customer ledger entries the payment line would have a value of 25 in the remaining amount field. Its status would be open as well. You would also see this entry in the customer statement or AR aging report.

I can't think of common scenarios where a payment line would be unapplied and hence have the status of open, and the remaining amount would not equal the entire amount. These 2 should things should make it pretty clear which lines are from overpayments.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,367 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Refund a customer overpayment in Microsoft Dynamics 365 Business Central

Dynamics 365 Business Central – Write off overpayments and underpayments using Payment Tolerance

Payment tolerance and payment discount tolerance - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

As Valentin mentioned, this data can be searched in Customer Ledger Entries, but until Apply is executed, there is no way to determine that 25 out of 125 are overpayments.

If you know this when you create the Cash Receipt Journal, you can add a field to record and pass this value to the Customer Ledger Entries. This will make it easier when creating reports.

Hope this can give you some hints as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,614 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps as well: https://community.dynamics.com/forums/thread/details/?threadid=424fdc0d-d43f-4213-bfae-320dc8e8ebce

https://www.kristenhosman.com/2024/03/refund-customer-overpayment-in.html

Was this reply helpful? Yes No