Dynamics 365 Business Central: Bank Reconciliation Error - Statement Status 'Open'

By -

Overview

I recently ran across a new error message after undoing my previous months bank reconciliation in Business Central. I use the auto match functionality and noticed that the previous months ending balance was off, so decided to undo the previous month and redo it. When I attempted to match certain transactions I received the message below. 

Statement Status must be equal to 'Open' in Check Ledger Entry: Entry No.=30. Current value is 'Bank Acc. Entry Applied'.


Solution

After posting this error to Twitter I received a few comments on things to try and none of it worked. It wasn't until I googled the error message that I saw Tanya Henderson responded to a forum with a link to her fix. I was able to follow her instructions in this blog and was able to successfully complete the bank reconciliation with no issues.


Written by: Kristen Hosman, Microsoft MVP

Comments

Post a Comment

Popular posts from this blog

Microsoft Dynamics 365 Business Central: adding new licensed users to BC

By -
Image
Adding a new licensed user isn't hard to do within Business Central (BC).  Prerequisite: license is purchased and available to assign to user. You also must be an Internal Admin or have proper security within BC to complete these tasks.  Microsoft 365 admin center Assign BC license to user. Dynamics 365 Business Central Navigate to Users page. Select Process > Update users from Microsoft 365 Update users from Microsoft 365 > Next Update users from Microsoft 365 > Next Update users from Microsoft 365. Review the updates within this window and click finish. Lastly assign user group or permission sets and assign company access.  Version: US Business Central 22.1 (Platform 22.0.58213.0 + Application 22.1.55890.56216) Written by: Kristen Hosman, Microsoft MVP
Read more

Dynamics 365 Business Central - Is this a feature or a bug? Filtering and posting General Journal lines

By -
Image
This blog is inspired by something I just learned from James Bowles .  Scenario: I have a General Journal with multiple lines and only want to post certain transactions/lines.  In my example I am going to filter on the Posting Date field so only the 04/30 transaction is posted. Once the posting is completed you will see the remaining lines in the journal.  Review the General Ledger Entries and you see only entry posted was the 04/30. Written by: Kristen Hosman, Microsoft MVP
Read more

Invited External Accountant in Dynamics 365 Business Central now what?

By -
Image
This blog describes what comes next after you invite an External Accountant. If you need to invite an External Accountant than visit this blog:  Invite External Accountant in Dynamics 365 Business Central (kristenhosman.com) You've invited an External Accountant now what? What happens after you've successfully invited an External Accountant? You receive the below message in Dynamics 365 Business Central and your external accountant receives an email.  Steps your External Accountant should take Have your external accountant look for an email with a subject line: You have been invited to Microsoft Dynamics 365 Business Central. The external accountant should click on the link provided in the email. They will be redirected to a Microsoft sign in window. In my case the external accountant email isn't listed so I'm going to select use another account. Enter email. Next window suggests that a code was sent to email. Go pull code from email and enter into next window. Accept t
Read more