web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bank Reconciliation Fi...
Small and medium business | Business Central, N...
Answered

Bank Reconciliation Filter not working

(0) ShareShare
ReportReport
Posted on by Christine Galloways 35

I am halfway through a bank reconciliation and on opening it this morning I find that the Show Nonmatched only shows the nonmatched bank statement lines, not the ledger entries side. These remain all visible but the ones previously matched are in green. I also cannot filter the ledger entries; I can only sort by ascending or descending. I have over 2,500 ledger entries so completing the reconciliation is going to be very time consuming. 

Any advice?

Thanks.

I have the same question (0)
  • Agazziz Profile Picture
    Agazziz 213 on at

    Did your environment update recently to 21.1?

    I am seeing the same issue this week - after updating to Business Central version 21.1.  My Microsoft Partner says that Microsoft hasn't seem many complaints about this, so a hotfix isn't likely - so please report it to your Partner - the more complaints that Microsoft gets, the more likely they are to fix the issue.  

    I'm also seeing an error where I can't un-match transactions in the bank rec after the update, getting the following error: "Statement No. must be equal to 'BANKREC000001' in Check Ledger Entry: Entry No.=138. Current value is ''.  I'm seeing this on all bank entries that were posted by Check Ledger Entry - it's preventing me from un-doing a bank rec match, and preventing me from posting my bank rec.  This issue is also related to the most recent update, and I can't figure out how to fix it...

  • Christine Galloways Profile Picture
    Christine Galloways 35 on at

    Thank you Agazziz for your reply - I'm glad it's not just me! I have emailed my client to ask them to contact their Microsoft Partner.

    I don't use the check ledger function, just come right out, post a journal and go back in again so I'm not getting the error message. I have managed to un-match and rematch transactions but they have been posted as Payment Journals by the accounts team. How frustrating for you! I hope you manage to resolve it.

  • Instukem Profile Picture
    Instukem 15 on at

    Hi Christine,

    I am have the same issue... very frustrating! I hope they fix this bug very quickly....

    If anybody figures out a work around please share

    Nadine

  • Instukem Profile Picture
    Instukem 15 on at

    Hi Christine,

    I am have the same issue... very frustrating! I hope they fix this bug very quickly....

    If anybody figures out a work around please share

    Nadine

  • Janey Profile Picture
    Janey 15 on at

    Thanks for letting us know.

    Is there a workaround while we are waiting for the hotfix?

    Thanks

  • Christine Galloways Profile Picture
    Christine Galloways 35 on at

    We have reported the issue to our MS Partner and to quote, the problem is "under discussion, the Product Manager has been involved and we are working to understand how to proceed with this problem after the changes applied to the Bank account reconciliation feature".

     So hopefully good news soon.

    With regards to a workaround, I'm not sure there is one at the moment. I have exported the ledger entries into Excel then sorted by TRUE/FALSE to bring up only the unreconciled items. From there I can search for the corresponding bank statement entries.

    The sort function within the Business Central bank rec works and it seems that although the filter function does not work, if you filter by a specific date it takes you to that date and shows all transactions onwards.

  • Christine Galloways Profile Picture
    Christine Galloways 35 on at

    The bugs should now be fixed. Just run the November bank rec and all is working as expected.

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at

    Thank you for reporting and sharing details with the community.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,098

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,556 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,108 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans