How to determine unapplied payments & how to correct

(0) Share

Report

Posted on 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!

I have the same question (0)

All responses (4)

Answers (0)

Sort by

yohi2020 245 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Laci De Luca 15 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
yohi2020 245 on at

Like (0)

Report
Copy link

Link copied!

Choose Payment in Type and click Process > Apply Entries.

Was this reply helpful? Yes No
Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Just apply the missed invoice to the balance of the payment that has not been applied.

Was this reply helpful? Yes No