Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Bank Rec Error

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

  • Pamaltier Profile Picture
    Pamaltier 40 on at
    RE: Bank Rec Error

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

    Pam

  • Suggested answer
    Amit_Sharma Profile Picture
    Amit_Sharma 2,545 on at
    RE: Bank Rec Error

    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

  • Verified answer
    Agazziz Profile Picture
    Agazziz 195 on at
    RE: Bank Rec Error

    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
    Nitin Verma Profile Picture
    Nitin Verma 21,023 Moderator on at
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Bank Rec Error

    Good day,

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

    Thank

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans