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 Account Reconcili...
Small and medium business | Business Central, N...
Answered

Bank Account Reconciliation Posting Error

(0) ShareShare
ReportReport
Posted on by Angelus Spy 114

Hi,

I am facing this error while i post the bank account reconciliation.

"The record in table Bank Account Statement already exists. Identification fields and values: Bank Account No.='ABC123',Statement No.='5'."

so what should I do while i have posted nothing with this statement number and also have 2 question where i can see my previous posted records either it exist or not and is it possible to transfer the single line from bank reconciliation to general journal lines?

Thanks & Regards

Angelus Spy

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    Go to the bank account list and you can choose the "Related" dropdown to reveal the below:

    pastedimage1631111215714v1.png

    If you find that a statement exists with the number you can access the bank account record and change the "Last Statement No." field. Could be another user did it by mistake as it has no validation to check old statements.

    Only entries that are not applied are moved to the general journal. It does not pick up any other filters. 

  • Angelus Spy Profile Picture
    Angelus Spy 114 on at

    Hi Josh,

    Thanks For your response I have got my first answer and the second one still not solved because I just want to transfer the single line to the General journal, yeah your point seems right but only single line could be transfer to the general journal or not?

    Thanks & Regards

    Angelus Spy

  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    If it’s a single line is it worth it? You could modify the report that does the move of data if it’s a regular occurrence and you need that level of control.

    can the excel and copy/paste capabilities if BC not help here? Maybe have an edit in excel of the general journal open. Then copy the bank rec line to excel and map it over

  • Angelus Spy Profile Picture
    Angelus Spy 114 on at

    Hi Josh,

    Thank you so much Josh for your help,

    In addition 1 last thing I want to ask you, Is it possible in bank reconciliation to stop the statement no series according to the month like I want to import my Bank statement on the month of august, example is given below.

    Bank Account no       Statement no        Statement Date

    ABC111                          1                              9/12/2021

    ABC123                          2                              9/10/2021

    ABC123                          3                              9/11/2021

    ABC123                          4                              9/12/2021

    1st and 4th line represent my current data in which you can see it is not changing the first bank statement no. but only update the date of this month, so I want to apply this on my bank 2. please guide me.

    Thanks & Regards

    Angelus Spy

  • Verified answer
    JAngle Profile Picture
    JAngle 133 on at

    Not sure that I'm following.

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,010

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans