Report 1404 Bank Acc. - Detail Trial Bal.

Base Application, Microsoft.Bank.Reports

src/Layers/W1/BaseApp/Bank/Reports/BankAccDetailTrialBal.Report.al314 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 System.Utilities;/// <summary>/// Generates detailed trial balance report for bank accounts with transaction-level detail./// Displays opening balances, transaction details, and closing balances for bank account analysis./// </summary>/// <remarks>/// Data Sources: Bank Account, Bank Account Ledger Entry. /// Features: Period filtering, balance calculations, transaction detail, reversed entry handling./// Usage: Financial reporting, account analysis, balance verification, audit trail documentation./// </remarks>report 1404 "Bank Acc. - Detail Trial Bal."{    ApplicationArea = Basic, Suite;    Caption = 'Bank Accounts - Detail Trial Balance';    UsageCategory = ReportsAndAnalysis;    WordMergeDataItem = "Bank Account";    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Bank Account"; "Bank Account")        {            DataItemTableView = sorting("No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "No.", "Search Name", "Bank Acc. Posting Group", "Date Filter";            column(FilterPeriod_BankAccLedg; StrSubstNo(PeriodLbl, DateFilter_BankAccount))            {            }            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(ExcludeBalanceOnly; ExcludeBalanceOnlyReq)            {            }            column(BankAccFilter; BankAccFilter)            {            }            column(StartBalanceLCY; StartBalanceLCY)            {            }            column(StartBalance; StartBalance)            {            }            column(PrintOnlyOnePerPage; PrintOnlyOnePerPageReq)            {            }            column(ReportFilter; StrSubstNo('%1: %2', TableCaption(), BankAccFilter))            {            }            column(No_BankAccount; "No.")            {            }            column(Name_BankAccount; Name)            {            }            column(PhNo_BankAccount; "Phone No.")            {                IncludeCaption = true;            }            column(CurrencyCode_BankAccount; "Currency Code")            {                IncludeCaption = true;            }            column(StartBalance2; StartBalance)            {                AutoFormatExpression = "Bank Account Ledger Entry"."Currency Code";                AutoFormatType = 1;            }            column(BankAccDetailTrialBalCap; BankAccDetailTrialBalCapLbl)            {            }            column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)            {            }            column(RepInclBankAcchavingBal; RepInclBankAcchavingBalLbl)            {            }            column(BankAccLedgPostingDateCaption; BankAccLedgPostingDateCaptionLbl)            {            }            column(BankAccBalanceCaption; BankAccBalanceCaptionLbl)            {            }            column(OpenFormatCaption; OpenFormatCaptionLbl)            {            }            column(BankAccBalanceLCYCaption; BankAccBalanceLCYCaptionLbl)            {            }            dataitem("Bank Account Ledger Entry"; "Bank Account Ledger Entry")            {                DataItemLink = "Bank Account No." = field("No."), "Posting Date" = field("Date Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter");                DataItemTableView = sorting("Bank Account No.", "Posting Date");                column(PostingDate_BankAccLedg; Format("Posting Date"))                {                }                column(DocType_BankAccLedg; "Document Type")                {                    IncludeCaption = true;                }                column(DocNo_BankAccLedg; "Document No.")                {                    IncludeCaption = true;                }                column(ExtDocNo_BankAccLedg; "External Document No.")                {                    IncludeCaption = true;                }                column(Desc_BankAccLedg; Description)                {                    IncludeCaption = true;                }                column(BankAccBalance; BankAccBalance)                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(RemaningAmt_BankAccLedg; "Remaining Amount")                {                    IncludeCaption = true;                }                column(EntryNo_BankAccLedg; "Entry No.")                {                    IncludeCaption = true;                }                column(OpenFormat; Format(Open))                {                }                column(Amount_BankAccLedg; Amount)                {                    IncludeCaption = true;                }                column(EntryAmtLcy_BankAccLedg; "Amount (LCY)")                {                    IncludeCaption = true;                }                column(BankAccBalanceLCY; BankAccBalanceLCY)                {                    AutoFormatType = 1;                }                column(ContinuedCaption; ContinuedCaptionLbl)                {                }                trigger OnAfterGetRecord()                begin                    if not PrintReversedEntriesReq and Reversed then                        CurrReport.Skip();                    BankAccLedgEntryExists := true;                    BankAccBalance := BankAccBalance + Amount;                    BankAccBalanceLCY := BankAccBalanceLCY + "Amount (LCY)"                end;                trigger OnPreDataItem()                begin                    BankAccLedgEntryExists := false;                end;            }            dataitem("Integer"; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                trigger OnAfterGetRecord()                begin                    if not BankAccLedgEntryExists and ((StartBalance = 0) or ExcludeBalanceOnlyReq) then begin                        StartBalanceLCY := 0;                        CurrReport.Skip();                    end;                end;            }            trigger OnAfterGetRecord()            begin                StartBalance := 0;                if DateFilter_BankAccount <> '' then                    if GetRangeMin("Date Filter") <> 0D then begin                        SetRange("Date Filter", 0D, GetRangeMin("Date Filter") - 1);                        CalcFields("Net Change", "Net Change (LCY)");                        StartBalance := "Net Change";                        StartBalanceLCY := "Net Change (LCY)";                        SetFilter("Date Filter", DateFilter_BankAccount);                    end;                CurrReport.PrintOnlyIfDetail := ExcludeBalanceOnlyReq or (StartBalance = 0);                BankAccBalance := StartBalance;                BankAccBalanceLCY := StartBalanceLCY;                if PrintOnlyOnePerPageReq then                    PageGroupNo := PageGroupNo + 1;            end;            trigger OnPreDataItem()            begin                Clear(StartBalanceLCY);            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Bank Acc. - Detail Trial Bal.';        AboutText = 'View bank account balances at the end of a period, including the opening balance, each transaction within the period, and the closing balance grouped by bank. View a running balance and reconciled entries.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(PrintOnlyOnePerPage; PrintOnlyOnePerPageReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'New Page per Bank Account';                        ToolTip = 'Specifies if you want to print each bank account on a separate page.';                    }                    field(ExcludeBalanceOnly; ExcludeBalanceOnlyReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Exclude Bank Accs. That Have a Balance Only';                        MultiLine = true;                        ToolTip = 'Specifies if you do not want the report to include entries for bank accounts that have a balance but do not have a net change during the selected time period.';                    }                    field(PrintReversedEntries; PrintReversedEntriesReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Include Reversed Entries';                        ToolTip = 'Specifies if you want to include reversed entries in the report.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Bank/Reports/BankAccDetailTrialBal.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnInitReport()    begin        PageGroupNo := 1;    end;    trigger OnPreReport()    begin        BankAccFilter := "Bank Account".GetFilters();        DateFilter_BankAccount := "Bank Account".GetFilter("Date Filter");    end;    var#pragma warning disable AA0470        PeriodLbl: Label 'Period: %1';#pragma warning restore AA0470        BankAccFilter: Text;        DateFilter_BankAccount: Text;        BankAccBalance: Decimal;        BankAccBalanceLCY: Decimal;        PageGroupNo: Integer;        BankAccDetailTrialBalCapLbl: Label 'Bank Acc. - Detail Trial Bal.';        CurrReportPageNoCaptionLbl: Label 'Page';        RepInclBankAcchavingBalLbl: Label 'This report also includes bank accounts that only have balances.';        BankAccLedgPostingDateCaptionLbl: Label 'Posting Date';        BankAccBalanceCaptionLbl: Label 'Balance';        OpenFormatCaptionLbl: Label 'Open';        BankAccBalanceLCYCaptionLbl: Label 'Balance (LCY)';        ContinuedCaptionLbl: Label 'Continued';    protected var        BankAccLedgEntryExists: Boolean;        ExcludeBalanceOnlyReq: Boolean;        PrintOnlyOnePerPageReq: Boolean;        PrintReversedEntriesReq: Boolean;        StartBalance: Decimal;        StartBalanceLCY: Decimal;    /// <summary>    /// Initializes report options for output formatting and filtering behavior.    /// Configures page layout, balance display, and reversed entry handling preferences.    /// </summary>    /// <param name="NewPrintOnlyOnePerPage">Controls single bank account per page printing</param>    /// <param name="NewExcludeBalanceOnly">Excludes accounts that only have balance without transactions</param>    /// <param name="NewPrintReversedEntries">Includes reversed entries in the report output</param>    procedure InitializeRequest(NewPrintOnlyOnePerPage: Boolean; NewExcludeBalanceOnly: Boolean; NewPrintReversedEntries: Boolean)    begin        PrintOnlyOnePerPageReq := NewPrintOnlyOnePerPage;        ExcludeBalanceOnlyReq := NewExcludeBalanceOnly;        PrintReversedEntriesReq := NewPrintReversedEntries;    end;}