Bank Reconciliation Issue

(2) Share

Report

Posted on by Peter Taylor FP

I have a Bank Account ledger entry that is showing as Closed (open = unticked), but I have NOT done a bank reconciliation for that transaction, so how can it show as closed? This means I cannot reconcile my bank account as the transaction is not showing on the right hand side of the bank reconciliation page (because the system is saying it is closed). I only have 1 bank account statement showing for the account (the opening balance bank reconciliation) and the transaction I am querying is NOT on that bank statement. Why is it showing as closed when I have not done a bank reconciliation for that transaction?

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

If you do not get further traction from the community, feel free to raise this issue to Microsoft via your partner or CSP.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

Check the fields on the ledger entry for statement number.

Check the status, was it voided.

BC doesn't just close a ledger entry, so it somehow was closed by a transaction.

Was this reply helpful? Yes No
Suggested answer

Amit 2,557 on at

Like (0)

Report

Hi,

Refer the below link.

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

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Peter Taylor FP 96 on at

Like (0)

Report

Hi, thanks for your feedback. The statement no. is '3', but there is no bank statement no. 3 for that account? Could it have been deleted?

Was this reply helpful? Yes No
Verified answer

Peter Taylor FP 96 on at

Like (0)

Report

As I thought, this was found to be a bug in standard MS code. The transaction had been reconciled, then an 'Undo' bank reconciliation was done but the transaction was not re-opened, which it should have been. MS support kindly gave me a utility (app) to re-open the entry (and delete the statement number on the bank account ledger entry), and i just used it to re-open the transaction and now i can reconcile it again.

Was this reply helpful? Yes No
DLDlutavia 12 on at

Like (0)

Report

How can I obtain this utility? Is it in the Partner Center or do we need to go through support?

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

HOPE THIS HELPS:https://community.dynamics.com/forums/thread/details/?threadid=1774169d-e6f2-4964-b086-d77f09baec9a

https://community.dynamics.com/blogs/post/?postid=81187d72-51b3-44ae-87a1-c173cca92f0e

Was this reply helpful? Yes No