Codeunit 762 Acc. Sched. Chart Management

Base Application, Microsoft.Finance.FinancialReports

src/Layers/W1/BaseApp/Finance/FinancialReports/AccSchedChartManagement.Codeunit.al618 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.FinancialReports;using Microsoft.CashFlow.Account;using Microsoft.CostAccounting.Account;using Microsoft.Finance.Analysis;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Setup;using System.Visualization;/// <summary>/// Provides chart management functionality for account schedule visualization and analysis./// Manages chart data preparation, drill-down operations, and business chart buffer integration./// </summary>/// <remarks>/// Core functionality: Chart data retrieval, drill-down navigation, period-based analysis./// Integration: Links with Business Chart Buffer, Account Schedule system, and Analysis Views./// Extensibility: Multiple integration events for custom chart types and drill-down behavior./// </remarks>codeunit 762 "Acc. Sched. Chart Management"{    trigger OnRun()    begin    end;    var        GeneralLedgerSetup: Record "General Ledger Setup";        AccSchedManagement: Codeunit AccSchedManagement;        GLSetupLoaded: Boolean;#pragma warning disable AA0470        DuplicateRowDescriptionsMsg: Label 'Row Definition %1 has duplicate Description values: %2.';        DuplicateColumnHeaderMsg: Label 'Column Definition %1 has duplicate Column Header values: %2.';        ColumnFormulaMsg: Label 'Column formula: %1.';#pragma warning restore AA0470        DefaultAccSchedTok: Label 'DEFAULT', Comment = 'The default name of the chart setup.';        DefinitionsModifiedMsg: Label 'The row definition or column definition has been modified since the chart setup was created. Please reset your chart setup.';    /// <summary>    /// Retrieves and positions the account schedules chart setup record based on chart name and navigation direction.    /// Handles navigation through multiple chart setups and tracks last viewed setup.    /// </summary>    /// <param name="AccountSchedulesChartSetup">Chart setup record to populate and position</param>    /// <param name="ChartName">Name of the chart setup to retrieve</param>    /// <param name="Move">Navigation direction: positive for next, negative for previous, 0 for no movement</param>    procedure GetSetupRecordset(var AccountSchedulesChartSetup: Record "Account Schedules Chart Setup"; ChartName: Text[60]; Move: Integer)    begin        FindRecordset(AccountSchedulesChartSetup, ChartName);        if (AccountSchedulesChartSetup.Count <= 1) or (Move = 0) then            exit;        if AccountSchedulesChartSetup.Next(Move) = 0 then            if Move < 0 then                AccountSchedulesChartSetup.FindLast()            else                AccountSchedulesChartSetup.FindFirst();        AccountSchedulesChartSetup.SetLastViewed();    end;    local procedure FindRecordset(var AccountSchedulesChartSetup: Record "Account Schedules Chart Setup"; ChartName: Text[60])    var        Found: Boolean;    begin        AccountSchedulesChartSetup.SetFilter("User ID", '%1|%2', UserId, '');        if AccountSchedulesChartSetup.Get(UserId, ChartName) or AccountSchedulesChartSetup.Get('', ChartName) then begin            AccountSchedulesChartSetup.SetLastViewed();            exit;        end;        AccountSchedulesChartSetup.SetRange("Last Viewed", true);        Found := AccountSchedulesChartSetup.FindLast();        AccountSchedulesChartSetup.SetRange("Last Viewed");        if Found then            exit;        if AccountSchedulesChartSetup.FindFirst() then begin            AccountSchedulesChartSetup.SetLastViewed();            exit;        end;        AccountSchedulesChartSetup.Init();        AccountSchedulesChartSetup."User ID" := CopyStr(UserId(), 1, MaxStrLen(AccountSchedulesChartSetup."User ID"));        AccountSchedulesChartSetup.Name := DefaultAccSchedTok;        AccountSchedulesChartSetup."Base X-Axis on" := AccountSchedulesChartSetup."Base X-Axis on"::Period;        AccountSchedulesChartSetup."Start Date" := WorkDate();        AccountSchedulesChartSetup."Period Length" := AccountSchedulesChartSetup."Period Length"::Day;        AccountSchedulesChartSetup."Last Viewed" := true;        AccountSchedulesChartSetup.Insert();    end;    /// <summary>    /// Performs drill-down operation from chart data point to underlying financial data and analysis.    /// Opens appropriate pages based on account schedule line totaling type and column layout configuration.    /// </summary>    /// <param name="BusChartBuf">Business chart buffer containing drill-down context and data point information</param>    /// <param name="AccountSchedulesChartSetup">Chart setup record defining the chart configuration and parameters</param>    procedure DrillDown(var BusChartBuf: Record "Business Chart Buffer"; AccountSchedulesChartSetup: Record "Account Schedules Chart Setup")    var        AccScheduleLine: Record "Acc. Schedule Line";        ColumnLayout: Record "Column Layout";        AccScheduleOverview: Page "Acc. Schedule Overview";    begin        GetAccScheduleAndColumnLayoutForDrillDown(AccScheduleLine, ColumnLayout, BusChartBuf, AccountSchedulesChartSetup);        if ColumnLayout."Column Type" = ColumnLayout."Column Type"::Formula then begin            Message(ColumnFormulaMsg, ColumnLayout.Formula);            exit;        end;        if AccScheduleLine."Totaling Type" in [AccScheduleLine."Totaling Type"::Formula,                                               AccScheduleLine."Totaling Type"::"Set Base For Percent"]        then begin            AccScheduleOverview.SetAccSchedName(AccScheduleLine."Schedule Name");            AccScheduleOverview.SetTableView(AccScheduleLine);            AccScheduleOverview.SetRecord(AccScheduleLine);            AccScheduleOverview.SetViewOnlyMode(true);            AccScheduleOverview.SetPeriodType(BusChartBuf."Period Length");            AccScheduleOverview.Run();            exit;        end;        if AccScheduleLine.Totaling = '' then            exit;        case AccScheduleLine."Totaling Type" of            AccScheduleLine."Totaling Type"::"Posting Accounts",            AccScheduleLine."Totaling Type"::"Total Accounts":                DrillDownOnGLAccount(AccScheduleLine, ColumnLayout);            AccScheduleLine."Totaling Type"::"Cost Type",            AccScheduleLine."Totaling Type"::"Cost Type Total":                DrillDownOnCostType(AccScheduleLine, ColumnLayout);            AccScheduleLine."Totaling Type"::"Cash Flow Entry Accounts",            AccScheduleLine."Totaling Type"::"Cash Flow Total Accounts":                DrillDownOnCFAccount(AccScheduleLine, ColumnLayout);            else                OnDrillDownTotalingTypeElseCase(AccScheduleLine, ColumnLayout, BusChartBuf);        end;    end;    /// <summary>    /// Updates chart data with account schedule calculations for the specified period and chart setup.    /// Populates business chart buffer with financial data based on account schedule and column layout definitions.    /// </summary>    /// <param name="BusChartBuf">Business chart buffer to populate with calculated financial data</param>    /// <param name="Period">Period navigation option: Next, Previous, or unchanged</param>    /// <param name="AccountSchedulesChartSetup">Chart setup record defining data source and calculation parameters</param>    procedure UpdateData(var BusChartBuf: Record "Business Chart Buffer"; Period: Option " ",Next,Previous; AccountSchedulesChartSetup: Record "Account Schedules Chart Setup")    var        BusChartMapColumn: Record "Business Chart Map";        AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line";        AccSchedChartSetupLine2: Record "Acc. Sched. Chart Setup Line";        AccScheduleLine: Record "Acc. Schedule Line";        ColumnLayout: Record "Column Layout";        FromDate: Date;        ToDate: Date;        NoOfPeriods: Integer;        PeriodCounter: Integer;        XCounter: Integer;    begin        CheckDuplicateAccScheduleLineDescription(AccountSchedulesChartSetup."Account Schedule Name");        CheckDuplicateColumnLayoutColumnHeader(AccountSchedulesChartSetup."Column Layout Name");        BusChartBuf."Period Length" := AccountSchedulesChartSetup."Period Length";        case AccountSchedulesChartSetup."Base X-Axis on" of            AccountSchedulesChartSetup."Base X-Axis on"::Period:                if Period = Period::" " then begin                    FromDate := 0D;                    ToDate := 0D;                end else                    if BusChartBuf.FindMidColumn(BusChartMapColumn) then                        BusChartBuf.GetPeriodFromMapColumn(BusChartMapColumn.Index, FromDate, ToDate);            AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Line",            AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Column":                if (BusChartBuf."Period Filter Start Date" = 0D) and (AccountSchedulesChartSetup."Start Date" <> 0D) then                    BusChartBuf.InitializePeriodFilter(AccountSchedulesChartSetup."Start Date", AccountSchedulesChartSetup."End Date")                else                    BusChartBuf.RecalculatePeriodFilter(BusChartBuf."Period Filter Start Date", BusChartBuf."Period Filter End Date", Period);        end;        BusChartBuf.Initialize();        case AccountSchedulesChartSetup."Base X-Axis on" of            AccountSchedulesChartSetup."Base X-Axis on"::Period:                begin                    BusChartBuf.SetPeriodXAxis();                    NoOfPeriods := AccountSchedulesChartSetup."No. of Periods";                    CalcAndInsertPeriodAxis(BusChartBuf, AccountSchedulesChartSetup, Period, NoOfPeriods, FromDate, ToDate);                end;            AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Line":                BusChartBuf.SetXAxis(AccScheduleLine.FieldCaption(Description), BusChartBuf."Data Type"::String);            AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Column":                BusChartBuf.SetXAxis(ColumnLayout.FieldCaption("Column Header"), BusChartBuf."Data Type"::String);        end;        AddMeasures(BusChartBuf, AccountSchedulesChartSetup);        case AccountSchedulesChartSetup."Base X-Axis on" of            AccountSchedulesChartSetup."Base X-Axis on"::Period:                begin                    BusChartBuf.FindFirstColumn(BusChartMapColumn);                    for PeriodCounter := 1 to NoOfPeriods do begin                        AccountSchedulesChartSetup.SetLinkToMeasureLines(AccSchedChartSetupLine);                        AccSchedChartSetupLine.SetFilter("Chart Type", '<>%1', AccSchedChartSetupLine."Chart Type"::" ");                        if AccSchedChartSetupLine.FindSet() then                            repeat                                BusChartBuf.GetPeriodFromMapColumn(PeriodCounter - 1, FromDate, ToDate);                                AccScheduleLine.SetRange("Date Filter", FromDate, ToDate);                                if (not AccScheduleLine.Get(                                      AccSchedChartSetupLine."Account Schedule Name", AccSchedChartSetupLine."Account Schedule Line No.")) or                                   (not ColumnLayout.Get(                                      AccSchedChartSetupLine."Column Layout Name", AccSchedChartSetupLine."Column Layout Line No."))                                then                                    Error(DefinitionsModifiedMsg);                                BusChartBuf.SetValue(                                  AccSchedChartSetupLine."Measure Name", PeriodCounter - 1,                                  RoundAmount(AccSchedManagement.CalcCell(AccScheduleLine, ColumnLayout, false)));                            until AccSchedChartSetupLine.Next() = 0;                    end;                end;            AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Line":                begin                    AccountSchedulesChartSetup.SetLinkToDimensionLines(AccSchedChartSetupLine);                    AccSchedChartSetupLine.SetFilter("Chart Type", '<>%1', AccSchedChartSetupLine."Chart Type"::" ");                    AccountSchedulesChartSetup.SetLinkToMeasureLines(AccSchedChartSetupLine2);                    AccSchedChartSetupLine2.SetFilter("Chart Type", '<>%1', AccSchedChartSetupLine2."Chart Type"::" ");                    XCounter := 0;                    AccScheduleLine.SetRange("Date Filter", BusChartBuf."Period Filter Start Date", BusChartBuf."Period Filter End Date");                    if AccSchedChartSetupLine.FindSet() then                        repeat                            BusChartBuf.AddColumn(AccSchedChartSetupLine."Measure Name");                            if not AccScheduleLine.Get(                                 AccSchedChartSetupLine."Account Schedule Name", AccSchedChartSetupLine."Account Schedule Line No.")                            then                                Error(DefinitionsModifiedMsg);                            if AccSchedChartSetupLine2.FindSet() then                                repeat                                    if not ColumnLayout.Get(                                         AccSchedChartSetupLine2."Column Layout Name", AccSchedChartSetupLine2."Column Layout Line No.")                                    then                                        Error(DefinitionsModifiedMsg);                                    BusChartBuf.SetValue(                                      AccSchedChartSetupLine2."Measure Name", XCounter,                                      RoundAmount(AccSchedManagement.CalcCell(AccScheduleLine, ColumnLayout, false)));                                until AccSchedChartSetupLine2.Next() = 0;                            XCounter += 1;                        until AccSchedChartSetupLine.Next() = 0;                end;            AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Column":                begin                    AccountSchedulesChartSetup.SetLinkToDimensionLines(AccSchedChartSetupLine);                    AccSchedChartSetupLine.SetFilter("Chart Type", '<>%1', AccSchedChartSetupLine."Chart Type"::" ");                    AccountSchedulesChartSetup.SetLinkToMeasureLines(AccSchedChartSetupLine2);                    AccSchedChartSetupLine2.SetFilter("Chart Type", '<>%1', AccSchedChartSetupLine2."Chart Type"::" ");                    AccScheduleLine.SetRange("Date Filter", BusChartBuf."Period Filter Start Date", BusChartBuf."Period Filter End Date");                    XCounter := 0;                    if AccSchedChartSetupLine.FindSet() then                        repeat                            BusChartBuf.AddColumn(AccSchedChartSetupLine."Measure Name");                            if not ColumnLayout.Get(AccSchedChartSetupLine."Column Layout Name", AccSchedChartSetupLine."Column Layout Line No.") then                                Error(DefinitionsModifiedMsg);                            if AccSchedChartSetupLine2.FindSet() then                                repeat                                    if not AccScheduleLine.Get(                                         AccSchedChartSetupLine2."Account Schedule Name", AccSchedChartSetupLine2."Account Schedule Line No.")                                    then                                        Error(DefinitionsModifiedMsg);                                    BusChartBuf.SetValue(                                      AccSchedChartSetupLine2."Measure Name", XCounter,                                      RoundAmount(AccSchedManagement.CalcCell(AccScheduleLine, ColumnLayout, false)));                                until AccSchedChartSetupLine2.Next() = 0;                            XCounter += 1;                        until AccSchedChartSetupLine.Next() = 0;                end;        end;    end;    local procedure AddMeasures(var BusChartBuf: Record "Business Chart Buffer"; AccountSchedulesChartSetup: Record "Account Schedules Chart Setup")    var        AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line";        BusChartType: Enum "Business Chart Type";    begin        AccountSchedulesChartSetup.SetLinkToMeasureLines(AccSchedChartSetupLine);        AccSchedChartSetupLine.SetFilter("Chart Type", '<>%1', AccSchedChartSetupLine."Chart Type"::" ");        if AccSchedChartSetupLine.FindSet() then            repeat                case AccSchedChartSetupLine."Chart Type" of                    AccSchedChartSetupLine."Chart Type"::Line:                        BusChartType := BusChartBuf."Chart Type"::Line;                    AccSchedChartSetupLine."Chart Type"::StepLine:                        BusChartType := BusChartBuf."Chart Type"::StepLine;                    AccSchedChartSetupLine."Chart Type"::Column:                        BusChartType := BusChartBuf."Chart Type"::Column;                    AccSchedChartSetupLine."Chart Type"::StackedColumn:                        BusChartType := BusChartBuf."Chart Type"::StackedColumn;                end;                BusChartBuf.AddDecimalMeasure(AccSchedChartSetupLine."Measure Name", AccSchedChartSetupLine."Measure Value", BusChartType);            until AccSchedChartSetupLine.Next() = 0;    end;    local procedure CalcAndInsertPeriodAxis(var BusChartBuf: Record "Business Chart Buffer"; AccountSchedulesChartSetup: Record "Account Schedules Chart Setup"; Period: Option ,Next,Previous; MaxPeriodNo: Integer; StartDate: Date; EndDate: Date)    var        PeriodDate: Date;    begin        if (StartDate = 0D) and (AccountSchedulesChartSetup."Start Date" <> 0D) then            PeriodDate := CalcDate(StrSubstNo('<-1%1>', BusChartBuf.GetPeriodLength()), AccountSchedulesChartSetup."Start Date")        else begin            BusChartBuf.RecalculatePeriodFilter(StartDate, EndDate, Period);            PeriodDate := CalcDate(StrSubstNo('<-%1%2>', MaxPeriodNo - (MaxPeriodNo div 2), BusChartBuf.GetPeriodLength()), EndDate);        end;        BusChartBuf.AddPeriods(GetCorrectedDate(BusChartBuf, PeriodDate, 1), GetCorrectedDate(BusChartBuf, PeriodDate, MaxPeriodNo));    end;    /// <summary>    /// Calculates corrected date based on period length and period number for chart axis positioning.    /// Adjusts dates for period-based chart display and handles different period length types.    /// </summary>    /// <param name="BusChartBuf">Business chart buffer containing period length configuration</param>    /// <param name="InputDate">Starting date for calculation</param>    /// <param name="PeriodNo">Period number offset for date calculation</param>    /// <returns>Calculated output date adjusted for chart period positioning</returns>    procedure GetCorrectedDate(BusChartBuf: Record "Business Chart Buffer"; InputDate: Date; PeriodNo: Integer) OutputDate: Date    begin        OutputDate := CalcDate(StrSubstNo('<%1%2>', PeriodNo, BusChartBuf.GetPeriodLength()), InputDate);        if BusChartBuf."Period Length" <> BusChartBuf."Period Length"::Day then            OutputDate := CalcDate(StrSubstNo('<C%1>', BusChartBuf.GetPeriodLength()), OutputDate);    end;    local procedure GetAccScheduleAndColumnLayoutForDrillDown(var AccScheduleLine: Record "Acc. Schedule Line"; var ColumnLayout: Record "Column Layout"; var BusChartBuf: Record "Business Chart Buffer"; AccountSchedulesChartSetup: Record "Account Schedules Chart Setup")    var        XName: Variant;        FromDate: Date;        ToDate: Date;        MeasureValueString: Text;        AccScheduleLineLineNo: Integer;        ColumnLayoutLineNo: Integer;    begin        case AccountSchedulesChartSetup."Base X-Axis on" of            AccountSchedulesChartSetup."Base X-Axis on"::Period:                begin                    BusChartBuf."Period Length" := AccountSchedulesChartSetup."Period Length";                    ToDate := BusChartBuf.GetXValueAsDate(BusChartBuf."Drill-Down X Index");                    FromDate := BusChartBuf.CalcFromDate(ToDate);                    MeasureValueString := BusChartBuf.GetMeasureValueString(BusChartBuf."Drill-Down Measure Index");                    Evaluate(AccScheduleLineLineNo, CopyStr(MeasureValueString, 1, StrPos(MeasureValueString, ' ') - 1));                    AccScheduleLine.Get(AccountSchedulesChartSetup."Account Schedule Name", AccScheduleLineLineNo);                    Evaluate(ColumnLayoutLineNo, CopyStr(MeasureValueString, StrPos(MeasureValueString, ' ') + 1));                    ColumnLayout.Get(AccountSchedulesChartSetup."Column Layout Name", ColumnLayoutLineNo);                end;            AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Line":                begin                    FromDate := BusChartBuf."Period Filter Start Date";                    ToDate := BusChartBuf."Period Filter End Date";                    AccountSchedulesChartSetup.FilterAccSchedLines(AccScheduleLine);                    BusChartBuf.GetXValue(BusChartBuf."Drill-Down X Index", XName);                    AccScheduleLine.SetRange(Description, Format(XName));                    AccScheduleLine.FindFirst();                    MeasureValueString := BusChartBuf.GetMeasureValueString(BusChartBuf."Drill-Down Measure Index");                    Evaluate(ColumnLayoutLineNo, MeasureValueString);                    ColumnLayout.Get(AccountSchedulesChartSetup."Column Layout Name", ColumnLayoutLineNo);                end;            AccountSchedulesChartSetup."Base X-Axis on"::"Acc. Sched. Column":                begin                    FromDate := BusChartBuf."Period Filter Start Date";                    ToDate := BusChartBuf."Period Filter End Date";                    AccountSchedulesChartSetup.FilterColumnLayout(ColumnLayout);                    BusChartBuf.GetXValue(BusChartBuf."Drill-Down X Index", XName);                    ColumnLayout.SetRange("Column Header", Format(XName));                    ColumnLayout.FindFirst();                    MeasureValueString := BusChartBuf.GetMeasureValueString(BusChartBuf."Drill-Down Measure Index");                    Evaluate(AccScheduleLineLineNo, MeasureValueString);                    AccScheduleLine.Get(AccountSchedulesChartSetup."Account Schedule Name", AccScheduleLineLineNo);                end;        end;        AccScheduleLine.SetRange("Date Filter", FromDate, ToDate);        AccSchedManagement.SetStartDateEndDate(FromDate, ToDate);    end;    /// <summary>    /// Validates account schedule line descriptions for duplicates within the specified account schedule.    /// Raises error if duplicate descriptions are found to prevent chart display ambiguity.    /// </summary>    /// <param name="AccScheduleName">Account schedule name to check for duplicate line descriptions</param>    procedure CheckDuplicateAccScheduleLineDescription(AccScheduleName: Code[10])    var        AccScheduleLineQuery: Query "Acc. Sched. Line Desc. Count";    begin        AccScheduleLineQuery.SetRange(Schedule_Name, AccScheduleName);        AccScheduleLineQuery.Open();        if AccScheduleLineQuery.Read() then            Error(DuplicateRowDescriptionsMsg, AccScheduleName, AccScheduleLineQuery.Description);    end;    /// <summary>    /// Validates column layout headers for duplicates within the specified column layout definition.    /// Raises error if duplicate column headers are found to prevent chart display ambiguity.    /// </summary>    /// <param name="ColumnLayoutName">Column layout name to check for duplicate column headers</param>    procedure CheckDuplicateColumnLayoutColumnHeader(ColumnLayoutName: Code[10])    var        ColumnLayoutQuery: Query "Colm. Layt. Colm. Header Count";    begin        ColumnLayoutQuery.SetRange(Column_Layout_Name, ColumnLayoutName);        ColumnLayoutQuery.SetFilter(Column_Header, '<>''''');        ColumnLayoutQuery.Open();        if ColumnLayoutQuery.Read() then            Error(DuplicateColumnHeaderMsg, ColumnLayoutName, ColumnLayoutQuery.Column_Header);    end;    local procedure DrillDownOnCFAccount(var AccScheduleLine: Record "Acc. Schedule Line"; var ColumnLayout: Record "Column Layout")    var        CFAccount: Record "Cash Flow Account";        AccSchedName: Record "Acc. Schedule Name";        GLAccAnalysisView: Record "G/L Account (Analysis View)";        ChartOfAccsAnalysisView: Page "Chart of Accs. (Analysis View)";    begin        AccSchedManagement.SetCFAccRowFilter(CFAccount, AccScheduleLine);        AccSchedManagement.SetCFAccColumnFilter(CFAccount, AccScheduleLine, ColumnLayout);        AccSchedName.Get(AccScheduleLine."Schedule Name");        if AccSchedName."Analysis View Name" = '' then begin            CFAccount.FilterGroup(2);            CFAccount.SetFilter(              "Global Dimension 1 Filter", AccSchedManagement.GetDimTotalingFilter(1, AccScheduleLine."Dimension 1 Totaling"));            CFAccount.SetFilter(              "Global Dimension 2 Filter", AccSchedManagement.GetDimTotalingFilter(2, AccScheduleLine."Dimension 2 Totaling"));            CFAccount.FilterGroup(8);            CFAccount.SetFilter(              "Global Dimension 1 Filter", AccSchedManagement.GetDimTotalingFilter(1, ColumnLayout."Dimension 1 Totaling"));            CFAccount.SetFilter(              "Global Dimension 2 Filter", AccSchedManagement.GetDimTotalingFilter(2, ColumnLayout."Dimension 2 Totaling"));            CFAccount.FilterGroup(0);            PAGE.Run(PAGE::"Chart of Cash Flow Accounts", CFAccount)        end else begin            CFAccount.CopyFilter("Date Filter", GLAccAnalysisView."Date Filter");            CFAccount.CopyFilter("Cash Flow Forecast Filter", GLAccAnalysisView."Cash Flow Forecast Filter");            GLAccAnalysisView.SetRange("Analysis View Filter", AccSchedName."Analysis View Name");            GLAccAnalysisView.FilterGroup(2);            GLAccAnalysisView.SetDimFilters(              AccSchedManagement.GetDimTotalingFilter(1, AccScheduleLine."Dimension 1 Totaling"),              AccSchedManagement.GetDimTotalingFilter(2, AccScheduleLine."Dimension 2 Totaling"),              AccSchedManagement.GetDimTotalingFilter(3, AccScheduleLine."Dimension 3 Totaling"),              AccSchedManagement.GetDimTotalingFilter(4, AccScheduleLine."Dimension 4 Totaling"));            GLAccAnalysisView.FilterGroup(8);            GLAccAnalysisView.SetDimFilters(              AccSchedManagement.GetDimTotalingFilter(1, ColumnLayout."Dimension 1 Totaling"),              AccSchedManagement.GetDimTotalingFilter(2, ColumnLayout."Dimension 2 Totaling"),              AccSchedManagement.GetDimTotalingFilter(3, ColumnLayout."Dimension 3 Totaling"),              AccSchedManagement.GetDimTotalingFilter(4, ColumnLayout."Dimension 4 Totaling"));            GLAccAnalysisView.FilterGroup(0);            Clear(ChartOfAccsAnalysisView);            ChartOfAccsAnalysisView.InsertTempCFAccountAnalysisVie(CFAccount);            ChartOfAccsAnalysisView.SetTableView(GLAccAnalysisView);            ChartOfAccsAnalysisView.Run();        end;    end;    local procedure DrillDownOnCostType(var AccScheduleLine: Record "Acc. Schedule Line"; var ColumnLayout: Record "Column Layout")    var        CostType: Record "Cost Type";    begin        AccSchedManagement.SetCostTypeRowFilters(CostType, AccScheduleLine, ColumnLayout);        AccSchedManagement.SetCostTypeColumnFilters(CostType, AccScheduleLine, ColumnLayout);        PAGE.Run(PAGE::"Chart of Cost Types", CostType);    end;    local procedure DrillDownOnGLAccount(var AccScheduleLine: Record "Acc. Schedule Line"; var ColumnLayout: Record "Column Layout")    var        GLAcc: Record "G/L Account";        GLAccAnalysisView: Record "G/L Account (Analysis View)";        AccSchedName: Record "Acc. Schedule Name";        ChartOfAccsAnalysisView: Page "Chart of Accs. (Analysis View)";        Dimension1Totaling: Code[1024];        Dimension2Totaling: Code[1024];    begin        AccSchedManagement.SetGLAccRowFilters(GLAcc, AccScheduleLine);        AccSchedManagement.SetGLAccColumnFilters(GLAcc, AccScheduleLine, ColumnLayout);        AccSchedName.Get(AccScheduleLine."Schedule Name");        if AccSchedName."Analysis View Name" = '' then begin            GLAcc.FilterGroup(2);            Dimension1Totaling := AccSchedManagement.GetDimTotalingFilter(1, ColumnLayout."Dimension 1 Totaling");            Dimension2Totaling := AccSchedManagement.GetDimTotalingFilter(2, ColumnLayout."Dimension 2 Totaling");            GLAcc.SetFilter("Global Dimension 1 Filter", Dimension1Totaling);            GLAcc.SetFilter("Global Dimension 2 Filter", Dimension2Totaling);            GLAcc.FilterGroup(8);            GLAcc.SetFilter("Business Unit Filter", ColumnLayout."Business Unit Totaling");            if Dimension1Totaling <> '' then                GLAcc.SetFilter("Global Dimension 1 Filter", Dimension1Totaling);            if Dimension2Totaling <> '' then                GLAcc.SetFilter("Global Dimension 2 Filter", Dimension2Totaling);            GLAcc.FilterGroup(0);            OnDrillDownOnGLAccountOnBeforeRunChartOfAccountsGL(GLAcc, ColumnLayout);            PAGE.Run(PAGE::"Chart of Accounts (G/L)", GLAcc)        end else begin            GLAcc.CopyFilter("Date Filter", GLAccAnalysisView."Date Filter");            GLAcc.CopyFilter("Budget Filter", GLAccAnalysisView."Budget Filter");            GLAcc.CopyFilter("Business Unit Filter", GLAccAnalysisView."Business Unit Filter");            GLAccAnalysisView.SetRange("Analysis View Filter", AccSchedName."Analysis View Name");            GLAccAnalysisView.FilterGroup(2);            GLAccAnalysisView.SetDimFilters(              AccSchedManagement.GetDimTotalingFilter(1, AccScheduleLine."Dimension 1 Totaling"),              AccSchedManagement.GetDimTotalingFilter(2, AccScheduleLine."Dimension 2 Totaling"),              AccSchedManagement.GetDimTotalingFilter(3, AccScheduleLine."Dimension 3 Totaling"),              AccSchedManagement.GetDimTotalingFilter(4, AccScheduleLine."Dimension 4 Totaling"));            GLAccAnalysisView.FilterGroup(8);            GLAccAnalysisView.SetDimFilters(              AccSchedManagement.GetDimTotalingFilter(1, ColumnLayout."Dimension 1 Totaling"),              AccSchedManagement.GetDimTotalingFilter(2, ColumnLayout."Dimension 2 Totaling"),              AccSchedManagement.GetDimTotalingFilter(3, ColumnLayout."Dimension 3 Totaling"),              AccSchedManagement.GetDimTotalingFilter(4, ColumnLayout."Dimension 4 Totaling"));            GLAccAnalysisView.SetFilter("Business Unit Filter", ColumnLayout."Business Unit Totaling");            GLAccAnalysisView.FilterGroup(0);            OnDrillDownOnGLAccountOnBeforeRunChartOfAccsAnalysisView(GLAcc, ColumnLayout);            Clear(ChartOfAccsAnalysisView);            ChartOfAccsAnalysisView.InsertTempGLAccAnalysisViews(GLAcc);            ChartOfAccsAnalysisView.SetTableView(GLAccAnalysisView);            ChartOfAccsAnalysisView.Run();        end;    end;    /// <summary>    /// Selects all chart setup lines and applies default chart types for measures or dimensions.    /// Enables all available data series in the chart with appropriate visualization settings.    /// </summary>    /// <param name="AccSchedChartSetupLine">Chart setup line record defining the selection scope</param>    /// <param name="IsMeasure">True to select measures, false to select dimensions</param>    procedure SelectAll(AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"; IsMeasure: Boolean)    var        AccountSchedulesChartSetup: Record "Account Schedules Chart Setup";    begin        AccountSchedulesChartSetup.Get(AccSchedChartSetupLine."User ID", AccSchedChartSetupLine.Name);        if IsMeasure then            AccountSchedulesChartSetup.SetMeasureChartTypesToDefault(AccSchedChartSetupLine)        else            AccountSchedulesChartSetup.SetDimensionChartTypesToDefault(AccSchedChartSetupLine);    end;    /// <summary>    /// Deselects all chart setup lines and removes chart type assignments for measures or dimensions.    /// Hides all data series from the chart display by clearing visualization settings.    /// </summary>    /// <param name="AccSchedChartSetupLine">Chart setup line record defining the deselection scope</param>    /// <param name="IsMeasure">True to deselect measures, false to deselect dimensions</param>    procedure DeselectAll(AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"; IsMeasure: Boolean)    var        AccountSchedulesChartSetup: Record "Account Schedules Chart Setup";    begin        AccountSchedulesChartSetup.Get(AccSchedChartSetupLine."User ID", AccSchedChartSetupLine.Name);        if IsMeasure then            AccountSchedulesChartSetup.SetLinkToMeasureLines(AccSchedChartSetupLine)        else            AccountSchedulesChartSetup.SetLinkToDimensionLines(AccSchedChartSetupLine);        AccSchedChartSetupLine.ModifyAll("Chart Type", AccSchedChartSetupLine."Chart Type"::" ");    end;    /// <summary>    /// Provides reference to the internal account schedule management codeunit for external access.    /// Enables external code to access account schedule calculation and management functionality.    /// </summary>    /// <param name="RefAccSchedManagement">Variable to receive the account schedule management codeunit reference</param>    procedure GetAccSchedMgtRef(var RefAccSchedManagement: Codeunit AccSchedManagement)    begin        RefAccSchedManagement := AccSchedManagement;    end;    local procedure RoundAmount(Amount: Decimal): Decimal    begin        if not GLSetupLoaded then begin            GeneralLedgerSetup.Get();            GLSetupLoaded := true;        end;        exit(Round(Amount, GeneralLedgerSetup."Amount Rounding Precision"));    end;    /// <summary>    /// Integration event raised before running Chart of Accounts Analysis View from GL account drill-down.    /// Enables custom handling of analysis view navigation and filtering.    /// </summary>    /// <param name="GLAccount">G/L Account record being drilled down from chart</param>    /// <param name="ColumnLayout">Column layout record defining drill-down context and parameters</param>    [IntegrationEvent(false, false)]    local procedure OnDrillDownOnGLAccountOnBeforeRunChartOfAccsAnalysisView(var GLAccount: Record "G/L Account"; var ColumnLayout: Record "Column Layout")    begin    end;    /// <summary>    /// Integration event raised for custom totaling type drill-down handling.    /// Enables extensibility for custom account schedule line totaling types not covered by standard logic.    /// </summary>    /// <param name="AccScheduleLine">Account schedule line record with custom totaling type</param>    /// <param name="ColumnLayout">Column layout record defining drill-down context and parameters</param>    /// <param name="BusChartBuf">Business chart buffer containing drill-down data point information</param>    [IntegrationEvent(false, false)]    local procedure OnDrillDownTotalingTypeElseCase(var AccScheduleLine: Record "Acc. Schedule Line"; var ColumnLayout: Record "Column Layout"; var BusChartBuf: Record "Business Chart Buffer")    begin    end;    /// <summary>    /// Integration event raised before running Chart of Accounts GL page from GL account drill-down.    /// Enables custom handling of GL account navigation and filtering.    /// </summary>    /// <param name="GLAccount">G/L Account record being drilled down from chart</param>    /// <param name="ColumnLayout">Column layout record defining drill-down context and parameters</param>    [IntegrationEvent(false, false)]    local procedure OnDrillDownOnGLAccountOnBeforeRunChartOfAccountsGL(var GLAccount: Record "G/L Account"; var ColumnLayout: Record "Column Layout")    begin    end;}