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

How to unapply a payment applied to multiple entries in bulk

(0) Share

Report

Posted on by Finn1980

We have applied a large payment to a few thousand open sales invoices by mistake for a single customer. It's actually a duplicate. This customer is set with an automatic application method (apply to oldest). So when we applied this duplicate payment, it closed the oldest open invoices. We need to unapply this payment from these invoices and reverse it. The problem is I've only been able to unapply one invoice at a time. This would literally take all day. Is there a way to do this in bulk?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Chris,

I just made a payment in my Sandbox for 6 invoices/credit memos.

You can see I highlighted the Payment Line for the payment and clicked Process/Unapply Entries. It opens the Unapply Customer Entries page. I will now highlight all the rows to Unapply them against the invoices/credit memos leaving the payment open.

then all my Invoices/Credit Memos and the Payment show a remaining amount.

Now you can reverse the payment, since it was a duplicate.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Finn1980 21 on at

Like (0)

Report

Steve,

I appreciate you jumping in and responding to this. The way you described and presented this process was exactly what I expected to see when I tried it myself. However, when I select the payment to be unapplied, I only get one applied invoice line, not the entire list. Is there something I'm missing?

This shows only one applied entry available to unapply:

Here's the long list of applied entries:

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Chris,

After you highlighted the payment row for 310,419.xxand clicked Unapplied Entries the pic you show is filtered to Document No. PS-INV0398984, which is why the page only shows 2 lines. If you changed the Document No. to G02067 what appears? My document No. is 1000 and here is my pic:

If I click on Applied Entries I see this:

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Finn1980 21 on at

Like (0)

Report

Yes I noticed that as well. Nothing happens if I change that document number field. It seems something else is playing into this functionality. Does it matter how these were applied originally? I created an entry in the cash receipt journal and used the oldest first application method which is set on the customer card.

I really appreciate your help with this.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Chris,

I just ran a test in Cronus taking my Customer Payment Method Oldest to Newest and making a 1000.00 payment. I let BC do the application. This is what appears on my Unapply page for the entry:

I did another but each time I see the documents applied. Maybe a programmer can offer advise here.

Thanks,,

Steve

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

I am trying to use the Correction field 'checked' to unapply the payments in bulk but it is not working is there any better way to accomplish this.

Was this reply helpful? Yes No