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

Issue posting bank reconciliation

(0) Share

Report

Posted on by kjjson

We are trying to post a bank reconciliation. The amount difference is 0, but we get a message "Remaining amount must be equal to -184831.05 in Bank Account Ledger Entry: Entry No. 10771. Current value is -38580.37" I am unsure what this error means, or how to go about correcting it so we can post the bank reconciliation. Any assistance?

Thanks,

All responses (10)

Answers (0)

Community member 2 on at

Like (0)

Report

Issue posting bank reconciliation

I'm having this exact same issue. What fixed it?
Suggested answer

DAnny3211 9,274 Moderator on at

Like (0)

Report

RE: Issue posting bank reconciliation

hi

look this

www.youtube.com/watch

DAniele
Suggested answer

Amit_Sharma 2,545 on at

Like (0)

Report

RE: Issue posting bank reconciliation

Hi,

Adding info

https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-reconcile-bank-accounts-separately

Regards
Amit Sharma
www.erpconsultors.com
Press Yes if Info is useful
DJAGASSAR 46 on at

Like (0)

Report

RE: Issue posting bank reconciliation

Hi,

What version? I believe this error occurs when matching many bank lines to 1 bank ledger entry.
Dallefeld 173 User Group Leader on at

Like (0)

Report

RE: Issue posting bank reconciliation

Do you have an entry in the bank rec for -184831.05?
kjjson on at

Like (0)

Report

RE: Issue posting bank reconciliation

There are no customizations. Here is the applied information (or is there something else that is needed?
Alfredo_Iorio 1,260 on at

Like (0)

Report

RE: Issue posting bank reconciliation

Thanks.

That was going to be my next question.

What is the applied amount to that entry in your Bank rec?

Do you have any customisation on your Bank module?
kjjson on at

Like (0)

Report

RE: Issue posting bank reconciliation

A little more information, I looked at the entry in the bank ledger table, and the amount is the -38580.37, so I have no idea where the -184831.05 is coming from or how to update it.
kjjson on at

Like (0)

Report

RE: Issue posting bank reconciliation

Here is a screen shot. Thank you for your assistance
Alfredo_Iorio 1,260 on at

Like (0)

Report

RE: Issue posting bank reconciliation

Hi.

The error is about the remaining amount on a single Bank ledger entry. Therefore, you need to check the application of the bank account statement line to the ledger entry.

This could be because an existing application to a payment journal was done manually and resulted in the remaining amount being higher than the bank account statement line.

Can you share a screenshot of your Bank Rec? That might help