Page 416 G/L Account Balance Lines

Base Application, Microsoft.Finance.Analysis

src/Layers/W1/BaseApp/Finance/Analysis/GLAccountBalanceLines.Page.al270 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.Finance.Analysis;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using System.Utilities;/// <summary>/// Displays G/L account balance analysis across periods with debit/credit breakdown./// Provides period-based balance analysis with configurable amount types and closing entry handling./// </summary>page 416 "G/L Account Balance Lines"{    Caption = 'Lines';    DeleteAllowed = false;    InsertAllowed = false;    LinksAllowed = false;    PageType = ListPart;    SaveValues = true;    SourceTable = "G/L Acc. Balance Buffer";    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(Control1)            {                ShowCaption = false;                field("Period Start"; Rec."Period Start")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Period Start';                    Editable = false;                }                field("Period Name"; Rec."Period Name")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Period Name';                    Editable = false;                }                field(DebitAmount; Rec."Debit Amount")                {                    ApplicationArea = Basic, Suite;                    AutoFormatType = 1;                    BlankNumbers = BlankZero;                    Caption = 'Debit Amount';                    DrillDown = true;                    Editable = false;                    trigger OnDrillDown()                    begin                        BalanceDrillDown();                    end;                }                field(CreditAmount; Rec."Credit Amount")                {                    ApplicationArea = Basic, Suite;                    AutoFormatType = 1;                    BlankNumbers = BlankZero;                    Caption = 'Credit Amount';                    DrillDown = true;                    Editable = false;                    trigger OnDrillDown()                    begin                        BalanceDrillDown();                    end;                }                field(NetChange; Rec."Net Change")                {                    ApplicationArea = Basic, Suite;                    AutoFormatType = 1;                    BlankZero = true;                    Caption = 'Net Change';                    DrillDown = true;                    Editable = false;                    Visible = false;                    trigger OnDrillDown()                    begin                        BalanceDrillDown();                    end;                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    begin        if DateRec.Get(Rec."Period Type", Rec."Period Start") then;        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        AccountingPeriod: Record "Accounting Period";        DateRec: Record Date;        PeriodFormLinesMgt: Codeunit "Period Form Lines Mgt.";        PeriodType: Enum "Analysis Period Type";        AmountType: Enum "Analysis Amount Type";    protected var        GLAcc: Record "G/L Account";        ClosingEntryFilter: Option Include,Exclude;        DebitCreditTotals: Boolean;    /// <summary>    /// Configures the page with G/L account data and analysis parameters for balance display across periods.    /// </summary>    /// <param name="NewGLAcc">G/L account record containing the accounts to analyze</param>    /// <param name="NewPeriodType">Period type for analysis breakdown (Day, Week, Month, Quarter, Year)</param>    /// <param name="NewAmountType">Amount type for balance calculation (Net Change, Balance at Date)</param>    /// <param name="NewClosingEntryFilter">Whether to include or exclude closing entries in balance calculation</param>    /// <param name="NewDebitCreditTotals">Whether to show separate debit and credit totals</param>    procedure SetLines(var NewGLAcc: Record "G/L Account"; NewPeriodType: Enum "Analysis Period Type"; NewAmountType: Enum "Analysis Amount Type"; NewClosingEntryFilter: Option Include,Exclude; NewDebitCreditTotals: Boolean)    begin        GLAcc.Copy(NewGLAcc);        Rec.DeleteAll();        PeriodType := NewPeriodType;        AmountType := NewAmountType;        ClosingEntryFilter := NewClosingEntryFilter;        DebitCreditTotals := NewDebitCreditTotals;        OnAfterSetLinesOnBeforeUpdate();        CurrPage.Update(false);    end;    local procedure BalanceDrillDown()    var        GLEntry: Record "G/L Entry";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeBalanceDrillDown(GLAcc, PeriodType, AmountType, ClosingEntryFilter, DebitCreditTotals, IsHandled, DateRec);        if IsHandled then            exit;        SetDateFilter();        GLEntry.Reset();        GLEntry.SetCurrentKey("G/L Account No.", "Posting Date");        GLEntry.SetRange("G/L Account No.", GLAcc."No.");        if GLAcc.Totaling <> '' then            GLEntry.SetFilter("G/L Account No.", GLAcc.Totaling);        GLEntry.SetFilter("Posting Date", GLAcc.GetFilter("Date Filter"));        GLEntry.SetFilter("Global Dimension 1 Code", GLAcc.GetFilter("Global Dimension 1 Filter"));        GLEntry.SetFilter("Global Dimension 2 Code", GLAcc.GetFilter("Global Dimension 2 Filter"));        GLEntry.SetFilter("Business Unit Code", GLAcc.GetFilter("Business Unit Filter"));        PAGE.Run(0, GLEntry);    end;    local procedure SetDateFilter()    begin        if AmountType = AmountType::"Net Change" then            GLAcc.SetRange("Date Filter", Rec."Period Start", Rec."Period End")        else            GLAcc.SetRange("Date Filter", 0D, Rec."Period End");        if ClosingEntryFilter = ClosingEntryFilter::Exclude then begin            AccountingPeriod.SetCurrentKey("New Fiscal Year");            AccountingPeriod.SetRange("New Fiscal Year", true);            if GLAcc.GetRangeMin("Date Filter") = 0D then                AccountingPeriod.SetRange("Starting Date", 0D, GLAcc.GetRangeMax("Date Filter"))            else                AccountingPeriod.SetRange(                  "Starting Date",                  GLAcc.GetRangeMin("Date Filter") + 1,                  GLAcc.GetRangeMax("Date Filter"));            if AccountingPeriod.Find('-') then                repeat                    GLAcc.SetFilter(                      "Date Filter", GLAcc.GetFilter("Date Filter") + '&<>%1',                      ClosingDate(AccountingPeriod."Starting Date" - 1));                until AccountingPeriod.Next() = 0;        end else            GLAcc.SetRange(              "Date Filter",              GLAcc.GetRangeMin("Date Filter"),              ClosingDate(GLAcc.GetRangeMax("Date Filter")));    end;    local procedure CalcLine()    begin        SetDateFilter();        if DebitCreditTotals then            GLAcc.CalcFields("Net Change", "Debit Amount", "Credit Amount")        else begin            GLAcc.CalcFields("Net Change");            if GLAcc."Net Change" > 0 then begin                GLAcc."Debit Amount" := GLAcc."Net Change";                GLAcc."Credit Amount" := 0            end else begin                GLAcc."Debit Amount" := 0;                GLAcc."Credit Amount" := -GLAcc."Net Change"            end        end;        Rec."Debit Amount" := GLAcc."Debit Amount";        Rec."Credit Amount" := GLAcc."Credit Amount";        Rec."Net Change" := GLAcc."Net Change";        OnAfterCalcLine(GLAcc, Rec, ClosingEntryFilter, DebitCreditTotals);    end;    /// <summary>    /// Integration event for custom logic before balance drill-down operations.    /// </summary>    /// <param name="GLAccount">G/L account being analyzed</param>    /// <param name="GLPeriodLength">Period type for analysis breakdown</param>    /// <param name="AmountType">Amount type for balance calculation</param>    /// <param name="ClosingEntryFilter">Closing entry filter setting</param>    /// <param name="DebitCreditTotals">Whether debit/credit totals are shown separately</param>    /// <param name="IsHandled">Set to true to skip standard drill-down logic</param>    /// <param name="DateRec">Date record for period context</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeBalanceDrillDown(var GLAccount: Record "G/L Account"; GLPeriodLength: Enum "Analysis Period Type"; AmountType: Enum "Analysis Amount Type"; ClosingEntryFilter: Option Include,Exclude; DebitCreditTotals: Boolean; var IsHandled: Boolean; DateRec: Record Date)    begin    end;    /// <summary>    /// Integration event for custom calculation logic after computing line amounts.    /// </summary>    /// <param name="GLAccount">G/L account with calculated amounts</param>    /// <param name="GLAccBalanceBuffer">Balance buffer record with computed values</param>    /// <param name="ClosingEntryFilter">Closing entry filter setting</param>    /// <param name="DebitCreditTotals">Whether debit/credit totals are shown separately</param>    [IntegrationEvent(false, false)]    local procedure OnAfterCalcLine(var GLAccount: Record "G/L Account"; var GLAccBalanceBuffer: Record "G/L Acc. Balance Buffer"; ClosingEntryFilter: Option Include,Exclude; DebitCreditTotals: Boolean)    begin    end;    /// <summary>    /// Integration event for custom logic after setting line parameters but before updating the page.    /// </summary>    [IntegrationEvent(false, false)]    local procedure OnAfterSetLinesOnBeforeUpdate()    begin    end;}