Report 1404 Bank Acc. - Detail Trial Bal.
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;}