Skip to main content

Notifications

Announcements

No record found.

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

Bank Reconciliation Filter not working

(0) ShareShare
ReportReport
Posted on by 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.

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Bank Reconciliation Filter not working

    Thank you for reporting and sharing details with the community.

  • RE: Bank Reconciliation Filter not working

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

  • RE: Bank Reconciliation Filter not working

    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.

  • Janey  Profile Picture
    Janey 15 on at
    RE: Bank Reconciliation Filter not working

    Thanks for letting us know.

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

    Thanks

  • Instukem Profile Picture
    Instukem 15 on at
    RE: Bank Reconciliation Filter not working

    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
    RE: Bank Reconciliation Filter not working

    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

  • RE: Bank Reconciliation Filter not working

    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.

  • Agazziz Profile Picture
    Agazziz 197 on at
    RE: Bank Reconciliation Filter not working

    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...

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans