Page 350 G/L Acc. Balance/Budget Lines

Base Application, Microsoft.Finance.Analysis

src/Layers/W1/BaseApp/Finance/Analysis/GLAccBalanceBudgetLines.Page.al361 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.Budget;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using System.Utilities;/// <summary>/// Displays G/L account balance and budget analysis across periods with comparison capabilities./// Provides period-based analysis of actual vs. budget amounts with percentage variance calculations./// </summary>page 350 "G/L Acc. Balance/Budget Lines"{    Caption = 'Lines';    DeleteAllowed = false;    InsertAllowed = false;    LinksAllowed = false;    PageType = ListPart;    SaveValues = true;    SourceTable = "G/L Acc. Balance/Budget Buffer";    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(Control1)            {                ShowCaption = false;                field("Period Start"; Rec."Period Start")                {                    ApplicationArea = Suite;                    Caption = 'Period Start';                    Editable = false;                }                field("Period Name"; Rec."Period Name")                {                    ApplicationArea = Suite;                    Caption = 'Period Name';                    Editable = false;                }                field(DebitAmount; Rec."Debit Amount")                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    BlankNumbers = BlankNegAndZero;                    Caption = 'Actual Debit Amount';                    DrillDown = true;                    Editable = false;                    trigger OnDrillDown()                    begin                        BalanceDrillDown();                    end;                }                field(CreditAmount; Rec."Credit Amount")                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    BlankNumbers = BlankNegAndZero;                    Caption = 'Actual Credit Amount';                    DrillDown = true;                    Editable = false;                    trigger OnDrillDown()                    begin                        BalanceDrillDown();                    end;                }                field(NetChange; Rec."Net Change")                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    BlankZero = true;                    Caption = 'Net Change';                    DrillDown = true;                    Editable = false;                    Visible = false;                    trigger OnDrillDown()                    begin                        BalanceDrillDown();                    end;                }                field(BudgetedDebitAmount; Rec."Budgeted Debit Amount")                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    BlankNumbers = BlankNegAndZero;                    Caption = 'Budgeted Debit Amount';                    DrillDown = true;                    trigger OnDrillDown()                    begin                        BudgetDrillDown();                    end;                    trigger OnValidate()                    begin                        SetDateFilter();                        GLAcc.Validate("Budgeted Debit Amount");                        CalcFormFields();                    end;                }                field(BudgetedCreditAmount; Rec."Budgeted Credit Amount")                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    BlankNumbers = BlankNegAndZero;                    Caption = 'Budgeted Credit Amount';                    DrillDown = true;                    trigger OnDrillDown()                    begin                        BudgetDrillDown();                    end;                    trigger OnValidate()                    begin                        SetDateFilter();                        GLAcc.Validate("Budgeted Credit Amount");                        CalcFormFields();                    end;                }                field(BudgetedAmount; Rec."Budgeted Amount")                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    BlankZero = true;                    Caption = 'Budgeted Amount';                    DrillDown = true;                    Visible = false;                    trigger OnDrillDown()                    begin                        BudgetDrillDown();                    end;                    trigger OnValidate()                    begin                        SetDateFilter();                        GLAcc.Validate("Budgeted Amount");                        CalcFormFields();                    end;                }                field(BudgetPct; Rec."Balance/Budget Pct.")                {                    ApplicationArea = Suite;                    BlankZero = true;                    Caption = 'Balance/Budget (%)';                    DecimalPlaces = 1 : 1;                    Editable = false;                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    begin        if DateRec.Get(Rec."Period Type", Rec."Period Start") then;        SetDateFilter();        CalcFormFields();    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.";    protected var        GLAcc: Record "G/L Account";        ClosingEntryFilter: Option Include,Exclude;        PeriodType: Enum "Analysis Period Type";        AmountType: Enum "Analysis Amount Type";    /// <summary>    /// Configures the page with G/L account data and analysis parameters for period-based comparison.    /// </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 analysis</param>    procedure SetLines(var NewGLAcc: Record "G/L Account"; NewPeriodType: Enum "Analysis Period Type"; NewAmountType: Enum "Analysis Amount Type"; NewClosingEntryFilter: Option Include,Exclude)    begin        GLAcc.Copy(NewGLAcc);        Rec.DeleteAll();        if GLAcc.GetFilter("Date Filter") <> '' then begin            Rec.FilterGroup(2);            Rec.SetFilter("Period Start", GLAcc.GetFilter("Date Filter"));            Rec.FilterGroup(0);            DateRec.FilterGroup(2);            DateRec.SetFilter("Period Start", GLAcc.GetFilter("Date Filter"));            DateRec.FilterGroup(0);        end;        PeriodType := NewPeriodType;        AmountType := NewAmountType;        ClosingEntryFilter := NewClosingEntryFilter;        CurrPage.Update(false);    end;    local procedure BalanceDrillDown()    var        GLEntry: Record "G/L Entry";    begin        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"));        OnBalanceDrillDownOnAfterSetFilters(GLEntry, GLAcc);        PAGE.Run(0, GLEntry);    end;    local procedure BudgetDrillDown()    var        GLBudgetEntry: Record "G/L Budget Entry";    begin        SetDateFilter();        GLBudgetEntry.Reset();        GLBudgetEntry.SetCurrentKey("Budget Name", "G/L Account No.", Date);        GLBudgetEntry.SetFilter("Budget Name", GLAcc.GetFilter("Budget Filter"));        GLBudgetEntry.SetRange("G/L Account No.", GLAcc."No.");        if GLAcc.Totaling <> '' then            GLBudgetEntry.SetFilter("G/L Account No.", GLAcc.Totaling);        GLBudgetEntry.SetFilter(Date, GLAcc.GetFilter("Date Filter"));        GLBudgetEntry.SetFilter("Global Dimension 1 Code", GLAcc.GetFilter("Global Dimension 1 Filter"));        GLBudgetEntry.SetFilter("Global Dimension 2 Code", GLAcc.GetFilter("Global Dimension 2 Filter"));        GLBudgetEntry.SetFilter("Business Unit Code", GLAcc.GetFilter("Business Unit Filter"));        OnBudgetDrillDownOnAfterSetFilters(GLBudgetEntry, GLAcc);        PAGE.Run(0, GLBudgetEntry);    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 CalcFormFields()    begin        GLAcc.CalcFields("Net Change", "Debit Amount", "Credit Amount", "Budgeted Amount");        Rec."Debit Amount" := GLAcc."Debit Amount";        Rec."Credit Amount" := GLAcc."Credit Amount";        Rec."Net Change" := GLAcc."Net Change";        Rec."Budgeted Debit Amount" := GLAcc."Budgeted Amount";        Rec."Budgeted Credit Amount" := -GLAcc."Budgeted Amount";        Rec."Budgeted Amount" := GLAcc."Budgeted Amount";        if GLAcc."Budgeted Amount" = 0 then            Rec."Balance/Budget Pct." := 0        else            Rec."Balance/Budget Pct." := Round(GLAcc."Net Change" / GLAcc."Budgeted Amount" * 100);        OnAfterCalcFormFields(GLAcc, Rec."Balance/Budget Pct.", Rec, ClosingEntryFilter);    end;    /// <summary>    /// Returns the current G/L account filter configuration used by the page.    /// </summary>    /// <param name="NewGLAcc">G/L account record to populate with current filter settings</param>    procedure GetGLAcc(var NewGLAcc: Record "G/L Account")    begin        NewGLAcc.Copy(GLAcc);    end;    /// <summary>    /// Integration event for custom calculation logic after computing form field values and budget percentages.    /// </summary>    /// <param name="GLAccount">G/L account being analyzed</param>    /// <param name="BudgetPct">Budget percentage calculation result</param>    /// <param name="GLAccBalanceBudgetBuffer">Balance/budget buffer record with calculated values</param>    /// <param name="ClosingEntryFilter">Closing entry filter setting (Include or Exclude)</param>    [IntegrationEvent(false, false)]    local procedure OnAfterCalcFormFields(var GLAccount: Record "G/L Account"; var BudgetPct: Decimal; var GLAccBalanceBudgetBuffer: Record "G/L Acc. Balance/Budget Buffer"; ClosingEntryFilter: Option Include,Exclude)    begin    end;    /// <summary>    /// Integration event for custom filter logic when drilling down to G/L entries from balance analysis.    /// </summary>    /// <param name="GLEntry">G/L entry record for drill-down filtering</param>    /// <param name="GLAccount">G/L account context for filter application</param>    [IntegrationEvent(true, false)]    local procedure OnBalanceDrillDownOnAfterSetFilters(var GLEntry: Record "G/L Entry"; GLAccount: Record "G/L Account")    begin    end;    /// <summary>    /// Integration event for custom filter logic when drilling down to G/L budget entries from budget analysis.    /// </summary>    /// <param name="GLBudgetEntry">G/L budget entry record for drill-down filtering</param>    /// <param name="GLAccount">G/L account context for filter application</param>    [IntegrationEvent(false, false)]    local procedure OnBudgetDrillDownOnAfterSetFilters(var GLBudgetEntry: Record "G/L Budget Entry"; GLAccount: Record "G/L Account")    begin    end;}