Report 1403 Bank Account Register

Base Application, Microsoft.Bank.Reports

src/Layers/W1/BaseApp/Bank/Reports/BankAccountRegister.Report.al238 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Bank.Reports;using Microsoft.Bank.BankAccount;using Microsoft.Bank.Ledger;using Microsoft.Finance.GeneralLedger.Ledger;/// <summary>/// Generates detailed register of bank account ledger entries organized by G/L register numbers./// Displays bank transactions with posting details, amounts, and optional LCY conversion./// </summary>/// <remarks>/// Data Sources: G/L Register, Bank Account Ledger Entry. /// Features: Register-based grouping, currency display options, entry-level detail reporting./// Usage: Transaction auditing, register verification, detailed bank account activity analysis./// </remarks>report 1403 "Bank Account Register"{    ApplicationArea = Basic, Suite;    Caption = 'Bank Account Register';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("G/L Register"; "G/L Register")        {            DataItemTableView = sorting("No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "No.";            column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(PrintAmountsInLCY; PrintAmountsInLCY)            {            }            column(G_L_Register__TABLECAPTION__________GLRegFilter; TableCaption + ': ' + GLRegFilter)            {            }            column(GLRegFilter; GLRegFilter)            {            }            column(G_L_Register__No__; "No.")            {            }            column(Bank_Account_Ledger_Entry___Debit_Amount__LCY__; "Bank Account Ledger Entry"."Debit Amount (LCY)")            {            }            column(Bank_Account_Ledger_Entry___Credit_Amount__LCY__; "Bank Account Ledger Entry"."Credit Amount (LCY)")            {            }            column(Bank_Account_Ledger_Entry___Amount__LCY__; "Bank Account Ledger Entry"."Amount (LCY)")            {            }            column(Bank_Account_RegisterCaption; Bank_Account_RegisterCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(All_amounts_are_in_LCYCaption; All_amounts_are_in_LCYCaptionLbl)            {            }            column(Bank_Account_Ledger_Entry__Posting_Date_Caption; Bank_Account_Ledger_Entry__Posting_Date_CaptionLbl)            {            }            column(Bank_Account_Ledger_Entry__Document_Type_Caption; Bank_Account_Ledger_Entry__Document_Type_CaptionLbl)            {            }            column(Bank_Account_Ledger_Entry__Document_No__Caption; "Bank Account Ledger Entry".FieldCaption("Document No."))            {            }            column(Bank_Account_Ledger_Entry_DescriptionCaption; "Bank Account Ledger Entry".FieldCaption(Description))            {            }            column(Bank_Account_Ledger_Entry__Bank_Account_No__Caption; "Bank Account Ledger Entry".FieldCaption("Bank Account No."))            {            }            column(BankAcc_NameCaption; BankAcc_NameCaptionLbl)            {            }            column(BankAccAmountCaption; BankAccAmountCaptionLbl)            {            }            column(Bank_Account_Ledger_Entry__Entry_No__Caption; "Bank Account Ledger Entry".FieldCaption("Entry No."))            {            }            column(Bank_Account_Ledger_Entry_OpenCaption; CaptionClassTranslate("Bank Account Ledger Entry".FieldCaption(Open)))            {            }            column(Bank_Account_Ledger_Entry__Remaining_Amount_Caption; "Bank Account Ledger Entry".FieldCaption("Remaining Amount"))            {            }            column(G_L_Register__No__Caption; G_L_Register__No__CaptionLbl)            {            }            column(TotalCaption; TotalCaptionLbl)            {            }            column(Bank_Account_Ledger_Entry___Debit_Amount__LCY__Caption; Bank_Account_Ledger_Entry___Debit_Amount__LCY__CaptionLbl)            {            }            column(Bank_Account_Ledger_Entry___Credit_Amount__LCY__Caption; Bank_Account_Ledger_Entry___Credit_Amount__LCY__CaptionLbl)            {            }            column(Bank_Account_Ledger_Entry___Amount__LCY__Caption; Bank_Account_Ledger_Entry___Amount__LCY__CaptionLbl)            {            }            dataitem("Bank Account Ledger Entry"; "Bank Account Ledger Entry")            {                DataItemTableView = sorting("Entry No.");                column(Bank_Account_Ledger_Entry__Posting_Date_; Format("Posting Date"))                {                }                column(Bank_Account_Ledger_Entry__Document_Type_; "Document Type")                {                }                column(Bank_Account_Ledger_Entry__Document_No__; "Document No.")                {                }                column(Bank_Account_Ledger_Entry_Description; Description)                {                }                column(Bank_Account_Ledger_Entry__Bank_Account_No__; "Bank Account No.")                {                }                column(BankAcc_Name; BankAcc.Name)                {                }                column(BankAccAmount; BankAccAmount)                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(Bank_Account_Ledger_Entry__Currency_Code_; "Currency Code")                {                }                column(Bank_Account_Ledger_Entry__Entry_No__; "Entry No.")                {                }                column(Bank_Account_Ledger_Entry_Open; Format(Open))                {                }                column(Bank_Account_Ledger_Entry__Remaining_Amount_; "Remaining Amount")                {                }                trigger OnAfterGetRecord()                begin                    if not BankAcc.Get("Bank Account No.") then                        BankAcc.Init();                    if PrintAmountsInLCY then begin                        BankAccAmount := "Amount (LCY)";                        "Currency Code" := '';                    end else                        BankAccAmount := Amount;                end;                trigger OnPreDataItem()                begin                    SetRange("Entry No.", "G/L Register"."From Entry No.", "G/L Register"."To Entry No.");                end;            }        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(PrintAmountsInLCY; PrintAmountsInLCY)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Show Amounts in LCY';                        ToolTip = 'Specifies if the reported amounts are shown in the local currency.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Bank/Reports/BankAccountRegister.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        GLRegFilter := "G/L Register".GetFilters();    end;    var        BankAcc: Record "Bank Account";        GLRegFilter: Text;        BankAccAmount: Decimal;        PrintAmountsInLCY: Boolean;        Bank_Account_RegisterCaptionLbl: Label 'Bank Account Register';        CurrReport_PAGENOCaptionLbl: Label 'Page';        All_amounts_are_in_LCYCaptionLbl: Label 'All amounts are in LCY.';        Bank_Account_Ledger_Entry__Posting_Date_CaptionLbl: Label 'Posting Date';        Bank_Account_Ledger_Entry__Document_Type_CaptionLbl: Label 'Document Type';        BankAcc_NameCaptionLbl: Label 'Name';        BankAccAmountCaptionLbl: Label 'Amount';        G_L_Register__No__CaptionLbl: Label 'Register No.';        TotalCaptionLbl: Label 'Total';        Bank_Account_Ledger_Entry___Debit_Amount__LCY__CaptionLbl: Label 'Debit (LCY)';        Bank_Account_Ledger_Entry___Credit_Amount__LCY__CaptionLbl: Label 'Credit (LCY)';        Bank_Account_Ledger_Entry___Amount__LCY__CaptionLbl: Label 'Total (LCY)';}