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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Bank Rec Error

(0) ShareShare
ReportReport
Posted on by 40

Hi,

I have a client that received this error in bank rec.  (They have version 21.1.48363.48789)

pastedimage1669063364524v1.png

Any help on how to resolve this is appreciated!  We tried to un match, but could not.  We also tried to delete the bank rec, but could not.

Thanks,

Pam

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Good day,

    Please ask your partner to assist as it is hard to verify from here without having direct access to the data.

    Thank

  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at
  • Verified answer
    Agazziz Profile Picture
    215 on at

    I had this same issue, and was able to resolve it using the suggestion above by Nitin Verma. If you have an open bank rec with items already matched, you'll need to add the Bank Statement No. and Bank Statement Line No.'s to the Check Ledger Entry table.  Create a Config Package of table 272 - Check Ledger Entry.  I only included the following fields - and be sure to turn Validate Field to OFF for Statement No. and Line No. or they won't update:

    pastedimage1669406430186v1.png

    After exporting the Config Package data to Excel, I opened up the Bank Reconciliation Page in BC and used Page Inspection to click on the imported bank lines to find the Statement Number and the Statement Line Numbers of the check ledger entries that are matched in the statement.  I then added these numbers to the config package data in Excel.  For example, clicking on the bank line of a particular check, I can see that the Line No is 10000, so I add that to the corresponding line for that check in the Check Ledger Entry data, and I also add the Statement No. BANKREC000001: 

    pastedimage1669406903854v2.png

    Once the Config Package was uploaded and applied, the issue was resolved.  There was a few where I typed the wrong Line No - you will get an error and BC will tell you what the line number should be.

  • Suggested answer
    Amit Profile Picture
    2,563 on at

    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
    Press Yes if Info is useful

  • Pamaltier Profile Picture
    40 on at

    Thank you for the detailed instructions!  It worked like a charm!

    Pam

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,382 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,625 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,376

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans