Page 378 Bank Account Balance Lines
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;}