Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Business Central forum

Bank account statement report - Error

(0) ShareShare
ReportReport
Posted on by 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

  • Steve Simon Profile Picture
    348 on at
    RE: Bank account statement report - Error

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

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    13,113 Moderator on at
    RE: Bank account statement report - Error

    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
    348 on at
    RE: Bank account statement report - Error

    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?

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    13,113 Moderator on at
    RE: Bank account statement report - Error

    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
    348 on at
    RE: Bank account statement report - Error

    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

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    13,113 Moderator on at
    RE: Bank account statement report - Error

    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.

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,758 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans