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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Check Layout per Bank Account

(0) ShareShare
ReportReport
Posted on by 5

Hello,

Does anyone know how to configure the report layout for a check to dynamically populate the bank information on a common check form?  I'm also willing to create custom layouts per bank...just need to know how to link them to the appropriate bank account.

Thanks!

I have the same question (0)
  • Datex Profile Picture
    5 on at

    UPDATE - I'm able to get the Transit No and Account No, but I cannot find the field linked to the Bank Name (designing in RDLC).  Thanks.

  • Suggested answer
    JAngle Profile Picture
    133 on at

    Right now report extensibility isn’t ready. It is coming though. You will need to acquire a copy of the existing report base code and then add fields from the bank account table to the report. That should give you the dynamic style you need with one layout.

    If a layout per is needed then check out a video by Erik Hougaard https://youtu.be/hPMWTToSO1A

  • Datex Profile Picture
    5 on at

    Thanks for the reply, Josh.  Are there any tutorials you know of that outline how to add a field from the bank account table to the report?  I have the RDLC and tried adding the 'name' field in the report code behind, but that was rejected once I ran the report in BC.    

  • Suggested answer
    Marco Mels Profile Picture
    on at

    Hello,

    I am sure there is out there a bit more from partner community, but this may help already:

    docs.microsoft.com/.../devenv-howto-rdl-report-layout

    Thanks.

  • Hikaru Profile Picture
    8 on at
    Hi I have the same issue that my user needs to set check format per bank account. Not like other report format, check requires different Report ID depends on the combination of stub and check part. (check/stub/stub, stub/check/stub or stub/stub/check)
    I wonder if we can use Check Report ID field on Bank Account Card. It looks that system would call format per bank account when issue check on Payment Journal. But I have not made it. Please advise if anyone can help.
     
  • Suggested answer
    Hikaru Profile Picture
    8 on at
    My conclusion on this issue is no standard configuration to select check format per bank. I extended another Print Check button on Payment Journal using Check Print ID on Bank Account Card by AL. This is comparatively common requirement at mid-small size companies. I wish this would be handled in standard.
    pageextension 60101 ExtPaymentJournal extends "Payment Journal"
    {
        actions
        {
            addafter(PrintCheck)
            {
                action(PrintCheckB)
                {
                    AccessByPermission = TableData "Check Ledger Entry" = R;
                    ApplicationArea = Basic, Suite;
                    Caption = 'Print Check';
                    Ellipsis = true;
                    Image = PrintCheck;
                    ToolTip = 'Prepare to print the check. Only one Bank Account is available per Batch';
     
                    trigger OnAction()
                    var
                        GenJournalLine: Record "Gen. Journal Line";
                        DocumentPrint: Codeunit "Document-Print";
                        ReportID: integer;
                        BankAccount: record "Bank Account";
                    begin
                        GenJournalLine.Reset();
                        GenJournalLine.Copy(Rec);
                        GenJournalLine.SetRange("Journal Template Name", Rec."Journal Template Name");
                        GenJournalLine.SetRange("Journal Batch Name", Rec."Journal Batch Name");
                        if (GenJournalLine.FindFirst()) then begin
                            if (GenJournalLine."Bal. Account Type" <> GenJournalLine."Bal. Account Type"::"Bank Account") then begin
                                Error('Bal. Account Type has to be Bank Account for this option');
                            end;
                            BankAccount.Reset();
                            BankAccount.SetRange("No.", GenJournalLine."Bal. Account No.");
     
                            if (BankAccount.FindFirst()) then begin
                                ReportID := BankAccount."Check Report ID"
                            end;
                            if (ReportID = 0) Then begin
                                Error('Bank Account %1 has no value on Print Check ID', GenJournalLine."Bal. Account No.");
                            end;
                        end;
                        Report.Run(ReportID, true, false, GenJournalLine);
                        CODEUNIT.Run(CODEUNIT::"Adjust Gen. Journal Balance", Rec);
                    end;
                }
            }
            addafter(PrintCheck_Promoted)
            {
                actionref(PrintCheckB_Promoted; PrintCheckB)
                {
                }
            }
     
        }
    }

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,092

#2
YUN ZHU Profile Picture

YUN ZHU 663 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 515

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans