How to determine unapplied payments & how to correct

Like (0) Share

Report

Posted on 18 Mar 2021 14:16:06 by Laci De Luca

Hello! My company is new to Dynamics business central, and we have been struggling a bit to navigate and get things done the proper way.

One issue we have is: we have entered deposits(payments) from our customers, but it seems that the associated dollars did not stick or apply to the corresponding invoices. This is making our AR much higher than it actually is.

What is the easiest way to run a list of this scenario for all customers? And what is the best way to correct this?

Here is an example:

This is within the customer ledger entries screen (sorry if it's blurry):

showing payments, and as you can see, most have a remaining amount of $0. However, some still have the same amount remaining as the original deposit.

Any help is appreciated. Thank you!

All responses (4)

Answers (0)

Dallefeld 175 User Group Leader on 19 Mar 2021 at 16:05:36

Like (0)

Report

RE: How to determine unapplied payments & how to correct

Just apply the missed invoice to the balance of the payment that has not been applied.
yohi2020 245 on 19 Mar 2021 at 11:24:41

Like (0)

Report

RE: How to determine unapplied payments & how to correct

Choose Payment in Type and click Process > Apply Entries.
Laci De Luca 15 on 18 Mar 2021 at 17:16:50

Like (0)

Report

RE: How to determine unapplied payments & how to correct

Great I'll give this a shot, thank you!

What if a payment covered 5 invoices, and we only initially selected 4. Will we have to unapply the whole payment and reapply, or just apply the missed invoice?
yohi2020 245 on 18 Mar 2021 at 15:58:51

Like (0)

Report

RE: How to determine unapplied payments & how to correct

Hi Laci,

I don't know how many are remained. But you can use Apply Entries from Process on the menu in Customer Ledger Entries.

If there are payment entries from a customer, the list will be shown in the opened window.