Page 378 Bank Account Balance Lines

Base Application, Microsoft.Bank.BankAccount

src/Layers/W1/BaseApp/Bank/BankAccount/BankAccountBalanceLines.Page.al187 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.BankAccount;using Microsoft.Bank.Ledger;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using System.Utilities;/// <summary>/// List part for displaying bank account balance data organized by time periods./// Shows detailed balance information for period-based analysis and reporting./// </summary>/// <remarks>/// Source Table: Bank Account Balance Buffer (929). Used as part of Bank Account Balance page./// Displays calculated balance data with drill-down capabilities to ledger entries./// </remarks>page 378 "Bank Account Balance Lines"{    Caption = 'Lines';    LinksAllowed = false;    PageType = ListPart;    SourceTable = "Bank Account Balance Buffer";    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(Control1)            {                Editable = false;                ShowCaption = false;                field("Period Start"; Rec."Period Start")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Period Start';                }                field("Period Name"; Rec."Period Name")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Period Name';                }                field(NetChange; Rec."Net Change")                {                    ApplicationArea = Basic, Suite;                    AutoFormatExpression = BankAcc."Currency Code";                    AutoFormatType = 1;                    Caption = 'Net Change';                    DrillDown = true;                    trigger OnDrillDown()                    begin                        ShowBankAccEntries();                    end;                }#pragma warning disable AA0100                field("BankAcc.""Net Change (LCY)"""; Rec."Net Change (LCY)")#pragma warning restore AA0100                {                    ApplicationArea = Basic, Suite;                    AutoFormatType = 1;                    Caption = 'Net Change (LCY)';                    DrillDown = true;                    ToolTip = 'Specifies the net value of entries in LCY for the period shown in the left column.';                    trigger OnDrillDown()                    begin                        ShowBankAccEntries();                    end;                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    begin        CalcLine();    end;    trigger OnFindRecord(Which: Text) FoundDate: Boolean    var        VariantRec: Variant;    begin        VariantRec := Rec;        FoundDate := PeriodFormLinesMgt.FindDate(VariantRec, DateRec, Which, PeriodType.AsInteger());        Rec := VariantRec;    end;    trigger OnNextRecord(Steps: Integer) ResultSteps: Integer    var        VariantRec: Variant;    begin        VariantRec := Rec;        ResultSteps := PeriodFormLinesMgt.NextDate(VariantRec, DateRec, Steps, PeriodType.AsInteger());        Rec := VariantRec;    end;    trigger OnOpenPage()    begin        Rec.Reset();    end;    var        BankAccLedgEntry: Record "Bank Account Ledger Entry";        DateRec: Record Date;        PeriodFormLinesMgt: Codeunit "Period Form Lines Mgt.";        PeriodType: Enum "Analysis Period Type";        AmountType: Enum "Analysis Amount Type";    protected var        BankAcc: Record "Bank Account";    /// <summary>    /// Initializes the balance lines with bank account data and analysis parameters.    /// </summary>    /// <param name="NewBankAcc">Bank account record to analyze</param>    /// <param name="NewPeriodType">Period type for analysis grouping</param>    /// <param name="NewAmountType">Amount type for analysis calculations</param>    procedure SetLines(var NewBankAcc: Record "Bank Account"; NewPeriodType: Enum "Analysis Period Type"; NewAmountType: Enum "Analysis Amount Type")    begin        BankAcc.Copy(NewBankAcc);        Rec.DeleteAll();        Clear(Rec);        Rec.Init();        PeriodType := NewPeriodType;        AmountType := NewAmountType;        CurrPage.Update(false);    end;    local procedure ShowBankAccEntries()    begin        SetDateFilter();        BankAccLedgEntry.Reset();        BankAccLedgEntry.SetCurrentKey("Bank Account No.", "Posting Date");        BankAccLedgEntry.SetRange("Bank Account No.", BankAcc."No.");        BankAccLedgEntry.SetFilter("Posting Date", BankAcc.GetFilter("Date Filter"));        BankAccLedgEntry.SetFilter("Global Dimension 1 Code", BankAcc.GetFilter("Global Dimension 1 Filter"));        BankAccLedgEntry.SetFilter("Global Dimension 2 Code", BankAcc.GetFilter("Global Dimension 2 Filter"));        PAGE.Run(0, BankAccLedgEntry);    end;    /// <summary>    /// Sets date filter on bank account based on current period and amount type.    /// </summary>    procedure SetDateFilter()    begin        if AmountType = AmountType::"Net Change" then            BankAcc.SetRange("Date Filter", Rec."Period Start", Rec."Period End")        else            BankAcc.SetRange("Date Filter", 0D, Rec."Period End");    end;    local procedure CalcLine()    begin        SetDateFilter();        BankAcc.CalcFields("Net Change", "Net Change (LCY)");        Rec."Net Change" := BankAcc."Net Change";        Rec."Net Change (LCY)" := BankAcc."Net Change (LCY)";        OnAfterCalcLine(BankAcc, Rec);    end;    /// <summary>    /// Integration event raised after calculating balance line data for bank account balance display.    /// Enables custom field updates or additional calculations for balance buffer records.    /// </summary>    /// <param name="BankAccount">Source bank account record</param>    /// <param name="BankAccountBalanceBuffer">Balance buffer record being populated</param>    /// <remarks>    /// Raised from CalcLine procedure after populating standard balance fields.    /// </remarks>    [IntegrationEvent(false, false)]    local procedure OnAfterCalcLine(var BankAccount: Record "Bank Account"; var BankAccountBalanceBuffer: Record "Bank Account Balance Buffer")    begin    end;}