Page 9233 G/L Balance by Dim. Matrix

Base Application, Microsoft.Finance.Analysis

src/Layers/W1/BaseApp/Finance/Analysis/GLBalancebyDimMatrix.Page.al1,752 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.Consolidation;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Period;using System.Utilities;/// <summary>/// Matrix page displaying G/L balance data by dimensions with configurable column perspectives./// Provides dynamic matrix view of G/L account balances organized by dimensional analysis with drill-down capabilities./// </summary>page 9233 "G/L Balance by Dim. Matrix"{    Caption = 'G/L Balance by Dim. Matrix';    DeleteAllowed = false;    InsertAllowed = false;    LinksAllowed = false;    PageType = List;    SourceTable = "Dimension Code Buffer";    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(Control1)            {                Editable = false;                IndentationColumn = Rec.Indentation;                IndentationControls = Name;                ShowCaption = false;                field("Code"; Rec.Code)                {                    ApplicationArea = Suite;                    Style = Strong;                    StyleExpr = Emphasize;                    trigger OnLookup(var Text: Text): Boolean                    begin                        LookUpCode(AnalysisByDimParameters."Line Dim Option", LineDimCode, Rec.Code);                    end;                }                field(Name; Rec.Name)                {                    ApplicationArea = Suite;                    Style = Strong;                    StyleExpr = Emphasize;                }                field(TotalAmount; Rec.Amount)                {                    ApplicationArea = Suite;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    Caption = 'Total Amount';                    Style = Strong;                    StyleExpr = Emphasize;                    trigger OnDrillDown()                    begin                        DrillDown(false);                    end;                }                field(Field1; MATRIX_CellData[1])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[1];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field1Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(1);                        DrillDown(true);                    end;                }                field(Field2; MATRIX_CellData[2])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[2];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field2Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(2);                        DrillDown(true);                    end;                }                field(Field3; MATRIX_CellData[3])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[3];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field3Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(3);                        DrillDown(true);                    end;                }                field(Field4; MATRIX_CellData[4])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[4];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field4Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(4);                        DrillDown(true);                    end;                }                field(Field5; MATRIX_CellData[5])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[5];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field5Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(5);                        DrillDown(true);                    end;                }                field(Field6; MATRIX_CellData[6])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[6];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field6Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(6);                        DrillDown(true);                    end;                }                field(Field7; MATRIX_CellData[7])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[7];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field7Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(7);                        DrillDown(true);                    end;                }                field(Field8; MATRIX_CellData[8])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[8];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field8Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(8);                        DrillDown(true);                    end;                }                field(Field9; MATRIX_CellData[9])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[9];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field9Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(9);                        DrillDown(true);                    end;                }                field(Field10; MATRIX_CellData[10])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[10];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field10Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(10);                        DrillDown(true);                    end;                }                field(Field11; MATRIX_CellData[11])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[11];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field11Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(11);                        DrillDown(true);                    end;                }                field(Field12; MATRIX_CellData[12])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[12];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field12Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(12);                        DrillDown(true);                    end;                }                field(Field13; MATRIX_CellData[13])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[13];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field13Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(13);                        DrillDown(true);                    end;                }                field(Field14; MATRIX_CellData[14])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[14];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field14Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(14);                        DrillDown(true);                    end;                }                field(Field15; MATRIX_CellData[15])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[15];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field15Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(15);                        DrillDown(true);                    end;                }                field(Field16; MATRIX_CellData[16])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[16];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field16Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(16);                        DrillDown(true);                    end;                }                field(Field17; MATRIX_CellData[17])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[17];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field17Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(17);                        DrillDown(true);                    end;                }                field(Field18; MATRIX_CellData[18])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[18];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field18Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(18);                        DrillDown(true);                    end;                }                field(Field19; MATRIX_CellData[19])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[19];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field19Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(19);                        DrillDown(true);                    end;                }                field(Field20; MATRIX_CellData[20])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[20];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field20Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(20);                        DrillDown(true);                    end;                }                field(Field21; MATRIX_CellData[21])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[21];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field21Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(21);                        DrillDown(true);                    end;                }                field(Field22; MATRIX_CellData[22])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[22];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field22Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(22);                        DrillDown(true);                    end;                }                field(Field23; MATRIX_CellData[23])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[23];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field23Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(23);                        DrillDown(true);                    end;                }                field(Field24; MATRIX_CellData[24])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[24];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field24Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(24);                        DrillDown(true);                    end;                }                field(Field25; MATRIX_CellData[25])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[25];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field25Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(25);                        DrillDown(true);                    end;                }                field(Field26; MATRIX_CellData[26])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[26];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field26Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(26);                        DrillDown(true);                    end;                }                field(Field27; MATRIX_CellData[27])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[27];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field27Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(27);                        DrillDown(true);                    end;                }                field(Field28; MATRIX_CellData[28])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[28];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field28Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(28);                        DrillDown(true);                    end;                }                field(Field29; MATRIX_CellData[29])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[29];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field29Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(29);                        DrillDown(true);                    end;                }                field(Field30; MATRIX_CellData[30])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[30];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field30Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(30);                        DrillDown(true);                    end;                }                field(Field31; MATRIX_CellData[31])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[31];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field31Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(31);                        DrillDown(true);                    end;                }                field(Field32; MATRIX_CellData[32])                {                    ApplicationArea = All;                    AutoFormatExpression = FormatStr();                    AutoFormatType = 11;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaptions[32];                    Style = Strong;                    StyleExpr = Emphasize;                    Visible = Field32Visible;                    trigger OnDrillDown()                    begin                        MATRIX_UpdateMatrixRecord(32);                        DrillDown(true);                    end;                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    var        MATRIX_CurrentColumnOrdinal: Integer;        MATRIX_Steps: Integer;    begin        // IF CurrForm.TotalAmount.VISIBLE THEN        Rec.Amount := MatrixMgt.RoundAmount(CalcAmount(false), AnalysisByDimParameters."Rounding Factor");        MATRIX_CurrentColumnOrdinal := 0;        MatrixRecord.SetPosition(MATRIX_PrimKeyFirstCol);        if MATRIX_OnFindRecord('=><') then begin            MATRIX_CurrentColumnOrdinal := 1;            repeat                MATRIX_ColumnOrdinal := MATRIX_CurrentColumnOrdinal;                MATRIX_OnAfterGetRecord();                MATRIX_Steps := MATRIX_OnNextRecord(1);                MATRIX_CurrentColumnOrdinal := MATRIX_CurrentColumnOrdinal + MATRIX_Steps;            until (MATRIX_CurrentColumnOrdinal - MATRIX_Steps = MATRIX_NoOfMatrixColumns) or (MATRIX_Steps = 0);            if MATRIX_CurrentColumnOrdinal <> 1 then                MATRIX_OnNextRecord(1 - MATRIX_CurrentColumnOrdinal);        end;        SetColumnVisibility();        FormatLine();    end;    trigger OnFindRecord(Which: Text): Boolean    begin        FindNext := false;        if AnalysisByDimParameters."Line Dim Option" = AnalysisByDimParameters."Line Dim Option"::"G/L Account" then begin            FindNext := true;            exit(Rec.Find(Which));        end;        exit(FindRec(AnalysisByDimParameters."Line Dim Option", Rec, Which));    end;    trigger OnInit()    begin        Field32Visible := true;        Field31Visible := true;        Field30Visible := true;        Field29Visible := true;        Field28Visible := true;        Field27Visible := true;        Field26Visible := true;        Field25Visible := true;        Field24Visible := true;        Field23Visible := true;        Field22Visible := true;        Field21Visible := true;        Field20Visible := true;        Field19Visible := true;        Field18Visible := true;        Field17Visible := true;        Field16Visible := true;        Field15Visible := true;        Field14Visible := true;        Field13Visible := true;        Field12Visible := true;        Field11Visible := true;        Field10Visible := true;        Field9Visible := true;        Field8Visible := true;        Field7Visible := true;        Field6Visible := true;        Field5Visible := true;        Field4Visible := true;        Field3Visible := true;        Field2Visible := true;        Field1Visible := true;    end;    trigger OnNextRecord(Steps: Integer): Integer    begin        exit(NextRec(AnalysisByDimParameters."Line Dim Option", Rec, Steps));    end;    trigger OnOpenPage()    begin        Rec.Code := '';        GLSetup.Get();        if (LineDimCode = '') and (ColumnDimCode = '') then begin            LineDimCode := GLAcc.TableCaption();            ColumnDimCode := Text001;        end;        AnalysisByDimParameters."Line Dim Option" := DimCodeToOption(LineDimCode);        AnalysisByDimParameters."Column Dim Option" := DimCodeToOption(ColumnDimCode);        InitRecord(Rec, AnalysisByDimParameters."Line Dim Option");        CalculateClosingDateFilter();        MATRIX_NoOfMatrixColumns := ArrayLen(MATRIX_CellData);        if not PeriodInitialized then            LoadDefault();        FindRec(AnalysisByDimParameters."Column Dim Option", MatrixRecord, '=');        SetColumnVisibility();        if MATRIX_PrimKeyFirstCol = '' then            MATRIX_PrimKeyFirstCol := MatrixRecord.GetPosition();    end;    var        GLSetup: Record "General Ledger Setup";        GLAcc: Record "G/L Account";        TempDimensionCodeAmountBuffer: Record "Dimension Code Amount Buffer" temporary;        CurrExchRate: Record "Currency Exchange Rate";        MatrixRecord: Record "Dimension Code Buffer";        MatrixMgt: Codeunit "Matrix Management";        LineDimCode: Text[30];        ColumnDimCode: Text[30];        ExcludeClosingDateFilter: Text;        InternalDateFilter: Text;        MatrixAmount: Decimal;        PeriodInitialized: Boolean;        CurrExchDate: Date;        MATRIX_ColumnOrdinal: Integer;        MATRIX_NoOfMatrixColumns: Integer;        MATRIX_CellData: array[32] of Decimal;        MATRIX_ColumnCaptions: array[32] of Text[1024];        MATRIX_PrimKeyFirstCol: Text[1024];        RoundingFactorFormatString: Text;        MATRIX_CurrSetLength: Integer;        Field1Visible: Boolean;        Field2Visible: Boolean;        Field3Visible: Boolean;        Field4Visible: Boolean;        Field5Visible: Boolean;        Field6Visible: Boolean;        Field7Visible: Boolean;        Field8Visible: Boolean;        Field9Visible: Boolean;        Field10Visible: Boolean;        Field11Visible: Boolean;        Field12Visible: Boolean;        Field13Visible: Boolean;        Field14Visible: Boolean;        Field15Visible: Boolean;        Field16Visible: Boolean;        Field17Visible: Boolean;        Field18Visible: Boolean;        Field19Visible: Boolean;        Field20Visible: Boolean;        Field21Visible: Boolean;        Field22Visible: Boolean;        Field23Visible: Boolean;        Field24Visible: Boolean;        Field25Visible: Boolean;        Field26Visible: Boolean;        Field27Visible: Boolean;        Field28Visible: Boolean;        Field29Visible: Boolean;        Field30Visible: Boolean;        Field31Visible: Boolean;        Field32Visible: Boolean;        Emphasize: Boolean;        FindNext: Boolean;#pragma warning disable AA0074        Text001: Label 'Period';#pragma warning restore AA0074    protected var        AnalysisByDimParameters: Record "Analysis by Dim. Parameters";    local procedure DimCodeToOption(DimCode: Text[30]) Result: Enum "Analysis Dimension Option"    var        BusUnit: Record "Business Unit";        ResultInt: Integer;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeDimCodeToOption(DimCode, ResultInt, IsHandled);        Result := "Analysis Dimension Option".FromInteger(ResultInt);        if IsHandled then            exit(Result);        case DimCode of            '':                exit("Analysis Dimension Option"::Undefined);            GLAcc.TableCaption:                exit("Analysis Dimension Option"::"G/L Account");            Text001:                exit("Analysis Dimension Option"::Period);            BusUnit.TableCaption:                exit("Analysis Dimension Option"::"Business Unit");            GLSetup."Global Dimension 1 Code":                exit("Analysis Dimension Option"::"Dimension 1");            GLSetup."Global Dimension 2 Code":                exit("Analysis Dimension Option"::"Dimension 2");            else                exit("Analysis Dimension Option"::Undefined);        end;    end;    local procedure FindRec(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Which: Text[1024]) Found: Boolean    var        GLAcc: Record "G/L Account";        BusUnit: Record "Business Unit";        Period: Record Date;        DimVal: Record "Dimension Value";        PeriodPageMgt: Codeunit PeriodPageManagement;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeFindRec(DimOption, DimVal, GLAcc, DimCodeBuf, Which, Found, IsHandled);        if not IsHandled then            case DimOption of                DimOption::"G/L Account":                    begin                        GLAcc."No." := DimCodeBuf.Code;                        if AnalysisByDimParameters."Account Filter" <> '' then                            GLAcc.SetFilter("No.", AnalysisByDimParameters."Account Filter");                        Found := GLAcc.Find(Which);                        if Found then                            CopyGLAccToBuf(GLAcc, DimCodeBuf);                    end;                DimOption::Period:                    begin                        if not PeriodInitialized then                            AnalysisByDimParameters."Date Filter" := '';                        PeriodInitialized := true;                        Evaluate(Period."Period Start", DimCodeBuf.Code);                        if AnalysisByDimParameters."Date Filter" <> '' then                            Period.SetFilter("Period Start", AnalysisByDimParameters."Date Filter")                        else                            if not PeriodInitialized and (InternalDateFilter <> '') then                                Period.SetFilter("Period Start", InternalDateFilter);                        Found := PeriodPageMgt.FindDate(Which, Period, AnalysisByDimParameters."Period Type");                        if Found then                            CopyPeriodToBuf(Period, DimCodeBuf);                    end;                DimOption::"Business Unit":                    begin                        BusUnit.Code := DimCodeBuf.Code;                        if AnalysisByDimParameters."Bus. Unit Filter" <> '' then                            BusUnit.SetFilter(Code, AnalysisByDimParameters."Bus. Unit Filter");                        Found := BusUnit.Find(Which);                        if Found then                            CopyBusUnitToBuf(BusUnit, DimCodeBuf);                    end;                DimOption::"Dimension 1":                    begin                        if AnalysisByDimParameters."Dimension 1 Filter" <> '' then                            DimVal.SetFilter(Code, AnalysisByDimParameters."Dimension 1 Filter");                        DimVal."Dimension Code" := GLSetup."Global Dimension 1 Code";                        DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                        DimVal.Code := DimCodeBuf.Code;                        Found := DimVal.Find(Which);                        if Found then                            CopyDimValueToBuf(DimVal, DimCodeBuf);                    end;                DimOption::"Dimension 2":                    begin                        if AnalysisByDimParameters."Dimension 2 Filter" <> '' then                            DimVal.SetFilter(Code, AnalysisByDimParameters."Dimension 2 Filter");                        DimVal."Dimension Code" := GLSetup."Global Dimension 2 Code";                        DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                        DimVal.Code := DimCodeBuf.Code;                        Found := DimVal.Find(Which);                        if Found then                            CopyDimValueToBuf(DimVal, DimCodeBuf);                    end;            end;        OnAfterFindRec(DimOption.AsInteger(), DimCodeBuf, Which, Found, AnalysisByDimParameters);    end;    local procedure NextRec(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Steps: Integer) ResultSteps: Integer    var        GLAcc: Record "G/L Account";        BusUnit: Record "Business Unit";        Period: Record Date;        DimVal: Record "Dimension Value";        PeriodPageMgt: Codeunit PeriodPageManagement;    begin        OnBeforeNextRec(DimOption, DimVal, GLAcc);        case DimOption of            DimOption::"G/L Account":                begin                    if FindNext then                        exit(DimCodeBuf.Next(Steps));                    GLAcc."No." := DimCodeBuf.Code;                    if AnalysisByDimParameters."Account Filter" <> '' then                        GLAcc.SetFilter("No.", AnalysisByDimParameters."Account Filter");                    ResultSteps := GLAcc.Next(Steps);                    if ResultSteps <> 0 then begin                        CopyGLAccToBuf(GLAcc, DimCodeBuf);                        if not DimCodeBuf.Get(GLAcc."No.") then                            DimCodeBuf.Insert();                    end;                end;            DimOption::Period:                begin                    if AnalysisByDimParameters."Date Filter" <> '' then                        Period.SetFilter("Period Start", AnalysisByDimParameters."Date Filter");                    Period."Period Start" := DimCodeBuf."Period Start";                    ResultSteps := PeriodPageMgt.NextDate(Steps, Period, AnalysisByDimParameters."Period Type");                    if ResultSteps <> 0 then                        CopyPeriodToBuf(Period, DimCodeBuf);                end;            DimOption::"Business Unit":                begin                    BusUnit.Code := DimCodeBuf.Code;                    if AnalysisByDimParameters."Bus. Unit Filter" <> '' then                        BusUnit.SetFilter(Code, AnalysisByDimParameters."Bus. Unit Filter");                    ResultSteps := BusUnit.Next(Steps);                    if ResultSteps <> 0 then                        CopyBusUnitToBuf(BusUnit, DimCodeBuf);                end;            DimOption::"Dimension 1":                begin                    if AnalysisByDimParameters."Dimension 1 Filter" <> '' then                        DimVal.SetFilter(Code, AnalysisByDimParameters."Dimension 1 Filter");                    DimVal."Dimension Code" := GLSetup."Global Dimension 1 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    ResultSteps := DimVal.Next(Steps);                    if ResultSteps <> 0 then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;            DimOption::"Dimension 2":                begin                    if AnalysisByDimParameters."Dimension 2 Filter" <> '' then                        DimVal.SetFilter(Code, AnalysisByDimParameters."Dimension 2 Filter");                    DimVal."Dimension Code" := GLSetup."Global Dimension 2 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    ResultSteps := DimVal.Next(Steps);                    if ResultSteps <> 0 then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;        end;        OnAfterNextRec(DimOption.AsInteger(), DimCodeBuf, Steps, ResultSteps, AnalysisByDimParameters);    end;    local procedure CopyGLAccToBuf(var TheGLAcc: Record "G/L Account"; var TheDimCodeBuf: Record "Dimension Code Buffer")    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := TheGLAcc."No.";        TheDimCodeBuf.Name := TheGLAcc.Name;        TheDimCodeBuf.Totaling := TheGLAcc.Totaling;        TheDimCodeBuf.Indentation := TheGLAcc.Indentation;        TheDimCodeBuf."Show in Bold" := TheGLAcc."Account Type" <> TheGLAcc."Account Type"::Posting;        OnAfterCopyGLAccToBuf(TheGLAcc, TheDimCodeBuf);    end;    local procedure CopyPeriodToBuf(var ThePeriod: Record Date; var TheDimCodeBuf: Record "Dimension Code Buffer")    var        Period2: Record Date;    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := Format(ThePeriod."Period Start");        TheDimCodeBuf."Period Start" := ThePeriod."Period Start";        if AnalysisByDimParameters."Closing Entries" = AnalysisByDimParameters."Closing Entries"::Include then            TheDimCodeBuf."Period End" := ClosingDate(ThePeriod."Period End")        else            TheDimCodeBuf."Period End" := ThePeriod."Period End";        if AnalysisByDimParameters."Date Filter" <> '' then begin            Period2.SetFilter("Period End", AnalysisByDimParameters."Date Filter");            if Period2.GetRangeMax("Period End") < TheDimCodeBuf."Period End" then                TheDimCodeBuf."Period End" := Period2.GetRangeMax("Period End");        end;        TheDimCodeBuf.Name := ThePeriod."Period Name";    end;    local procedure CopyBusUnitToBuf(var TheBusUnit: Record "Business Unit"; var TheDimCodeBuf: Record "Dimension Code Buffer")    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := TheBusUnit.Code;        TheDimCodeBuf.Name := TheBusUnit.Name;    end;    local procedure CopyDimValueToBuf(var TheDimVal: Record "Dimension Value"; var TheDimCodeBuf: Record "Dimension Code Buffer")    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := TheDimVal.Code;        TheDimCodeBuf.Name := TheDimVal.Name;        TheDimCodeBuf.Totaling := TheDimVal.Totaling;        TheDimCodeBuf.Indentation := TheDimVal.Indentation;        TheDimCodeBuf."Show in Bold" :=          TheDimVal."Dimension Value Type" <> TheDimVal."Dimension Value Type"::Standard;        OnAfterCopyDimValueToBuf(TheDimVal, TheDimCodeBuf);    end;    local procedure FindPeriod(SearchText: Code[10])    var        Period: Record Date;        PeriodPageMgt: Codeunit PeriodPageManagement;    begin        if AnalysisByDimParameters."Date Filter" <> '' then begin            Period.SetFilter("Period Start", AnalysisByDimParameters."Date Filter");            if not PeriodPageMgt.FindDate('+', Period, AnalysisByDimParameters."Period Type") then                PeriodPageMgt.FindDate('+', Period, AnalysisByDimParameters."Period Type"::Day);            Period.SetRange("Period Start");        end;        if PeriodPageMgt.FindDate(SearchText, Period, AnalysisByDimParameters."Period Type") then            if AnalysisByDimParameters."Closing Entries" = AnalysisByDimParameters."Closing Entries"::Include then                Period."Period End" := ClosingDate(Period."Period End");        if AnalysisByDimParameters."Amount Type" = AnalysisByDimParameters."Amount Type"::"Net Change" then begin            GLAcc.SetRange("Date Filter", Period."Period Start", Period."Period End");            if GLAcc.GetRangeMin("Date Filter") = GLAcc.GetRangeMax("Date Filter") then                GLAcc.SetRange("Date Filter", GLAcc.GetRangeMin("Date Filter"));        end else            GLAcc.SetRange("Date Filter", 0D, Period."Period End");        InternalDateFilter := GLAcc.GetFilter("Date Filter");        if (AnalysisByDimParameters."Line Dim Option" <> AnalysisByDimParameters."Line Dim Option"::Period) and (AnalysisByDimParameters."Column Dim Option" <> AnalysisByDimParameters."Column Dim Option"::Period) then            AnalysisByDimParameters."Date Filter" := InternalDateFilter;        TempDimensionCodeAmountBuffer.DeleteAll();    end;    local procedure CalculateClosingDateFilter()    var        AccountingPeriod: Record "Accounting Period";        FirstRec: Boolean;    begin        if AnalysisByDimParameters."Closing Entries" = AnalysisByDimParameters."Closing Entries"::Include then            ExcludeClosingDateFilter := ''        else begin            AccountingPeriod.SetCurrentKey("New Fiscal Year");            AccountingPeriod.SetRange("New Fiscal Year", true);            FirstRec := true;            if AccountingPeriod.Find('-') then                repeat                    if FirstRec then                        ExcludeClosingDateFilter :=                          StrSubstNo('<>%1', ClosingDate(AccountingPeriod."Starting Date" - 1))                    else                        ExcludeClosingDateFilter :=                          StrSubstNo('%1&<>%2', ExcludeClosingDateFilter, ClosingDate(AccountingPeriod."Starting Date" - 1));                    FirstRec := false;                until AccountingPeriod.Next() = 0;        end;    end;    local procedure LookUpCode(DimOption: Enum "Analysis Dimension Option"; DimCode: Text[30]; "Code": Text[30])    var        GLAcc: Record "G/L Account";        BusUnit: Record "Business Unit";        DimVal: Record "Dimension Value";        DimOption2: Option;    begin        case DimOption of            DimOption::"G/L Account":                begin                    GLAcc.Get(Code);                    PAGE.RunModal(PAGE::"G/L Account List", GLAcc);                end;            DimOption::Period:                ;            DimOption::"Business Unit":                begin                    BusUnit.Get(Code);                    PAGE.RunModal(PAGE::"Business Unit List", BusUnit);                end;            DimOption::"Dimension 1", DimOption::"Dimension 2":                begin                    DimVal.SetRange("Dimension Code", DimCode);                    DimVal.Get(DimCode, Code);                    PAGE.RunModal(PAGE::"Dimension Value List", DimVal);                end;            else begin                DimOption2 := DimOption.AsInteger();                OnLookupCodeOnCaseElse(DimOption2, DimCode, Code);                DimOption := "Analysis Dimension Option".FromInteger(DimOption2);            end;        end;    end;    local procedure SetCommonFilters(var TheGLAcc: Record "G/L Account")    var        DateFilter2: Text;    begin        Clear(TheGLAcc);        if AnalysisByDimParameters."Date Filter" = '' then            DateFilter2 := ExcludeClosingDateFilter        else begin            if AnalysisByDimParameters."Amount Type" = AnalysisByDimParameters."Amount Type"::"Net Change" then                DateFilter2 := AnalysisByDimParameters."Date Filter"            else begin                TheGLAcc.SetFilter("Date Filter", AnalysisByDimParameters."Date Filter");                DateFilter2 := StrSubstNo('..%1', TheGLAcc.GetRangeMax(TheGLAcc."Date Filter"));            end;            if ExcludeClosingDateFilter <> '' then                DateFilter2 := StrSubstNo('%1 & %2', DateFilter2, ExcludeClosingDateFilter);        end;        TheGLAcc.Reset();        if AnalysisByDimParameters."Account Filter" <> '' then            TheGLAcc.SetFilter("No.", AnalysisByDimParameters."Account Filter")        else            TheGLAcc.SetRange(TheGLAcc."No.");        if AnalysisByDimParameters."Account Filter" <> '' then            TheGLAcc.Totaling := CopyStr(AnalysisByDimParameters."Account Filter", 1, MaxStrLen(TheGLAcc.Totaling))        else            if TheGLAcc."No." = '' then                TheGLAcc.Totaling := StrSubstNo('>%1', '''''');        TheGLAcc.SetFilter("Date Filter", DateFilter2);        if AnalysisByDimParameters."Bus. Unit Filter" <> '' then            TheGLAcc.SetFilter("Business Unit Filter", AnalysisByDimParameters."Bus. Unit Filter");        if AnalysisByDimParameters."Dimension 1 Filter" <> '' then            TheGLAcc.SetFilter("Global Dimension 1 Filter", GetDimValueTotaling(AnalysisByDimParameters."Dimension 1 Filter", GLSetup."Global Dimension 1 Code"));        if AnalysisByDimParameters."Dimension 2 Filter" <> '' then            TheGLAcc.SetFilter("Global Dimension 2 Filter", GetDimValueTotaling(AnalysisByDimParameters."Dimension 2 Filter", GLSetup."Global Dimension 2 Code"));        if AnalysisByDimParameters."Budget Filter" = '' then            TheGLAcc.SetRange(TheGLAcc."Budget Filter")        else            TheGLAcc.SetFilter("Budget Filter", AnalysisByDimParameters."Budget Filter");        OnAfterSetCommonFilters(TheGLAcc, AnalysisByDimParameters);    end;    local procedure SetDimFilters(var TheGLAcc: Record "G/L Account"; LineOrColumn: Option Line,Column)    var        DimCodeBuf: Record "Dimension Code Buffer";        DimOption: Enum "Analysis Dimension Option";    begin        if LineOrColumn = LineOrColumn::Line then begin            DimCodeBuf := Rec;            DimOption := AnalysisByDimParameters."Line Dim Option";        end else begin            DimCodeBuf := MatrixRecord;            DimOption := AnalysisByDimParameters."Column Dim Option";        end;        case DimOption of            DimOption::"G/L Account":                begin                    TheGLAcc."No." := DimCodeBuf.Code;                    TheGLAcc.Totaling := DimCodeBuf.Totaling;                end;            DimOption::Period:                begin                    if AnalysisByDimParameters."Amount Type" = AnalysisByDimParameters."Amount Type"::"Net Change" then                        TheGLAcc.SetRange(                          "Date Filter", DimCodeBuf."Period Start", DimCodeBuf."Period End")                    else                        TheGLAcc.SetRange("Date Filter", 0D, DimCodeBuf."Period End");                    if (AnalysisByDimParameters."Closing Entries" = AnalysisByDimParameters."Closing Entries"::Exclude) and (ExcludeClosingDateFilter <> '') then                        TheGLAcc.SetFilter(                          "Date Filter", TheGLAcc.GetFilter("Date Filter") +                          '&' + ExcludeClosingDateFilter);                end;            DimOption::"Business Unit":                TheGLAcc.SetRange("Business Unit Filter", DimCodeBuf.Code);            DimOption::"Dimension 1":                if DimCodeBuf.Totaling = '' then                    TheGLAcc.SetRange("Global Dimension 1 Filter", DimCodeBuf.Code)                else                    TheGLAcc.SetFilter("Global Dimension 1 Filter", DimCodeBuf.Totaling);            DimOption::"Dimension 2":                if DimCodeBuf.Totaling = '' then                    TheGLAcc.SetRange("Global Dimension 2 Filter", DimCodeBuf.Code)                else                    TheGLAcc.SetFilter("Global Dimension 2 Filter", DimCodeBuf.Totaling);            else                OnSetDimFiltersOnCaseElse(DimOption.AsInteger(), TheGLAcc, DimCodeBuf);        end;    end;    local procedure DrillDown(SetColFilter: Boolean)    var        GLEntry: Record "G/L Entry";        GLBudgetEntry: Record "G/L Budget Entry";        IsHandled: Boolean;    begin        SetCommonFilters(GLAcc);        SetDimFilters(GLAcc, 0);        if SetColFilter then            SetDimFilters(GLAcc, 1);        IsHandled := false;        OnBeforeDrillDown(SetColFilter, GLAcc, AnalysisByDimParameters, IsHandled, GLEntry, GLBudgetEntry);        if IsHandled then            exit;        if AnalysisByDimParameters."Show Actual/Budgets" = AnalysisByDimParameters."Show Actual/Budgets"::"Actual Amounts" then begin            if GLAcc."No." <> '' then                GLEntry.SetRange("G/L Account No.", GLAcc."No.");            if GLAcc.Totaling <> '' then                GLEntry.SetFilter(GLEntry."G/L Account No.", GLAcc.Totaling);            GLAcc.CopyFilter("Date Filter", GLEntry."Posting Date");            GLAcc.CopyFilter("Global Dimension 1 Filter", GLEntry."Global Dimension 1 Code");            GLAcc.CopyFilter("Global Dimension 2 Filter", GLEntry."Global Dimension 2 Code");            GLAcc.CopyFilter("Business Unit Filter", GLEntry."Business Unit Code");            if (GLEntry.GetFilter("Global Dimension 1 Code") <> '') or (GLEntry.GetFilter("Global Dimension 2 Code") <> '') or               (GLEntry.GetFilter("Business Unit Code") <> '')            then                GLEntry.SetCurrentKey("G/L Account No.", "Business Unit Code", "Global Dimension 1 Code")            else                GLEntry.SetCurrentKey("G/L Account No.", "Posting Date");            OnDrillDownOnBeforeRunGeneralLedgerEntriesPage(GLAcc, GLEntry);            PAGE.Run(PAGE::"General Ledger Entries", GLEntry);        end;        if AnalysisByDimParameters."Show Actual/Budgets" = AnalysisByDimParameters."Show Actual/Budgets"::"Budgeted Amounts" then begin            GLAcc.CopyFilter("Budget Filter", GLBudgetEntry."Budget Name");            if GLAcc."No." <> '' then                GLBudgetEntry.SetRange("G/L Account No.", GLAcc."No.");            if GLAcc.Totaling <> '' then                GLBudgetEntry.SetFilter(GLBudgetEntry."G/L Account No.", GLAcc.Totaling);            GLAcc.CopyFilter("Date Filter", GLBudgetEntry.Date);            GLAcc.CopyFilter("Global Dimension 1 Filter", GLBudgetEntry."Global Dimension 1 Code");            GLAcc.CopyFilter("Global Dimension 2 Filter", GLBudgetEntry."Global Dimension 2 Code");            GLAcc.CopyFilter("Business Unit Filter", GLBudgetEntry."Business Unit Code");            if (GLBudgetEntry.GetFilter("Global Dimension 1 Code") <> '') or (GLBudgetEntry.GetFilter("Global Dimension 2 Code") <> '') or               (GLBudgetEntry.GetFilter("Business Unit Code") <> '')            then                GLBudgetEntry.SetCurrentKey("Budget Name", "G/L Account No.", "Business Unit Code", "Global Dimension 1 Code")            else                GLBudgetEntry.SetCurrentKey("Budget Name", "G/L Account No.", Date);            OnDrillDownOnBeforeRunGLBudgetEntriesPage(GLAcc, GLBudgetEntry);            PAGE.Run(PAGE::"G/L Budget Entries", GLBudgetEntry);        end;    end;    local procedure CalcAmount(SetColFilter: Boolean): Decimal    var        Amount: Decimal;        ColumnCode: Code[20];    begin        if SetColFilter then            ColumnCode := MatrixRecord.Code        else            ColumnCode := '';        if TempDimensionCodeAmountBuffer.Get(Rec.Code, ColumnCode) then            exit(TempDimensionCodeAmountBuffer.Amount);        GLAcc.Reset();        SetCommonFilters(GLAcc);        SetDimFilters(GLAcc, 0);        if SetColFilter then            SetDimFilters(GLAcc, 1);        OnCalcAmountOnAfterGLAccSetFilters(GLAcc, SetColFilter);        case AnalysisByDimParameters."Show Actual/Budgets" of            AnalysisByDimParameters."Show Actual/Budgets"::"Actual Amounts":                Amount := CalcActualAmount();            AnalysisByDimParameters."Show Actual/Budgets"::"Budgeted Amounts":                Amount := CalcBudgAmount();            AnalysisByDimParameters."Show Actual/Budgets"::Variance:                Amount := CalcActualAmount() - CalcBudgAmount();            AnalysisByDimParameters."Show Actual/Budgets"::"Variance%":                begin                    Amount := CalcBudgAmount();                    if Amount <> 0 then                        Amount := Round(100 * (CalcActualAmount() - Amount) / Amount);                end;            AnalysisByDimParameters."Show Actual/Budgets"::"Index%":                begin                    Amount := CalcBudgAmount();                    if Amount <> 0 then                        Amount := Round(100 * CalcActualAmount() / Amount);                end;        end;        OnCalcAmountOnAfterAssignAmount(AnalysisByDimParameters, GLAcc, Amount);        TempDimensionCodeAmountBuffer."Line Code" := Rec.Code;        TempDimensionCodeAmountBuffer."Column Code" := ColumnCode;        TempDimensionCodeAmountBuffer.Amount := Amount;        TempDimensionCodeAmountBuffer.Insert();        exit(Amount);    end;    local procedure CalcActualAmount(): Decimal    var        Amount: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcActualAmounts(GLAcc, AnalysisByDimParameters, Amount, IsHandled);        if IsHandled then            exit(Amount);        if AnalysisByDimParameters."Show In Add. Currency" then            case AnalysisByDimParameters."Show Amount Field" of                AnalysisByDimParameters."Show Amount Field"::Amount:                    begin                        GLAcc.CalcFields("Additional-Currency Net Change");                        Amount := GLAcc."Additional-Currency Net Change";                    end;                AnalysisByDimParameters."Show Amount Field"::"Debit Amount":                    begin                        GLAcc.CalcFields("Add.-Currency Debit Amount");                        Amount := GLAcc."Add.-Currency Debit Amount";                    end;                AnalysisByDimParameters."Show Amount Field"::"Credit Amount":                    begin                        GLAcc.CalcFields("Add.-Currency Credit Amount");                        Amount := GLAcc."Add.-Currency Credit Amount";                    end;            end        else            case AnalysisByDimParameters."Show Amount Field" of                AnalysisByDimParameters."Show Amount Field"::Amount:                    begin                        GLAcc.CalcFields("Net Change");                        Amount := GLAcc."Net Change";                    end;                AnalysisByDimParameters."Show Amount Field"::"Debit Amount":                    begin                        GLAcc.CalcFields("Debit Amount");                        Amount := GLAcc."Debit Amount";                    end;                AnalysisByDimParameters."Show Amount Field"::"Credit Amount":                    begin                        GLAcc.CalcFields("Credit Amount");                        Amount := GLAcc."Credit Amount";                    end;            end;        OnAfterCalcActualAmount(GLAcc, AnalysisByDimParameters, Amount);        exit(Amount);    end;    local procedure CalcBudgAmount(): Decimal    var        Amount: Decimal;    begin        if AnalysisByDimParameters."Budget Filter" = '' then            GLAcc.SetRange("Budget Filter")        else            GLAcc.SetFilter("Budget Filter", AnalysisByDimParameters."Budget Filter");        GLAcc.CalcFields("Budgeted Amount");        Amount := GLAcc."Budgeted Amount";        case AnalysisByDimParameters."Show Amount Field" of            AnalysisByDimParameters."Show Amount Field"::"Debit Amount":                if Amount < 0 then                    Amount := 0;            AnalysisByDimParameters."Show Amount Field"::"Credit Amount":                if Amount > 0 then                    Amount := 0                else                    Amount := -Amount;        end;        if (Amount <> 0) and AnalysisByDimParameters."Show In Add. Currency" then begin            if GLAcc.GetFilter("Date Filter") = '' then                CurrExchDate := WorkDate()            else                CurrExchDate := GLAcc.GetRangeMin("Date Filter");            Amount :=              CurrExchRate.ExchangeAmtLCYToFCY(                CurrExchDate, GLSetup."Additional Reporting Currency", Amount,                CurrExchRate.ExchangeRate(CurrExchDate, GLSetup."Additional Reporting Currency"));        end;        OnAfterCalcBudgetAmount(GLAcc, AnalysisByDimParameters, Amount);        exit(Amount);    end;    local procedure MATRIX_UpdateMatrixRecord(MATRIX_NewColumnOrdinal: Integer)    begin        MATRIX_ColumnOrdinal := MATRIX_NewColumnOrdinal;        MatrixRecord.SetPosition(MATRIX_PrimKeyFirstCol);        MATRIX_OnFindRecord('=');        if MATRIX_ColumnOrdinal <> 1 then            MATRIX_OnNextRecord(MATRIX_ColumnOrdinal - 1);    end;    local procedure MATRIX_OnFindRecord(Which: Text[1024]): Boolean    begin        exit(FindRec(AnalysisByDimParameters."Column Dim Option", MatrixRecord, Which));    end;    local procedure MATRIX_OnNextRecord(Steps: Integer): Integer    begin        exit(NextRec(AnalysisByDimParameters."Column Dim Option", MatrixRecord, Steps));    end;    local procedure MATRIX_OnAfterGetRecord()    begin        MatrixAmount := MatrixMgt.RoundAmount(CalcAmount(true), AnalysisByDimParameters."Rounding Factor");        MATRIX_CellData[MATRIX_ColumnOrdinal] := MatrixAmount;    end;    /// <summary>    /// Loads matrix configuration and parameters for dimensional analysis display.    /// Initializes the matrix page with analysis parameters, dimension codes, column captions, and primary key positioning.    /// </summary>    /// <param name="NewAnalysisByDimParameters">Analysis parameters defining filters, rounding, and dimension options</param>    /// <param name="NewLineDimCode">Dimension code for row organization</param>    /// <param name="NewColumnDimCode">Dimension code for column organization</param>    /// <param name="NewMATRIX_ColumnCaptions">Array of column captions for matrix display</param>    /// <param name="NewPrimKeyFirstCol">Primary key positioning for first column</param>    /// <param name="CurrSetLength">Number of active columns in current matrix set</param>    procedure Load(NewAnalysisByDimParameters: Record "Analysis by Dim. Parameters"; NewLineDimCode: Text[30]; NewColumnDimCode: Text[30]; NewMATRIX_ColumnCaptions: array[32] of Text[1024]; NewPrimKeyFirstCol: Text[1024]; CurrSetLength: Integer)    begin        FindPeriod('');        AnalysisByDimParameters := NewAnalysisByDimParameters;        LineDimCode := NewLineDimCode;        ColumnDimCode := NewColumnDimCode;        MATRIX_CurrSetLength := CurrSetLength;        MATRIX_PrimKeyFirstCol := NewPrimKeyFirstCol;        PeriodInitialized := true;        CopyArray(MATRIX_ColumnCaptions, NewMATRIX_ColumnCaptions, 1);        RoundingFactorFormatString := MatrixMgt.FormatRoundingFactor(AnalysisByDimParameters."Rounding Factor", false);    end;    /// <summary>    /// Configures visibility of matrix columns based on current set length.    /// Controls which matrix field columns are displayed based on the number of active columns in the current matrix view.    /// </summary>    procedure SetColumnVisibility()    begin        Field1Visible := MATRIX_CurrSetLength >= 1;        Field2Visible := MATRIX_CurrSetLength >= 2;        Field3Visible := MATRIX_CurrSetLength >= 3;        Field4Visible := MATRIX_CurrSetLength >= 4;        Field5Visible := MATRIX_CurrSetLength >= 5;        Field6Visible := MATRIX_CurrSetLength >= 6;        Field7Visible := MATRIX_CurrSetLength >= 7;        Field8Visible := MATRIX_CurrSetLength >= 8;        Field9Visible := MATRIX_CurrSetLength >= 9;        Field10Visible := MATRIX_CurrSetLength >= 10;        Field11Visible := MATRIX_CurrSetLength >= 11;        Field12Visible := MATRIX_CurrSetLength >= 12;        Field13Visible := MATRIX_CurrSetLength >= 13;        Field14Visible := MATRIX_CurrSetLength >= 14;        Field15Visible := MATRIX_CurrSetLength >= 15;        Field16Visible := MATRIX_CurrSetLength >= 16;        Field17Visible := MATRIX_CurrSetLength >= 17;        Field18Visible := MATRIX_CurrSetLength >= 18;        Field19Visible := MATRIX_CurrSetLength >= 19;        Field20Visible := MATRIX_CurrSetLength >= 20;        Field21Visible := MATRIX_CurrSetLength >= 21;        Field22Visible := MATRIX_CurrSetLength >= 22;        Field23Visible := MATRIX_CurrSetLength >= 23;        Field24Visible := MATRIX_CurrSetLength >= 24;        Field25Visible := MATRIX_CurrSetLength >= 25;        Field26Visible := MATRIX_CurrSetLength >= 26;        Field27Visible := MATRIX_CurrSetLength >= 27;        Field28Visible := MATRIX_CurrSetLength >= 28;        Field29Visible := MATRIX_CurrSetLength >= 29;        Field30Visible := MATRIX_CurrSetLength >= 30;        Field31Visible := MATRIX_CurrSetLength >= 31;        Field32Visible := MATRIX_CurrSetLength >= 32;    end;    local procedure FormatLine()    begin        Emphasize := Rec."Show in Bold";    end;    local procedure LoadDefault()    begin        FindPeriod('');        PeriodInitialized := true;        MATRIX_CurrSetLength := ArrayLen(MATRIX_ColumnCaptions);        GenerateColumnCaptions();        RoundingFactorFormatString := MatrixMgt.FormatRoundingFactor(AnalysisByDimParameters."Rounding Factor"::None, false);    end;    local procedure GenerateColumnCaptions()    var        DimCodeBuffer: Record "Dimension Code Buffer";        Found: Boolean;        Which: Text[30];    begin        MATRIX_CurrSetLength := 0;        Clear(MATRIX_ColumnCaptions);        if (AnalysisByDimParameters."Column Dim Option" = AnalysisByDimParameters."Column Dim Option"::Period) and           (AnalysisByDimParameters."Period Type" <> AnalysisByDimParameters."Period Type"::"Accounting Period") and           (AnalysisByDimParameters."Date Filter" = '')        then begin            Evaluate(DimCodeBuffer.Code, Format(WorkDate()));            Which := '=><';        end else            Which := '-';        Found := FindRec(AnalysisByDimParameters."Column Dim Option", DimCodeBuffer, Which);        MATRIX_PrimKeyFirstCol := DimCodeBuffer.GetPosition();        if Found then            repeat                MATRIX_CurrSetLength := MATRIX_CurrSetLength + 1;                MATRIX_ColumnCaptions[MATRIX_CurrSetLength] := DimCodeBuffer.Code;            until (MATRIX_CurrSetLength = MATRIX_NoOfMatrixColumns) or (NextRec(AnalysisByDimParameters."Column Dim Option", DimCodeBuffer, 1) <> 1);    end;    local procedure FormatStr(): Text    begin        exit(RoundingFactorFormatString);    end;    local procedure GetDimValueTotaling(DimValueFilter: Text; DimensionCode: Code[20]): Text    var        DimensionManagement: Codeunit DimensionManagement;    begin        DimensionManagement.ResolveDimValueFilter(DimValueFilter, DimensionCode);        exit(DimValueFilter);    end;    local procedure InitRecord(var DimCodeBuf: Record "Dimension Code Buffer"; DimOption: Enum "Analysis Dimension Option")    var        GLAccount: Record "G/L Account";    begin        case DimOption of            DimOption::"G/L Account":                begin                    if AnalysisByDimParameters."Account Filter" <> '' then                        GLAccount.SetFilter("No.", AnalysisByDimParameters."Account Filter");                    if GLAccount.FindSet() then                        repeat                            CopyGLAccToBuf(GLAccount, DimCodeBuf);                            DimCodeBuf.Insert();                        until GLAccount.Next() = 0;                end;        end;        if Rec.FindFirst() then;    end;    /// <summary>    /// Integration event raised after finding record in dimensional navigation.    /// Enables custom logic for record positioning and filtering in matrix navigation operations.    /// </summary>    /// <param name="DimOption">Dimension option being used for record navigation</param>    /// <param name="DimCodeBuf">Dimension code buffer record being processed</param>    /// <param name="Which">Navigation direction or criteria</param>    /// <param name="Found">Boolean indicating if record was found</param>    /// <param name="AnalysisbyDimParameters">Analysis parameters for filtering and configuration</param>    [IntegrationEvent(true, false)]    local procedure OnAfterFindRec(DimOption: Option "G/L Account",Period,"Business Unit","Dimension 1","Dimension 2",Fund,"Dimension 3","Dimension 4","Dimension 5","Dimension 6","Dimension 7","Dimension 8"; var DimCodeBuf: Record "Dimension Code Buffer"; Which: Text; var Found: Boolean; AnalysisbyDimParameters: Record "Analysis by Dim. Parameters")    begin    end;    /// <summary>    /// Integration event raised after navigating to next record in matrix view.    /// Enables custom navigation logic and step calculation for matrix record positioning.    /// </summary>    /// <param name="DimOption">Dimension option being used for navigation</param>    /// <param name="DimCodeBuf">Dimension code buffer record being navigated</param>    /// <param name="Steps">Number of steps requested in navigation</param>    /// <param name="ResultSteps">Actual steps taken in navigation</param>    /// <param name="AnalysisbyDimParameters">Analysis parameters for filtering and configuration</param>    [IntegrationEvent(true, false)]    local procedure OnAfterNextRec(DimOption: Option "G/L Account",Period,"Business Unit","Dimension 1","Dimension 2",Fund,"Dimension 3","Dimension 4","Dimension 5","Dimension 6","Dimension 7","Dimension 8"; var DimCodeBuf: Record "Dimension Code Buffer"; Steps: Integer; var ResultSteps: Integer; AnalysisbyDimParameters: Record "Analysis by Dim. Parameters")    begin    end;    /// <summary>    /// Integration event raised after setting common filters on G/L Account records.    /// Enables custom filtering logic for G/L account selection in dimensional analysis.    /// </summary>    /// <param name="GLAccount">G/L Account record being filtered</param>    /// <param name="AnalysisByDimParameters">Analysis parameters containing filter criteria</param>    [IntegrationEvent(true, false)]    local procedure OnAfterSetCommonFilters(var GLAccount: Record "G/L Account"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters")    begin    end;    /// <summary>    /// Integration event raised after calculating actual amounts for G/L accounts.    /// Enables custom amount calculation logic for actual balance analysis.    /// </summary>    /// <param name="GLAccount">G/L Account record for amount calculation</param>    /// <param name="AnalysisByDimParameters">Analysis parameters affecting calculation</param>    /// <param name="Amount">Calculated amount available for modification</param>    [IntegrationEvent(false, false)]    local procedure OnAfterCalcActualAmount(var GLAccount: Record "G/L Account"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var Amount: Decimal)    begin    end;    /// <summary>    /// Integration event for customizing budget amount calculation in GL balance by dimension matrix.    /// </summary>    /// <param name="GLAccount">G/L account for budget calculation</param>    /// <param name="AnalysisByDimParameters">Analysis parameters for calculation context</param>    /// <param name="Amount">Budget amount to be customized</param>    [IntegrationEvent(false, false)]    local procedure OnAfterCalcBudgetAmount(var GLAccount: Record "G/L Account"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var Amount: Decimal)    begin    end;    /// <summary>    /// Integration event for custom actual amount calculation logic in GL balance by dimension matrix.    /// </summary>    /// <param name="GLAcc">G/L account for actual amount calculation</param>    /// <param name="AnalysisByDimParameters">Analysis parameters for calculation context</param>    /// <param name="Amount">Actual amount to be customized</param>    /// <param name="IsHandled">Set to true to skip standard calculation</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcActualAmounts(var GLAcc: Record "G/L Account"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var Amount: Decimal; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event for custom drill-down logic in GL balance by dimension matrix.    /// </summary>    /// <param name="SetColFilter">Whether column filter should be set</param>    /// <param name="GLAcc">G/L account for drill-down context</param>    /// <param name="AnalysisByDimParameters">Analysis parameters for drill-down</param>    /// <param name="IsHandled">Set to true to skip standard drill-down</param>    /// <param name="GLEntry">G/L entry for drill-down target</param>    /// <param name="GLBudgetEntry">G/L budget entry for drill-down target</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeDrillDown(SetColFilter: Boolean; var GLAcc: Record "G/L Account"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var IsHandled: Boolean; var GLEntry: Record "G/L Entry"; var GLBudgetEntry: Record "G/L Budget Entry")    begin    end;    /// <summary>    /// Integration event for custom dimension code to option conversion logic.    /// </summary>    /// <param name="DimCode">Dimension code to convert</param>    /// <param name="Result">Resulting option value</param>    /// <param name="IsHandled">Set to true to skip standard conversion</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeDimCodeToOption(DimCode: Text[30]; var Result: Integer; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event for custom record finding logic in GL balance by dimension matrix.    /// </summary>    /// <param name="DimOption">Dimension option for record finding context</param>    /// <param name="DimensionValue">Dimension value being found</param>    /// <param name="GLAccount">G/L account for finding context</param>    /// <param name="DimensionCodeBuffer">Dimension code buffer for finding</param>    /// <param name="Which">Which direction to find (e.g., next, previous)</param>    /// <param name="Found">Whether record was found</param>    /// <param name="IsHandled">Set to true to skip standard finding</param>    [IntegrationEvent(true, false)]    local procedure OnBeforeFindRec(DimOption: Enum "Analysis Dimension Option"; var DimensionValue: Record "Dimension Value"; var GLAccount: Record "G/L Account"; var DimensionCodeBuffer: Record "Dimension Code Buffer"; Which: Text[1024]; var Found: Boolean; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event for custom record navigation logic in GL balance by dimension matrix.    /// </summary>    /// <param name="DimOption">Dimension option for navigation context</param>    /// <param name="DimensionValue">Dimension value being navigated</param>    /// <param name="GLAccount">G/L account for navigation context</param>    [IntegrationEvent(true, false)]    local procedure OnBeforeNextRec(DimOption: Enum "Analysis Dimension Option"; var DimensionValue: Record "Dimension Value"; var GLAccount: Record "G/L Account")    begin    end;    /// <summary>    /// Integration event for custom filter logic after setting G/L account filters in amount calculation.    /// </summary>    /// <param name="GLAcc">G/L account with applied filters</param>    /// <param name="SetColFilter">Whether column filter should be applied</param>    [IntegrationEvent(true, false)]    local procedure OnCalcAmountOnAfterGLAccSetFilters(var GLAcc: Record "G/L Account"; SetColFilter: Boolean)    begin    end;    /// <summary>    /// Integration event raised before running the General Ledger Entries page during drill-down operations.    /// Enables customization of drill-down behavior for general ledger entries.    /// </summary>    /// <param name="GLAcc">G/L Account record for the drill-down</param>    /// <param name="GLEntry">G/L Entry record for drill-down filtering</param>    [IntegrationEvent(true, false)]    local procedure OnDrillDownOnBeforeRunGeneralLedgerEntriesPage(var GLAcc: Record "G/L Account"; var GLEntry: Record "G/L Entry")    begin    end;    /// <summary>    /// Integration event raised before running the G/L Budget Entries page during drill-down operations.    /// Enables customization of drill-down behavior for budget entries.    /// </summary>    /// <param name="GLAcc">G/L Account record for the drill-down</param>    /// <param name="GLBudgetEntry">G/L Budget Entry record for drill-down filtering</param>    [IntegrationEvent(true, false)]    local procedure OnDrillDownOnBeforeRunGLBudgetEntriesPage(var GLAcc: Record "G/L Account"; var GLBudgetEntry: Record "G/L Budget Entry")    begin    end;    /// <summary>    /// Integration event raised for custom dimension option handling in lookup code operations.    /// Enables extension of dimension lookup functionality beyond standard dimensions.    /// </summary>    /// <param name="DimOption">Dimension option being processed</param>    /// <param name="DimCode">Dimension code for lookup</param>    /// <param name="Code">Code value for dimension lookup</param>    [IntegrationEvent(false, false)]    local procedure OnLookupCodeOnCaseElse(var DimOption: Option "G/L Account",Period,"Business Unit","Dimension 1","Dimension 2",Fund,"Dimension 3","Dimension 4","Dimension 5","Dimension 6","Dimension 7","Dimension 8"; DimCode: Text[30]; Code: Text[30])    begin    end;    /// <summary>    /// Integration event raised for custom dimension filter setup beyond standard dimensions.    /// Enables extension of dimension filtering functionality in GL balance by dimension analysis.    /// </summary>    /// <param name="DimOption">Dimension option for filter setup</param>    /// <param name="TheGLAcc">G/L Account record for filtering</param>    /// <param name="DimCodeBuf">Dimension code buffer for filter configuration</param>    [IntegrationEvent(true, false)]    local procedure OnSetDimFiltersOnCaseElse(DimOption: Option "G/L Account",Period,"Business Unit","Dimension 1","Dimension 2",Fund,"Dimension 3","Dimension 4","Dimension 5","Dimension 6","Dimension 7","Dimension 8"; var TheGLAcc: Record "G/L Account"; var DimCodeBuf: Record "Dimension Code Buffer")    begin    end;    /// <summary>    /// Integration event raised after calculating and assigning amount values in GL balance by dimension analysis.    /// Enables custom amount calculation adjustments and result modification.    /// </summary>    /// <param name="AnalysisByDimParameters">Analysis parameters for calculation context</param>    /// <param name="GLAccount">G/L Account record for the calculation</param>    /// <param name="Result">Calculated result amount that can be modified</param>    [IntegrationEvent(true, false)]    local procedure OnCalcAmountOnAfterAssignAmount(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var GLAccount: record "G/L Account"; var Result: Decimal)    begin    end;    /// <summary>    /// Integration event raised after copying dimension value data to dimension code buffer.    /// Enables custom handling of dimension value data during buffer operations.    /// </summary>    /// <param name="DimVal">Dimension value record being copied</param>    /// <param name="DimCodeBuf">Dimension code buffer receiving the data</param>    [IntegrationEvent(false, false)]    local procedure OnAfterCopyDimValueToBuf(var DimVal: Record "Dimension Value"; var DimCodeBuf: Record "Dimension Code Buffer")    begin    end;    /// <summary>    /// Integration event raised after copying G/L Account data to dimension code buffer.    /// Enables custom handling of G/L Account data during buffer operations in dimensional analysis.    /// </summary>    /// <param name="GLAcc">G/L Account record being copied</param>    /// <param name="DimCodeBuf">Dimension code buffer receiving the account data</param>    [IntegrationEvent(false, false)]    local procedure OnAfterCopyGLAccToBuf(GLAcc: Record "G/L Account"; var DimCodeBuf: Record "Dimension Code Buffer")    begin    end;}