Report 1406 Bank Account - Check Details

Base Application, Microsoft.Bank.Reports

src/Layers/W1/BaseApp/Bank/Reports/BankAccountCheckDetails.Report.al297 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.Check;using System.Utilities;/// <summary>/// Generates detailed check information report for bank accounts with check ledger entry details./// Displays check transaction history, amounts, status changes, and voided check information./// </summary>/// <remarks>/// Data Sources: Bank Account, Check Ledger Entry. /// Features: Check status tracking, amount calculations, void detection, entry status reporting./// Usage: Check audit trails, bank reconciliation support, check history analysis, compliance reporting./// </remarks>report 1406 "Bank Account - Check Details"{    ApplicationArea = Basic, Suite;    Caption = 'Bank Account - Check Details';    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(FORMAT_TODAY_0_4_; Format(Today, 0, 4))            {            }            column(STRSUBSTNO_Text000_BankAccDateFilter_; StrSubstNo(PeriodLbl, BankAccDateFilter))            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(STRSUBSTNO___1___2___Bank_Account__TABLECAPTION_BankAccFilter_; StrSubstNo('%1: %2', TableCaption(), BankAccFilter))            {            }            column(BankFilter; BankAccFilter)            {            }            column(Bank_Account__No__; "No.")            {            }            column(Bank_Account_Name; Name)            {            }            column(Bank_Account__Phone_No__; "Phone No.")            {            }            column(Bank_Account__Currency_Code_; "Currency Code")            {            }            column(ShowCurrencyCode; "Currency Code" <> '')            {            }            column(Bank_Account___Check_DetailsCaption; Bank_Account___Check_DetailsCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(This_report_also_includes_bank_accounts_that_only_have_balances_Caption; This_report_also_includes_bank_accounts_that_only_have_balances_CaptionLbl)            {            }            column(Check_Ledger_Entry__Entry_No__Caption; "Check Ledger Entry".FieldCaption("Entry No."))            {            }            column(Check_Ledger_Entry__Bal__Account_No__Caption; "Check Ledger Entry".FieldCaption("Bal. Account No."))            {            }            column(Check_Ledger_Entry__Bal__Account_Type_Caption; "Check Ledger Entry".FieldCaption("Bal. Account Type"))            {            }            column(Check_Ledger_Entry__Original_Entry_Status_Caption; "Check Ledger Entry".FieldCaption("Original Entry Status"))            {            }            column(Check_Ledger_Entry__Entry_Status_Caption; "Check Ledger Entry".FieldCaption("Entry Status"))            {            }            column(Check_Ledger_Entry_Amount_Control47Caption; "Check Ledger Entry".FieldCaption(Amount))            {            }            column(Check_Ledger_Entry_DescriptionCaption; "Check Ledger Entry".FieldCaption(Description))            {            }            column(Check_Ledger_Entry__Check_No__Caption; "Check Ledger Entry".FieldCaption("Check No."))            {            }            column(Check_Ledger_Entry__Check_Date_Caption; Check_Ledger_Entry__Check_Date_CaptionLbl)            {            }            column(AmountVoided_Control69Caption; AmountVoided_Control69CaptionLbl)            {            }            column(AmountPrinted_Control67Caption; AmountPrinted_Control67CaptionLbl)            {            }            column(Bank_Account__Phone_No__Caption; FieldCaption("Phone No."))            {            }            column(Bank_Account__Currency_Code_Caption; FieldCaption("Currency Code"))            {            }            dataitem("Check Ledger Entry"; "Check Ledger Entry")            {                DataItemLink = "Bank Account No." = field("No."), "Check Date" = field("Date Filter");                DataItemTableView = sorting("Bank Account No.", "Check Date");                column(AmountPrinted; AmountPrinted)                {                    AutoFormatExpression = GetCurrencyCodeFromBank();                    AutoFormatType = 1;                }                column(Check_Ledger_Entry_Amount; Amount)                {                }                column(AmountVoided; AmountVoided)                {                    AutoFormatExpression = GetCurrencyCodeFromBank();                    AutoFormatType = 1;                }                column(RecordCounter; RecordCounter)                {                }                column(PrintOnlyOnePerPage; PrintOnlyOnePerPage)                {                }                column(Check_Ledger_Entry__Check_Date_; Format("Check Date"))                {                }                column(Check_Ledger_Entry__Check_No__; "Check No.")                {                }                column(Check_Ledger_Entry_Description; Description)                {                }                column(Check_Ledger_Entry_Amount_Control47; Amount)                {                }                column(Check_Ledger_Entry__Entry_Status_; "Entry Status")                {                }                column(Check_Ledger_Entry__Original_Entry_Status_; "Original Entry Status")                {                }                column(Check_Ledger_Entry__Bal__Account_Type_; "Bal. Account Type")                {                }                column(Check_Ledger_Entry__Bal__Account_No__; "Bal. Account No.")                {                }                column(Check_Ledger_Entry__Entry_No__; "Entry No.")                {                }                column(AmountPrinted_Control67; AmountPrinted)                {                    AutoFormatExpression = GetCurrencyCodeFromBank();                    AutoFormatType = 1;                }                column(AmountVoided_Control69; AmountVoided)                {                    AutoFormatExpression = GetCurrencyCodeFromBank();                    AutoFormatType = 1;                }                trigger OnAfterGetRecord()                begin                    CheckLedgEntryExists := true;                    ClearAmounts();                    if "Entry Status" = "Entry Status"::Printed then                        AmountPrinted := Amount;                    if "Entry Status" = "Entry Status"::Voided then                        AmountVoided := Amount;                end;                trigger OnPreDataItem()                begin                    RecordCounter := RecordCounter + 1;                    CheckLedgEntryExists := false;                    ClearAmounts();                end;            }            dataitem("Integer"; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                trigger OnAfterGetRecord()                begin                    if not CheckLedgEntryExists then                        CurrReport.Skip();                end;            }            trigger OnAfterGetRecord()            begin                CurrReport.PrintOnlyIfDetail := true;            end;            trigger OnPreDataItem()            begin                RecordCounter := 0;                ClearAmounts();            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(PrintOnlyOnePerPage; PrintOnlyOnePerPage)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'New Page per Bank Account';                        ToolTip = 'Specifies if you want to print each bank account on a separate page.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Bank/Reports/BankAccountCheckDetails.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        BankAccFilter := "Bank Account".GetFilters();        BankAccDateFilter := "Bank Account".GetFilter("Date Filter");    end;    var#pragma warning disable AA0470        PeriodLbl: Label 'Period: %1';#pragma warning restore AA0470        PrintOnlyOnePerPage: Boolean;        BankAccFilter: Text;        BankAccDateFilter: Text;        AmountVoided: Decimal;        AmountPrinted: Decimal;        CheckLedgEntryExists: Boolean;        RecordCounter: Integer;        Bank_Account___Check_DetailsCaptionLbl: Label 'Bank Account - Check Details';        CurrReport_PAGENOCaptionLbl: Label 'Page';        This_report_also_includes_bank_accounts_that_only_have_balances_CaptionLbl: Label 'This report also includes bank accounts that only have balances.';        Check_Ledger_Entry__Check_Date_CaptionLbl: Label 'Check Date';        AmountVoided_Control69CaptionLbl: Label 'Voided Amount';        AmountPrinted_Control67CaptionLbl: Label 'Printed Amount';    /// <summary>    /// Initializes report printing options for page layout and output formatting.    /// Configures whether to print each bank account on a separate page.    /// </summary>    /// <param name="NewPrintOnlyOnePerPage">Controls single bank account per page printing behavior</param>    procedure InitializeRequest(NewPrintOnlyOnePerPage: Boolean)    begin        PrintOnlyOnePerPage := NewPrintOnlyOnePerPage;    end;    local procedure ClearAmounts()    begin        Clear(AmountPrinted);        Clear(AmountVoided);    end;}