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 / Business Central forum / Bank account statement...
Business Central forum

Bank account statement report - Error

(0) ShareShare
ReportReport
Posted on by Steve Simon 348

When Reconciling a bank account in D365 BC, I get the following error:

"The Bank Account Statement report does not have a Dataitem that uses the table (table 10123 Posted Bank Rec. Header) specified in the function SetTableView."

Is this a bug, or have I missed something in setup?

Sincerely,

Steve Simon
PDG Consultants

Categories:
Financial Management
I have the same question (0)
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    Go to Report Selection - Bank Account and check the statement.

    It looks like the print button is pointing to the wrong report. The current report does not except bank reconciliation parameter.

  • Steve Simon Profile Picture
    Steve Simon 348 on at

    Okay, Teddy. You seem to know what is going on. When I "Post and Print" or run a Test Print for the Reconciliation, the Print button takes me to the Bank Statement Report (1407) instead of 10407, 10408, or 10409; which are the Bank Rec. Test Report, Bank Reconciliation, and Bank Account Reconciliation respectively. How do I report this as a bug? Or is there a way for me to change it?

    Regards,

    Steve Simon

    PDG Consultants

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    Take a look at the Report Selection - Bank Account, you can change both the statement and test report there. It's not a bug. You can change the setup.

  • Steve Simon Profile Picture
    Steve Simon 348 on at

    Report Selection - Bank Account for Statements is set to 1407, "Bank Account Statement". For Reconciliation - Test it is 1408, "Bank Acc. Recon. - Test".

    Only the Posting->Post & Print and the Posting->Test Report give errors (Table 10123 and 10120 respectively - Posted Bank Rec Header and Bank Rec Header respectively).  The same reports print fine from the Report menu; just not from the Posting Action Menu. Are you sure it isn't an error in the Posting Action Menu?

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    The standard BC will use the Report Selection - Bank Account Statement for printing when  you do post & print.

    If you don't get that, it's either an extension (or country specific localization) that causing the issue.

  • Steve Simon Profile Picture
    Steve Simon 348 on at

    Thank you, Teddy. Sorry to take so long to acknowledge a right answer.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans