Codeunit 7110 Analysis Report Management

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisReportManagement.Codeunit.al1,884 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.Inventory.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Setup;using Microsoft.Pricing.Calculation;using Microsoft.Pricing.PriceList;using Microsoft.Purchases.Analysis;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Analysis;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.Setup;codeunit 7110 "Analysis Report Management"{    TableNo = "Analysis Line";    trigger OnRun()    begin        Rec.SetFilter("Row Ref. No.", TryExpression);    end;    var        OriginalAnalysisLineFilters: Record "Analysis Line";        AnalysisLineTemplate: Record "Analysis Line Template";        TempAnalysisFieldValue: Record "Analysis Field Value" temporary;        GLSetup: Record "General Ledger Setup";        InventorySetup: Record "Inventory Setup";        SalesSetup: Record "Sales & Receivables Setup";        AccountingPeriodMgt: Codeunit "Accounting Period Mgt.";        StartDate: Date;        EndDate: Date;        FiscalStartDate: Date;        DivisionError: Boolean;        PeriodError: Boolean;        FormulaError: Boolean;        CyclicError: Boolean;        CallLevel: Integer;        OldAnalysisLineFilters: Text;        OldAnalysisColumnFilters: Text;        OldAnalysisLineTemplate: Code[10];        SalesSetupRead: Boolean;        InventorySetupRead: Boolean;        TryExpression: Text[250];#pragma warning disable AA0074        Text001: Label 'DEFAULT';        Text002: Label 'Default Lines';        Text003: Label 'Default Columns';#pragma warning restore AA0074        Text005Tok: Label 'M', Comment = 'Month';        Text006Tok: Label 'Q', Comment = 'Quarter';        Text007Tok: Label 'Y', Comment = 'Year';#pragma warning disable AA0074#pragma warning disable AA0470        Text021: Label 'Conversion of dimension totaling filter %1 results in a filter that becomes too long.';        Text022: Label 'You must specify an %1 on %2 %3 %4 that includes the %5 dimension.';        Text023: Label 'Column formula: %1';        Text024: Label 'Row formula: %1';#pragma warning restore AA0470#pragma warning restore AA0074        ColumnFormulaMsg: Label 'Column formula: %1. \Error: %2.', Comment = '%1 - text of Column formula; %2 - text of Error';        ShowError: Option "None","Division by Zero","Period Error","Invalid Formula","Cyclic Formula",All;        SeparatorTok: Label ';', Locked = true;    procedure LookupAnalysisReportName(CurrentAnalysisArea: Enum "Analysis Area Type"; var CurrentReportName: Code[10]): Boolean    var        AnalysisReportName: Record "Analysis Report Name";    begin        AnalysisReportName."Analysis Area" := CurrentAnalysisArea;        AnalysisReportName.Name := CurrentReportName;        AnalysisReportName.FilterGroup := 2;        AnalysisReportName.SetRange("Analysis Area", CurrentAnalysisArea);        AnalysisReportName.FilterGroup := 0;        if PAGE.RunModal(0, AnalysisReportName) = ACTION::LookupOK then begin            CurrentReportName := AnalysisReportName.Name;            exit(true);        end;    end;    procedure CheckReportName(CurrentReportName: Code[10]; var AnalysisLine: Record "Analysis Line")    var        AnalysisReportName: Record "Analysis Report Name";    begin        if CurrentReportName <> '' then            AnalysisReportName.Get(AnalysisLine.GetRangeMax("Analysis Area"), CurrentReportName);    end;    procedure OpenAnalysisLines(var CurrentLineTemplate: Code[10]; var AnalysisLine: Record "Analysis Line")    begin        CheckAnalysisLineTemplName(AnalysisLine.GetRangeMax("Analysis Area"), CurrentLineTemplate);        AnalysisLine.FilterGroup := 2;        AnalysisLine.SetRange("Analysis Line Template Name", CurrentLineTemplate);        AnalysisLine.FilterGroup := 0;    end;    local procedure CheckAnalysisLineTemplName(CurrentAnalysisArea: Enum "Analysis Area Type"; var CurrentAnalysisLineTempl: Code[10])    var        AnalysisLineTemplate2: Record "Analysis Line Template";    begin        if not AnalysisLineTemplate2.Get(CurrentAnalysisArea, CurrentAnalysisLineTempl) then begin            AnalysisLineTemplate2.SetRange("Analysis Area", CurrentAnalysisArea);            if not AnalysisLineTemplate2.FindFirst() then begin                AnalysisLineTemplate2.Init();                AnalysisLineTemplate2."Analysis Area" := CurrentAnalysisArea;                AnalysisLineTemplate2.Name := Text001;                AnalysisLineTemplate2.Description := Text002;                AnalysisLineTemplate2.Insert(true);                Commit();            end;            CurrentAnalysisLineTempl := AnalysisLineTemplate2.Name;        end;    end;    procedure CheckAnalysisLineTemplName(CurrentAnalysisLineTempl: Code[10]; var AnalysisLine: Record "Analysis Line")    var        AnalysisLineTemplate2: Record "Analysis Line Template";    begin        AnalysisLineTemplate2.Get(AnalysisLine.GetRangeMax("Analysis Area"), CurrentAnalysisLineTempl);    end;    procedure SetAnalysisLineTemplName(CurrentAnalysisLineTempl: Code[10]; var AnalysisLine: Record "Analysis Line")    begin        AnalysisLine.FilterGroup := 2;        AnalysisLine.SetRange("Analysis Area", AnalysisLine.GetRangeMax("Analysis Area"));        AnalysisLine.SetRange("Analysis Line Template Name", CurrentAnalysisLineTempl);        AnalysisLine.FilterGroup := 0;        if AnalysisLine.Find('-') then;    end;    procedure LookupAnalysisLineTemplName(var CurrentAnalysisLineTempl: Code[10]; var AnalysisLine: Record "Analysis Line"): Boolean    var        AnalysisLineTemplate2: Record "Analysis Line Template";    begin        Commit();        AnalysisLineTemplate2."Analysis Area" := AnalysisLine.GetRangeMax("Analysis Area");        AnalysisLineTemplate2.Name := AnalysisLine.GetRangeMax("Analysis Line Template Name");        AnalysisLineTemplate2.FilterGroup := 2;        AnalysisLineTemplate2.SetRange("Analysis Area", AnalysisLine.GetRangeMax("Analysis Area"));        AnalysisLineTemplate2.FilterGroup := 0;        if PAGE.RunModal(0, AnalysisLineTemplate2) = ACTION::LookupOK then begin            CheckAnalysisLineTemplName(AnalysisLineTemplate2.Name, AnalysisLine);            CurrentAnalysisLineTempl := AnalysisLineTemplate2.Name;            SetAnalysisLineTemplName(CurrentAnalysisLineTempl, AnalysisLine);            exit(true);        end;        OpenAnalysisLines(CurrentAnalysisLineTempl, AnalysisLine);    end;    procedure OpenAnalysisLinesForm(var AnalysisLine2: Record "Analysis Line"; CurrentAnalysisLineTempl: Code[10])    var        AnalysisLine: Record "Analysis Line";        AnalysisLines: Page "Inventory Analysis Lines";        AnalysisLinesForSale: Page "Sales Analysis Lines";        AnalysisLinesForPurchase: Page "Purchase Analysis Lines";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeOpenAnalysisLinesForm(AnalysisLine2, CurrentAnalysisLineTempl, IsHandled);        if IsHandled then            exit;        Commit();        AnalysisLine.Copy(AnalysisLine2);        case AnalysisLine.GetRangeMax("Analysis Area") of            AnalysisLine."Analysis Area"::Sales:                begin                    AnalysisLinesForSale.SetCurrentAnalysisLineTempl(CurrentAnalysisLineTempl);                    AnalysisLinesForSale.SetTableView(AnalysisLine);                    AnalysisLinesForSale.RunModal();                end;            AnalysisLine."Analysis Area"::Purchase:                begin                    AnalysisLinesForPurchase.SetCurrentAnalysisLineTempl(CurrentAnalysisLineTempl);                    AnalysisLinesForPurchase.SetTableView(AnalysisLine);                    AnalysisLinesForPurchase.RunModal();                end;            else                AnalysisLines.SetCurrentAnalysisLineTempl(CurrentAnalysisLineTempl);                AnalysisLines.SetTableView(AnalysisLine);                AnalysisLines.RunModal();        end;    end;    procedure OpenAnalysisColumnsForm(var AnalysisLine: Record "Analysis Line"; CurrentColumnTempl: Code[10])    var        AnalysisColumn: Record "Analysis Column";        AnalysisColumns: Page "Analysis Columns";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeOpenAnalysisColumnsForm(AnalysisLine, CurrentColumnTempl, IsHandled);        if IsHandled then            exit;        Commit();        AnalysisColumn.FilterGroup := 2;        AnalysisColumn.SetRange(          "Analysis Area", AnalysisLine.GetRangeMax("Analysis Area"));        AnalysisColumn.FilterGroup := 0;        AnalysisColumns.SetTableView(AnalysisColumn);        AnalysisColumns.SetCurrentColumnName(CurrentColumnTempl);        AnalysisColumns.RunModal();    end;    procedure OpenColumns(var CurrentColumnTempl: Code[10]; var AnalysisLine: Record "Analysis Line"; var AnalysisColumn: Record "Analysis Column")    begin        CheckColumnTemplate(AnalysisLine.GetRangeMax("Analysis Area"), CurrentColumnTempl);        AnalysisColumn.FilterGroup := 2;        AnalysisColumn.SetRange("Analysis Area", AnalysisLine.GetRangeMax("Analysis Area"));        AnalysisColumn.SetRange("Analysis Column Template", CurrentColumnTempl);        AnalysisColumn.FilterGroup := 0;        OnAfterOpenColumns(CurrentColumnTempl, AnalysisLine, AnalysisColumn);    end;    procedure OpenColumns(var CurrentColumnTempl: Code[10]; var AnalysisColumn: Record "Analysis Column")    begin        CheckColumnTemplate(AnalysisColumn.GetRangeMax("Analysis Area"), CurrentColumnTempl);        AnalysisColumn.FilterGroup := 2;        AnalysisColumn.SetRange("Analysis Column Template", CurrentColumnTempl);        AnalysisColumn.FilterGroup := 0;    end;    local procedure CheckColumnTemplate(CurrentAnalysisArea: Enum "Analysis Area Type"; var CurrentColumnName: Code[10])    var        AnalysisColumnTemplate: Record "Analysis Column Template";    begin        if not AnalysisColumnTemplate.Get(CurrentAnalysisArea, CurrentColumnName) then begin            AnalysisColumnTemplate.SetRange("Analysis Area", CurrentAnalysisArea);            if not AnalysisColumnTemplate.FindFirst() then begin                AnalysisColumnTemplate.Init();                AnalysisColumnTemplate."Analysis Area" := CurrentAnalysisArea;                AnalysisColumnTemplate.Name := Text001;                AnalysisColumnTemplate.Description := Text003;                AnalysisColumnTemplate.Insert(true);                Commit();            end;            CurrentColumnName := AnalysisColumnTemplate.Name;        end;    end;    procedure GetColumnTemplate(CurrentAnalysisArea: Option Sale,Purchase,Inventory; CurrentColumnTemplate: Code[10])    var        AnalysisColumnTemplate: Record "Analysis Column Template";    begin        AnalysisColumnTemplate.Get(CurrentAnalysisArea, CurrentColumnTemplate);    end;    procedure SetColumnName(CurrentAnalysisArea: Option Sale,Purchase,Inventory; CurrentColumnName: Code[10]; var AnalysisColumn: Record "Analysis Column")    begin        AnalysisColumn.FilterGroup := 2;        AnalysisColumn.SetRange("Analysis Area", CurrentAnalysisArea);        AnalysisColumn.SetRange("Analysis Column Template", CurrentColumnName);        AnalysisColumn.FilterGroup := 0;        if AnalysisColumn.Find('-') then;    end;    procedure CopyColumnsToTemp(var AnalysisLine: Record "Analysis Line"; ColumnName: Code[10]; var TempAnalysisColumn: Record "Analysis Column")    var        AnalysisColumn: Record "Analysis Column";    begin        TempAnalysisColumn.Reset();        TempAnalysisColumn.DeleteAll();        AnalysisColumn.SetRange(          "Analysis Area", AnalysisLine.GetRangeMax("Analysis Area"));        AnalysisColumn.SetRange("Analysis Column Template", ColumnName);        OnCopyColumnsToTempOnBeforeAnalysisColumnFindset(AnalysisColumn, ColumnName);        if AnalysisColumn.FindSet() then begin            repeat                TempAnalysisColumn := AnalysisColumn;                TempAnalysisColumn.Insert();            until AnalysisColumn.Next() = 0;            TempAnalysisColumn.FindFirst();        end;    end;    procedure LookupAnalysisColumnName(CurrentAnalysisArea: Enum "Analysis Area Type"; var CurrentColumnName: Code[10]): Boolean    var        AnalysisColumnTemplate: Record "Analysis Column Template";    begin        AnalysisColumnTemplate.FilterGroup := 2;        AnalysisColumnTemplate.SetRange("Analysis Area", CurrentAnalysisArea);        AnalysisColumnTemplate.FilterGroup := 0;        AnalysisColumnTemplate."Analysis Area" := CurrentAnalysisArea;        AnalysisColumnTemplate.Name := CurrentColumnName;        if PAGE.RunModal(0, AnalysisColumnTemplate) = ACTION::LookupOK then begin            CurrentColumnName := AnalysisColumnTemplate.Name;            exit(true);        end;    end;    procedure SetSourceType(var AnalysisLine: Record "Analysis Line"; CurrentSourceTypeFilter: Option " ",Customer,Vendor,Item)    begin        if CurrentSourceTypeFilter = CurrentSourceTypeFilter::" " then            exit;        AnalysisLine.SetRange("Source Type Filter", CurrentSourceTypeFilter);    end;    procedure SetSourceNo(var AnalysisLine: Record "Analysis Line"; CurrentSourceTypeNoFilter: Text)    begin        AnalysisLine.SetFilter("Source No. Filter", CurrentSourceTypeNoFilter);    end;    procedure DoLookupSourceNo(var AnalysisLine: Record "Analysis Line"; CurrentSourceTypeFilter: Enum "Analysis Source Type"; var CurrentSourceTypeNoFilter: Text)    var        CustList: Page "Customer List";        VendList: Page "Vendor List";        ItemList: Page "Item List";    begin        case CurrentSourceTypeFilter of            CurrentSourceTypeFilter::" ":                exit;            CurrentSourceTypeFilter::Customer:                begin                    CustList.LookupMode := true;                    if CustList.RunModal() = ACTION::LookupOK then                        CurrentSourceTypeNoFilter := CustList.GetSelectionFilter();                end;            CurrentSourceTypeFilter::Vendor:                begin                    VendList.LookupMode := true;                    if VendList.RunModal() = ACTION::LookupOK then                        CurrentSourceTypeNoFilter := VendList.GetSelectionFilter();                end;            CurrentSourceTypeFilter::Item:                begin                    ItemList.LookupMode := true;                    if ItemList.RunModal() = ACTION::LookupOK then                        CurrentSourceTypeNoFilter := ItemList.GetSelectionFilter();                end;            else                OnDoLookupSourceNoOnElseCurrentSourceTypeFilter(CurrentSourceTypeFilter, CurrentSourceTypeNoFilter);        end;        SetSourceNo(AnalysisLine, CurrentSourceTypeNoFilter);    end;    local procedure AccPeriodStartEnd(Formula: Code[20]; Date: Date; var StartDate: Date; var EndDate: Date)    var        PeriodFormulaParser: Codeunit "Period Formula Parser";        LanguageId: Integer;        Steps: Integer;        Type: Enum "Period Type";        RangeFromType: Enum "Period Formula Range";        RangeToType: Enum "Period Formula Range";        RangeFromInt: Integer;        RangeToInt: Integer;    begin        if Formula = '' then            exit;        PeriodFormulaParser.ParsePeriodFormula(          Formula, Steps, Type, RangeFromType, RangeToType, RangeFromInt, RangeToInt, LanguageId);        AccountingPeriodMgt.AccPeriodStartEnd(          Date, StartDate, EndDate, PeriodError, Steps, Type, RangeFromType, RangeToType, RangeFromInt, RangeToInt);    end;    procedure CalcCell(var AnalysisLine: Record "Analysis Line"; var AnalysisColumn: Record "Analysis Column"; DrillDown: Boolean): Decimal    var        ErrorText: Text;        Result: Decimal;    begin        if DrillDown and           ((AnalysisColumn."Column Type" = AnalysisColumn."Column Type"::Formula) or            (AnalysisLine.Type = AnalysisLine.Type::Formula))        then begin            if AnalysisColumn."Column Type" = AnalysisColumn."Column Type"::Formula then begin                ErrorText := CalcFieldError(AnalysisLine."Line No.", AnalysisColumn."Line No.");                if ErrorText = '' then                    Message(Text023, AnalysisColumn.Formula)                else                    Message(ColumnFormulaMsg, AnalysisColumn.Formula, ErrorText);            end else                Message(Text024, AnalysisLine.Range);            exit(0);        end;        OriginalAnalysisLineFilters.CopyFilters(AnalysisLine);        StartDate := AnalysisLine.GetRangeMin("Date Filter");        if EndDate <> AnalysisLine.GetRangeMax("Date Filter") then begin            EndDate := AnalysisLine.GetRangeMax("Date Filter");            FiscalStartDate := AccountingPeriodMgt.FindFiscalYear(EndDate);        end;        DivisionError := false;        PeriodError := false;        FormulaError := false;        CyclicError := false;        CallLevel := 0;        if (OldAnalysisLineFilters <> AnalysisLine.GetFilters) or           (OldAnalysisColumnFilters <> AnalysisColumn.GetFilters) or           (OldAnalysisLineTemplate <> AnalysisLine."Analysis Line Template Name") or           (OldAnalysisLineTemplate <> AnalysisColumn."Analysis Column Template")        then begin            TempAnalysisFieldValue.Reset();            TempAnalysisFieldValue.DeleteAll();            OldAnalysisLineFilters := AnalysisLine.GetFilters();            OldAnalysisColumnFilters := AnalysisColumn.GetFilters();            OldAnalysisLineTemplate := AnalysisLine."Analysis Line Template Name";            OldAnalysisLineTemplate := AnalysisColumn."Analysis Column Template";        end;        Result := CalcCellValue(AnalysisLine, AnalysisColumn, DrillDown);        case AnalysisColumn.Show of            AnalysisColumn.Show::"When Positive":                if Result < 0 then                    Result := 0;            AnalysisColumn.Show::"When Negative":                if Result > 0 then                    Result := 0;        end;        if AnalysisColumn."Show Opposite Sign" then            Result := -Result;        if AnalysisLine."Show Opposite Sign" then            Result := -Result;        exit(Result);    end;    local procedure CalcCellValue(AnalysisLine: Record "Analysis Line"; AnalysisColumn: Record "Analysis Column"; DrillDown: Boolean): Decimal    var        ItemStatisticsBuf: Record "Item Statistics Buffer";        Result: Decimal;    begin        Result := 0;        if AnalysisLine.Range <> '' then begin            case true of                TempAnalysisFieldValue.Get(AnalysisLine."Line No.", AnalysisColumn."Line No.") and not DrillDown:                    begin                        Result := TempAnalysisFieldValue.Value;                        DivisionError := DivisionError or TempAnalysisFieldValue."Has Error";                        PeriodError := PeriodError or TempAnalysisFieldValue."Period Error";                        FormulaError := FormulaError or TempAnalysisFieldValue."Formula Error";                        CyclicError := CyclicError or TempAnalysisFieldValue."Cyclic Error";                        exit(Result);                    end;                AnalysisColumn."Column Type" = AnalysisColumn."Column Type"::Formula:                    Result :=                      EvaluateExpression(                        false, AnalysisColumn.Formula, AnalysisLine, AnalysisColumn);                AnalysisLine.Type = AnalysisLine.Type::Formula:                    Result :=                      EvaluateExpression(                        true, AnalysisLine.Range, AnalysisLine, AnalysisColumn);                (StartDate = 0D) or (EndDate in [0D, DMY2Date(31, 12, 9999)]):                    begin                        Result := 0;                        PeriodError := true;                    end;                else                    if (AnalysisLineTemplate."Analysis Area" <> AnalysisLine."Analysis Area") or                       (AnalysisLineTemplate.Name <> AnalysisLine."Analysis Line Template Name")                    then                        AnalysisLineTemplate.Get(AnalysisLine."Analysis Area", AnalysisLine."Analysis Line Template Name");                    AnalysisLine.CopyFilters(OriginalAnalysisLineFilters);                    SetItemRowFilters(ItemStatisticsBuf, AnalysisLine);                    SetItemColumnFilters(ItemStatisticsBuf, AnalysisColumn);                    Result := Result + CalcItemStatistics(ItemStatisticsBuf, AnalysisLine, AnalysisColumn, DrillDown);            end;            if not DrillDown then begin                TempAnalysisFieldValue."Row Ref. No." := AnalysisLine."Line No.";                TempAnalysisFieldValue."Column No." := AnalysisColumn."Line No.";                TempAnalysisFieldValue.Value := Result;                TempAnalysisFieldValue."Has Error" := DivisionError;                TempAnalysisFieldValue."Period Error" := PeriodError;                TempAnalysisFieldValue."Formula Error" := FormulaError;                TempAnalysisFieldValue."Cyclic Error" := CyclicError;                if TempAnalysisFieldValue.Insert() then;            end;        end;        exit(Result);    end;    local procedure CalcItemStatistics(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var AnalysisLine: Record "Analysis Line"; var AnalysisColumn: Record "Analysis Column"; DrillDown: Boolean): Decimal    var        ColValue: Decimal;    begin        ColValue := 0;        if (AnalysisLineTemplate."Analysis Area" <> AnalysisLine."Analysis Area") or           (AnalysisLineTemplate.Name <> AnalysisLine."Analysis Line Template Name")        then            AnalysisLineTemplate.Get(AnalysisLine."Analysis Area", AnalysisLine."Analysis Line Template Name");        if AnalysisColumn."Column Type" <> AnalysisColumn."Column Type"::Formula then begin            if AnalysisLine.GetFilter("Source No. Filter") <> '' then                case FilterToValue(AnalysisLine) of                    AnalysisLine."Source Type Filter"::Customer:                        begin                            ItemStatisticsBuf.SetRange("Source Type Filter", ItemStatisticsBuf."Source Type Filter"::Customer);                            ItemStatisticsBuf.SetFilter("Source No. Filter", GetSourceNoFilter(ItemStatisticsBuf, AnalysisLine));                        end;                    AnalysisLine."Source Type Filter"::Vendor:                        begin                            ItemStatisticsBuf.SetRange("Source Type Filter", ItemStatisticsBuf."Source Type Filter"::Vendor);                            ItemStatisticsBuf.SetFilter("Source No. Filter", GetSourceNoFilter(ItemStatisticsBuf, AnalysisLine));                        end;                    AnalysisLine."Source Type Filter"::Item:                        ItemStatisticsBuf.SetFilter("Item Filter", GetSourceNoFilter(ItemStatisticsBuf, AnalysisLine));                end;            if AnalysisLineTemplate."Item Analysis View Code" = '' then begin                if ItemStatisticsBuf.GetFilter("Global Dimension 1 Filter") = '' then                    AnalysisLine.CopyFilter("Dimension 1 Filter", ItemStatisticsBuf."Global Dimension 1 Filter");                if ItemStatisticsBuf.GetFilter("Global Dimension 2 Filter") = '' then                    AnalysisLine.CopyFilter("Dimension 2 Filter", ItemStatisticsBuf."Global Dimension 2 Filter");                ItemStatisticsBuf.FilterGroup := 2;                ItemStatisticsBuf.SetFilter("Global Dimension 1 Filter", GetDimTotalingFilter(1, AnalysisLine."Dimension 1 Totaling"));                ItemStatisticsBuf.SetFilter("Global Dimension 2 Filter", GetDimTotalingFilter(2, AnalysisLine."Dimension 2 Totaling"));                ItemStatisticsBuf.FilterGroup := 0;            end else begin                ItemStatisticsBuf.SetFilter("Analysis View Filter", AnalysisLineTemplate."Item Analysis View Code");                if ItemStatisticsBuf.GetFilter("Dimension 1 Filter") = '' then                    AnalysisLine.CopyFilter("Dimension 1 Filter", ItemStatisticsBuf."Dimension 1 Filter");                if ItemStatisticsBuf.GetFilter("Dimension 2 Filter") = '' then                    AnalysisLine.CopyFilter("Dimension 2 Filter", ItemStatisticsBuf."Dimension 2 Filter");                if ItemStatisticsBuf.GetFilter("Dimension 3 Filter") = '' then                    AnalysisLine.CopyFilter("Dimension 3 Filter", ItemStatisticsBuf."Dimension 3 Filter");                ItemStatisticsBuf.FilterGroup := 2;                ItemStatisticsBuf.SetFilter("Dimension 1 Filter", GetDimTotalingFilter(1, AnalysisLine."Dimension 1 Totaling"));                ItemStatisticsBuf.SetFilter("Dimension 2 Filter", GetDimTotalingFilter(2, AnalysisLine."Dimension 2 Totaling"));                ItemStatisticsBuf.SetFilter("Dimension 3 Filter", GetDimTotalingFilter(3, AnalysisLine."Dimension 3 Totaling"));                ItemStatisticsBuf.FilterGroup := 0;            end;            AnalysisLine.CopyFilter("Location Filter", ItemStatisticsBuf."Location Filter");            OnCalcItemStatisticsOnAfterSetFilters(ItemStatisticsBuf, AnalysisLine);            case AnalysisColumn."Ledger Entry Type" of                AnalysisColumn."Ledger Entry Type"::"Item Entries":                    if DrillDown then                        case AnalysisColumn."Value Type" of                            AnalysisColumn."Value Type"::Quantity:                                DrillDownQuantity(ItemStatisticsBuf, AnalysisColumn.Invoiced);                            AnalysisColumn."Value Type"::"Sales Amount":                                DrillDownSalesAmount(ItemStatisticsBuf, AnalysisColumn.Invoiced);                            AnalysisColumn."Value Type"::"Cost Amount":                                DrillDownCostAmount(ItemStatisticsBuf, AnalysisColumn.Invoiced);                            AnalysisColumn."Value Type"::"Non-Invntble Amount":                                DrillDownCostAmountNonInvnt(ItemStatisticsBuf, AnalysisColumn.Invoiced);                            AnalysisColumn."Value Type"::"Unit Price":                                DrillDownUnitPrice(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Standard Cost":                                DrillDownStdCost(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Indirect Cost":                                DrillDownIndirectCost(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Unit Cost":                                DrillDownUnitCost(ItemStatisticsBuf);                        end                    else                        case AnalysisColumn."Value Type" of                            AnalysisColumn."Value Type"::Quantity:                                ColValue := CalcQuantity(ItemStatisticsBuf, AnalysisColumn.Invoiced);                            AnalysisColumn."Value Type"::"Sales Amount":                                ColValue := CalcSalesAmount(ItemStatisticsBuf, AnalysisColumn.Invoiced);                            AnalysisColumn."Value Type"::"Cost Amount":                                ColValue := CalcCostAmount(ItemStatisticsBuf, AnalysisColumn.Invoiced);                            AnalysisColumn."Value Type"::"Non-Invntble Amount":                                ColValue := CalcCostAmountNonInvnt(ItemStatisticsBuf, AnalysisColumn.Invoiced);                            AnalysisColumn."Value Type"::"Unit Price":                                ColValue := CalcUnitPrice(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Standard Cost":                                ColValue := CalcStdCost(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Indirect Cost":                                ColValue := CalcIndirectCost(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Unit Cost":                                ColValue := CalcUnitCost(ItemStatisticsBuf);                        end;                AnalysisColumn."Ledger Entry Type"::"Item Budget Entries":                    if DrillDown then                        case AnalysisColumn."Value Type" of                            AnalysisColumn."Value Type"::Quantity:                                DrillDownBudgetQuantity(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Sales Amount":                                DrillDownBudgetSalesAmount(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Cost Amount":                                DrillDownBudgetCostAmount(ItemStatisticsBuf);                        end                    else                        case AnalysisColumn."Value Type" of                            AnalysisColumn."Value Type"::Quantity:                                ColValue := CalcBudgetQuantity(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Sales Amount":                                ColValue := CalcBudgetSalesAmount(ItemStatisticsBuf);                            AnalysisColumn."Value Type"::"Cost Amount":                                ColValue := CalcBudgetCostAmount(ItemStatisticsBuf);                        end;            end;        end;        OnAfterCalcItemStatistics(ItemStatisticsBuf, AnalysisLine, AnalysisColumn, DrillDown, ColValue);        exit(ColValue);    end;    procedure SetItemRowFilters(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var AnalysisLine: Record "Analysis Line")    begin        case AnalysisLine."Analysis Area" of            AnalysisLine."Analysis Area"::Sales:                ItemStatisticsBuf.SetRange("Analysis Area Filter", AnalysisLine."Analysis Area"::Sales);            AnalysisLine."Analysis Area"::Purchase:                ItemStatisticsBuf.SetRange("Analysis Area Filter", AnalysisLine."Analysis Area"::Purchase);            AnalysisLine."Analysis Area"::Inventory:                ItemStatisticsBuf.SetRange("Analysis Area Filter", AnalysisLine."Analysis Area"::Inventory);        end;        ItemStatisticsBuf.SetFilter("Budget Filter", AnalysisLine.GetFilter(AnalysisLine."Item Budget Filter"));        case AnalysisLine.Type of            AnalysisLine.Type::Item:                ItemStatisticsBuf.SetFilter("Item Filter", AnalysisLine.Range);            AnalysisLine.Type::Customer:                begin                    ItemStatisticsBuf.SetRange("Source Type Filter", ItemStatisticsBuf."Source Type Filter"::Customer);                    ItemStatisticsBuf.SetFilter("Source No. Filter", AnalysisLine.Range);                end;            AnalysisLine.Type::Vendor:                begin                    ItemStatisticsBuf.SetRange("Source Type Filter", ItemStatisticsBuf."Source Type Filter"::Vendor);                    ItemStatisticsBuf.SetFilter("Source No. Filter", AnalysisLine.Range);                end;            AnalysisLine.Type::"Sales/Purchase person":                begin                    GetSalesSetup();                    SetGroupDimFilter(ItemStatisticsBuf, SalesSetup."Salesperson Dimension Code", AnalysisLine.Range);                end;            AnalysisLine.Type::"Customer Group":                begin                    GetSalesSetup();                    SetGroupDimFilter(ItemStatisticsBuf, SalesSetup."Customer Group Dimension Code", AnalysisLine.Range);                end;            AnalysisLine.Type::"Item Group":                begin                    GetInventorySetup();                    SetGroupDimFilter(ItemStatisticsBuf, InventorySetup."Item Group Dimension Code", AnalysisLine.Range);                end;        end;        OnAfterSetItemRowFilters(ItemStatisticsBuf, AnalysisLine);    end;    procedure SetItemColumnFilters(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var AnalysisColumn: Record "Analysis Column")    var        FromDate: Date;        ToDate: Date;        FiscalStartDate2: Date;    begin        ItemStatisticsBuf.SetFilter("Entry Type Filter", AnalysisColumn."Value Entry Type Filter");        ItemStatisticsBuf.SetFilter("Item Ledger Entry Type Filter", AnalysisColumn."Item Ledger Entry Type Filter");        if (Format(AnalysisColumn."Comparison Date Formula") <> '0') and (Format(AnalysisColumn."Comparison Date Formula") <> '') then begin            FromDate := CalcDate(AnalysisColumn."Comparison Date Formula", StartDate);            if (EndDate = CalcDate('<CM>', EndDate)) and               ((StrPos(Format(AnalysisColumn."Comparison Date Formula"), Text005Tok) > 0) or                (StrPos(Format(AnalysisColumn."Comparison Date Formula"), Text006Tok) > 0) or                (StrPos(Format(AnalysisColumn."Comparison Date Formula"), Text007Tok) > 0))            then                ToDate := CalcDate('<CM>', CalcDate(AnalysisColumn."Comparison Date Formula", EndDate))            else                ToDate := CalcDate(AnalysisColumn."Comparison Date Formula", EndDate);            FiscalStartDate2 := AccountingPeriodMgt.FindFiscalYear(ToDate);        end else            if AnalysisColumn."Comparison Period Formula" <> '' then begin                AccPeriodStartEnd(AnalysisColumn."Comparison Period Formula", StartDate, FromDate, ToDate);                FiscalStartDate2 := AccountingPeriodMgt.FindFiscalYear(ToDate);            end else begin                FromDate := StartDate;                ToDate := EndDate;                FiscalStartDate2 := FiscalStartDate;            end;        case AnalysisColumn."Column Type" of            AnalysisColumn."Column Type"::"Net Change":                ItemStatisticsBuf.SetRange("Date Filter", FromDate, ToDate);            AnalysisColumn."Column Type"::"Balance at Date":                ItemStatisticsBuf.SetRange("Date Filter", 0D, ToDate);            AnalysisColumn."Column Type"::"Beginning Balance":                ItemStatisticsBuf.SetRange(                  "Date Filter", 0D, CalcDate('<-1D>', FromDate));            AnalysisColumn."Column Type"::"Year to Date":                ItemStatisticsBuf.SetRange(                  "Date Filter", FiscalStartDate2, ToDate);            AnalysisColumn."Column Type"::"Rest of Fiscal Year":                ItemStatisticsBuf.SetRange(                  "Date Filter",                  CalcDate('<+1D>', ToDate),                  AccountingPeriodMgt.FindEndOfFiscalYear(FiscalStartDate2));            AnalysisColumn."Column Type"::"Entire Fiscal Year":                ItemStatisticsBuf.SetRange(                  "Date Filter",                  FiscalStartDate2,                  AccountingPeriodMgt.FindEndOfFiscalYear(FiscalStartDate2));        end;        OnAfterSetItemColumnFilters(ItemStatisticsBuf, AnalysisColumn);    end;    local procedure EvaluateExpression(IsAnalysisLineExpression: Boolean; Expression: Text[250]; AnalysisLine: Record "Analysis Line"; AnalysisColumn: Record "Analysis Column"): Decimal    var        Result: Decimal;        Parentheses: Integer;        Operator: Char;        LeftOperand: Text[250];        RightOperand: Text[250];        LeftResult: Decimal;        RightResult: Decimal;        i: Integer;        IsExpression: Boolean;        IsFilter: Boolean;        Operators: Text[8];        OperatorNo: Integer;        AnalysisLineID: Integer;    begin        Result := 0;        CallLevel := CallLevel + 1;        if CallLevel > 25 then begin            CyclicError := true;            exit;        end;        Expression := DelChr(Expression, '<>', ' ');        if StrLen(Expression) > 0 then begin            Parentheses := 0;            IsExpression := false;            Operators := '+-*/^';            OperatorNo := 1;            repeat                i := StrLen(Expression);                repeat                    if Expression[i] = '(' then                        Parentheses := Parentheses + 1                    else                        if Expression[i] = ')' then                            Parentheses := Parentheses - 1;                    if (Parentheses = 0) and (Expression[i] = Operators[OperatorNo]) then                        IsExpression := true                    else                        i := i - 1;                until IsExpression or (i <= 0);                if not IsExpression then                    OperatorNo := OperatorNo + 1;            until (OperatorNo > StrLen(Operators)) or IsExpression;            if IsExpression then begin                if i > 1 then                    LeftOperand := CopyStr(Expression, 1, i - 1)                else                    LeftOperand := '';                if i < StrLen(Expression) then                    RightOperand := CopyStr(Expression, i + 1)                else                    RightOperand := '';                Operator := Expression[i];                LeftResult :=                  EvaluateExpression(                    IsAnalysisLineExpression, LeftOperand, AnalysisLine, AnalysisColumn);                RightResult :=                  EvaluateExpression(                    IsAnalysisLineExpression, RightOperand, AnalysisLine, AnalysisColumn);                case Operator of                    '^':                        Result := Power(LeftResult, RightResult);                    '*':                        Result := LeftResult * RightResult;                    '/':                        if RightResult = 0 then begin                            Result := 0;                            DivisionError := true;                        end else                            Result := LeftResult / RightResult;                    '+':                        Result := LeftResult + RightResult;                    '-':                        Result := LeftResult - RightResult;                end;            end else                if (Expression[1] = '(') and (Expression[StrLen(Expression)] = ')') then                    Result :=                      EvaluateExpression(                        IsAnalysisLineExpression, CopyStr(Expression, 2, StrLen(Expression) - 2),                        AnalysisLine, AnalysisColumn)                else begin                    IsFilter :=                      (StrPos(Expression, '..') +                       StrPos(Expression, '|') +                       StrPos(Expression, '<') +                       StrPos(Expression, '>') +                       StrPos(Expression, '&') +                       StrPos(Expression, '=') > 0);                    if (StrLen(Expression) > 10) and (not IsFilter) then                        Evaluate(Result, Expression)                    else                        if IsAnalysisLineExpression then begin                            AnalysisLine.SetRange("Analysis Area", AnalysisLine."Analysis Area");                            AnalysisLine.SetRange("Analysis Line Template Name", AnalysisLine."Analysis Line Template Name");                            if not IsValidAnalysisExpression(AnalysisLine, Expression) then                                FormulaError := true                            else                                AnalysisLine.SetFilter("Row Ref. No.", Expression);                            AnalysisLineID := AnalysisLine."Line No.";                            if not FormulaError then                                if AnalysisLine.Find('-') then                                    repeat                                        if AnalysisLine."Line No." <> AnalysisLineID then                                            Result := Result + CalcCellValue(AnalysisLine, AnalysisColumn, false);                                    until AnalysisLine.Next() = 0                                else                                    if IsFilter or (not Evaluate(Result, Expression)) then                                        FormulaError := true;                        end else begin                            AnalysisColumn.SetRange("Analysis Area", AnalysisColumn."Analysis Area");                            AnalysisColumn.SetRange("Analysis Column Template", AnalysisColumn."Analysis Column Template");                            if not IsValidAnalysisExpression(AnalysisLine, Expression) then                                FormulaError := true                            else                                AnalysisColumn.SetFilter("Column No.", Expression);                            AnalysisLineID := AnalysisColumn."Line No.";                            if not FormulaError then                                if AnalysisColumn.Find('-') then                                    repeat                                        if AnalysisColumn."Line No." <> AnalysisLineID then                                            Result := Result + CalcCellValue(AnalysisLine, AnalysisColumn, false);                                    until AnalysisColumn.Next() = 0                                else                                    if IsFilter or (not Evaluate(Result, Expression)) then                                        FormulaError := true;                        end;                end;        end;        CallLevel := CallLevel - 1;        exit(Result);    end;    procedure GetDivisionError(): Boolean    begin        exit(DivisionError);    end;    procedure GetPeriodError(): Boolean    begin        exit(PeriodError);    end;    procedure GetFormulaError(): Boolean    begin        exit(FormulaError);    end;    procedure GetCyclicError(): Boolean    begin        exit(CyclicError);    end;    procedure SetAnalysisLineTemplate(var NewAnalysisLineTemplate: Record "Analysis Line Template")    begin        AnalysisLineTemplate := NewAnalysisLineTemplate;    end;    local procedure GetDimTotalingFilter(DimNo: Integer; DimTotaling: Text[80]): Text[1024]    var        DimTotaling2: Text[80];        DimTotalPart: Text[80];        ResultFilter: Text[1024];        ResultFilter2: Text[1024];        i: Integer;    begin        if DimTotaling = '' then            exit(DimTotaling);        DimTotaling2 := DimTotaling;        repeat            i := StrPos(DimTotaling2, '|');            if i > 0 then begin                DimTotalPart := CopyStr(DimTotaling2, 1, i - 1);                if i < StrLen(DimTotaling2) then                    DimTotaling2 := CopyStr(DimTotaling2, i + 1)                else                    DimTotaling2 := '';            end else                DimTotalPart := DimTotaling2;            ResultFilter2 := ConvDimTotalingFilter(DimNo, DimTotalPart);            if ResultFilter2 <> '' then                if StrLen(ResultFilter) + StrLen(ResultFilter2) + 1 > MaxStrLen(ResultFilter) then                    Error(Text021, DimTotaling)                else begin                    if ResultFilter <> '' then                        ResultFilter := ResultFilter + '|';                    ResultFilter := ResultFilter + ResultFilter2;                end;        until i <= 0;        exit(ResultFilter);    end;    local procedure ConvDimTotalingFilter(DimNo: Integer; DimTotaling: Text[80]): Text[1024]    var        DimVal: Record "Dimension Value";        ItemAnalysisView: Record "Item Analysis View";        DimCode: Code[20];        ResultFilter: Text[1024];        DimValTotaling: Boolean;    begin        if DimTotaling = '' then            exit(DimTotaling);        if AnalysisLineTemplate."Item Analysis View Code" <> '' then            ItemAnalysisView.Get(AnalysisLineTemplate."Analysis Area", AnalysisLineTemplate."Item Analysis View Code")        else begin            GLSetup.Get();            ItemAnalysisView.Init();            ItemAnalysisView."Dimension 1 Code" := GLSetup."Global Dimension 1 Code";            ItemAnalysisView."Dimension 2 Code" := GLSetup."Global Dimension 2 Code";        end;        case DimNo of            1:                DimCode := ItemAnalysisView."Dimension 1 Code";            2:                DimCode := ItemAnalysisView."Dimension 2 Code";            3:                DimCode := ItemAnalysisView."Dimension 3 Code";        end;        if DimCode = '' then            exit(DimTotaling);        DimVal.SetRange("Dimension Code", DimCode);        DimVal.SetFilter(Code, DimTotaling);        if DimVal.Find('-') then            repeat                DimValTotaling :=                  DimVal."Dimension Value Type" in                  [DimVal."Dimension Value Type"::Total, DimVal."Dimension Value Type"::"End-Total"];                if DimValTotaling and (DimVal.Totaling <> '') then begin                    if StrLen(ResultFilter) + StrLen(DimVal.Totaling) + 1 > MaxStrLen(ResultFilter) then                        Error(Text021, DimTotaling);                    if ResultFilter <> '' then                        ResultFilter := ResultFilter + '|';                    ResultFilter := ResultFilter + DimVal.Totaling;                end;            until (DimVal.Next() = 0) or not DimValTotaling;        if DimValTotaling then            exit(ResultFilter);        exit(DimTotaling);    end;    local procedure CalcSalesAmount(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; Invoiced: Boolean) Result: Decimal    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcSalesAmount(ItemStatisticsBuffer, Invoiced, IsHandled, Result);        if IsHandled then            exit(Result);        if ItemStatisticsBuffer.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuffer.SetRange("Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            if Invoiced then begin                ItemStatisticsBuffer.CalcFields("Sales Amount (Actual)");                exit(ItemStatisticsBuffer."Sales Amount (Actual)");            end;            ItemStatisticsBuffer.CalcFields("Sales Amount (Expected)");            exit(ItemStatisticsBuffer."Sales Amount (Expected)");        end;        if Invoiced then begin            ItemStatisticsBuffer.CalcFields("Analysis - Sales Amt. (Actual)");            exit(ItemStatisticsBuffer."Analysis - Sales Amt. (Actual)");        end;        ItemStatisticsBuffer.CalcFields("Analysis - Sales Amt. (Exp)");        exit(ItemStatisticsBuffer."Analysis - Sales Amt. (Exp)");    end;    local procedure CalcCostAmount(var ItemStatisticsBuf: Record "Item Statistics Buffer"; Invoiced: Boolean): Decimal    begin        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange("Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            if Invoiced then begin                ItemStatisticsBuf.CalcFields("Cost Amount (Actual)");                exit(ItemStatisticsBuf."Cost Amount (Actual)");            end;            ItemStatisticsBuf.CalcFields("Cost Amount (Expected)");            exit(ItemStatisticsBuf."Cost Amount (Expected)");        end;        if Invoiced then begin            ItemStatisticsBuf.CalcFields("Analysis - Cost Amt. (Actual)");            exit(ItemStatisticsBuf."Analysis - Cost Amt. (Actual)");        end;        ItemStatisticsBuf.CalcFields("Analysis - Cost Amt. (Exp)");        exit(ItemStatisticsBuf."Analysis - Cost Amt. (Exp)");    end;    local procedure CalcCostAmountNonInvnt(var ItemStatisticsBuf: Record "Item Statistics Buffer"; Invoiced: Boolean): Decimal    begin        ItemStatisticsBuf.SetRange("Item Ledger Entry Type Filter");        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange("Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            if Invoiced then begin                ItemStatisticsBuf.CalcFields("Cost Amount (Non-Invtbl.)");                exit(ItemStatisticsBuf."Cost Amount (Non-Invtbl.)");            end;            exit(0);        end;        if Invoiced then begin            ItemStatisticsBuf.CalcFields("Analysis CostAmt.(Non-Invtbl.)");            exit(ItemStatisticsBuf."Analysis CostAmt.(Non-Invtbl.)");        end;    end;    local procedure CalcQuantity(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; Invoiced: Boolean) Result: Decimal    var        IsHandled: Boolean;    begin        OnBeforeCalcQuantity(ItemStatisticsBuffer, Invoiced, IsHandled, Result);        if IsHandled then            exit(Result);        if ItemStatisticsBuffer.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuffer.SetRange("Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            ItemStatisticsBuffer.SetRange(ItemStatisticsBuffer."Entry Type Filter");            if Invoiced then begin                ItemStatisticsBuffer.CalcFields("Invoiced Quantity");                exit(ItemStatisticsBuffer."Invoiced Quantity");            end;            ItemStatisticsBuffer.CalcFields(Quantity);            exit(ItemStatisticsBuffer.Quantity);        end;        ItemStatisticsBuffer.SetRange(ItemStatisticsBuffer."Entry Type Filter");        if Invoiced then begin            ItemStatisticsBuffer.CalcFields("Analysis - Invoiced Quantity");            exit(ItemStatisticsBuffer."Analysis - Invoiced Quantity");        end;        ItemStatisticsBuffer.CalcFields("Analysis - Quantity");        exit(ItemStatisticsBuffer."Analysis - Quantity");    end;    local procedure CalcUnitPrice(var ItemStatisticsBuf: Record "Item Statistics Buffer"): Decimal    var        Item: Record Item;        SalesLine: Record "Sales Line";        TempPriceListLine: Record "Price List Line" temporary;        PriceCalculationMgt: Codeunit "Price Calculation Mgt.";        LineWithPrice: Interface "Line With Price";        PriceCalculation: interface "Price Calculation";        PriceType: Enum "Price Type";    begin        if Item.Get(CopyStr(ItemStatisticsBuf.GetFilter("Item Filter"), 1, MaxStrLen(Item."No."))) then begin            SalesLine.Type := SalesLine.Type::Item;            SalesLine."No." := Item."No.";            SalesLine."Posting Date" := ItemStatisticsBuf.GetRangeMin("Date Filter");            SalesLine.GetLineWithPrice(LineWithPrice);            LineWithPrice.SetLine(PriceType::Sale, SalesLine);            PriceCalculationMgt.GetHandler(LineWithPrice, PriceCalculation);            PriceCalculation.FindPrice(TempPriceListLine, false);            OnCalcUnitPriceOnBeforeReturnUnitPrice(TempPriceListLine, Item);            exit(TempPriceListLine."Unit Price");        end    end;    local procedure CalcStdCost(var ItemStatisticsBuf: Record "Item Statistics Buffer"): Decimal    var        Item: Record Item;    begin        if Item.Get(CopyStr(ItemStatisticsBuf.GetFilter("Item Filter"), 1, MaxStrLen(Item."No."))) then            exit(Item."Standard Cost");    end;    local procedure CalcIndirectCost(var ItemStatisticsBuf: Record "Item Statistics Buffer") Result: Decimal    var        Item: Record Item;    begin        if Item.Get(CopyStr(ItemStatisticsBuf.GetFilter("Item Filter"), 1, MaxStrLen(Item."No."))) then            Result := Item."Indirect Cost %";        OnAfterCalcIndirectCost(ItemStatisticsBuf, Item, Result);    end;    local procedure CalcUnitCost(var ItemStatisticsBuf: Record "Item Statistics Buffer"): Decimal    var        Item: Record Item;    begin        if Item.Get(CopyStr(ItemStatisticsBuf.GetFilter("Item Filter"), 1, MaxStrLen(Item."No."))) then            exit(Item."Unit Cost");    end;    local procedure CalcBudgetSalesAmount(var ItemStatisticsBuf: Record "Item Statistics Buffer"): Decimal    begin        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange(ItemStatisticsBuf."Source Type Filter")        else            ItemStatisticsBuf.SetRange(ItemStatisticsBuf."Item Ledger Entry Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            ItemStatisticsBuf.CalcFields(ItemStatisticsBuf."Budgeted Sales Amount");            exit(ItemStatisticsBuf."Budgeted Sales Amount");        end;        ItemStatisticsBuf.CalcFields(ItemStatisticsBuf."Analysis - Budgeted Sales Amt.");        exit(ItemStatisticsBuf."Analysis - Budgeted Sales Amt.");    end;    local procedure CalcBudgetCostAmount(var ItemStatisticsBuf: Record "Item Statistics Buffer"): Decimal    begin        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange(ItemStatisticsBuf."Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            ItemStatisticsBuf.CalcFields(ItemStatisticsBuf."Budgeted Cost Amount");            exit(ItemStatisticsBuf."Budgeted Cost Amount");        end;        ItemStatisticsBuf.CalcFields(ItemStatisticsBuf."Analysis - Budgeted Cost Amt.");        exit(ItemStatisticsBuf."Analysis - Budgeted Cost Amt.");    end;    local procedure CalcBudgetQuantity(var ItemStatisticsBuffer: Record "Item Statistics Buffer") Result: Decimal    var        IsHandled: Boolean;    begin        OnBeforeCalcBudgetQuantity(ItemStatisticsBuffer, IsHandled, Result);        if IsHandled then            exit(Result);        if ItemStatisticsBuffer.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuffer.SetRange(ItemStatisticsBuffer."Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            ItemStatisticsBuffer.CalcFields(ItemStatisticsBuffer."Budgeted Quantity");            exit(ItemStatisticsBuffer."Budgeted Quantity");        end;        ItemStatisticsBuffer.CalcFields(ItemStatisticsBuffer."Analysis - Budgeted Quantity");        exit(ItemStatisticsBuffer."Analysis - Budgeted Quantity");    end;    local procedure DrillDownSalesAmount(var ItemStatisticsBuf: Record "Item Statistics Buffer"; Invoiced: Boolean)    var        ValueEntry: Record "Value Entry";        ItemAnalysisViewEntry: Record "Item Analysis View Entry";    begin        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange(ItemStatisticsBuf."Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            FilterValueEntry(ItemStatisticsBuf, ValueEntry);            if Invoiced then                PAGE.Run(0, ValueEntry, ValueEntry."Sales Amount (Actual)")            else                PAGE.Run(0, ValueEntry, ValueEntry."Sales Amount (Expected)");        end else begin            FilterItemAnalyViewEntry(ItemStatisticsBuf, ItemAnalysisViewEntry);            if Invoiced then                PAGE.Run(0, ItemAnalysisViewEntry, ItemAnalysisViewEntry."Sales Amount (Actual)")            else                PAGE.Run(0, ItemAnalysisViewEntry, ItemAnalysisViewEntry."Sales Amount (Expected)");        end;    end;    local procedure DrillDownCostAmount(var ItemStatisticsBuf: Record "Item Statistics Buffer"; Invoiced: Boolean)    var        ValueEntry: Record "Value Entry";        ItemAnalysisViewEntry: Record "Item Analysis View Entry";    begin        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange(ItemStatisticsBuf."Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            FilterValueEntry(ItemStatisticsBuf, ValueEntry);            if Invoiced then                PAGE.Run(0, ValueEntry, ValueEntry."Cost Amount (Actual)")            else                PAGE.Run(0, ValueEntry, ValueEntry."Cost Amount (Expected)");        end else begin            FilterItemAnalyViewEntry(ItemStatisticsBuf, ItemAnalysisViewEntry);            if Invoiced then                PAGE.Run(0, ItemAnalysisViewEntry, ItemAnalysisViewEntry."Cost Amount (Actual)")            else                PAGE.Run(0, ItemAnalysisViewEntry, ItemAnalysisViewEntry."Cost Amount (Expected)");        end;    end;    local procedure DrillDownCostAmountNonInvnt(var ItemStatisticsBuf: Record "Item Statistics Buffer"; Invoiced: Boolean)    var        ValueEntry: Record "Value Entry";        ItemAnalysisViewEntry: Record "Item Analysis View Entry";    begin        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange(ItemStatisticsBuf."Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            FilterValueEntry(ItemStatisticsBuf, ValueEntry);            if Invoiced then                PAGE.Run(0, ValueEntry, ValueEntry."Cost Amount (Non-Invtbl.)");        end else begin            FilterItemAnalyViewEntry(ItemStatisticsBuf, ItemAnalysisViewEntry);            if Invoiced then                PAGE.Run(0, ItemAnalysisViewEntry, ItemAnalysisViewEntry."Cost Amount (Non-Invtbl.)")        end;    end;    local procedure DrillDownQuantity(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; Invoiced: Boolean)    var        ValueEntry: Record "Value Entry";        ItemLedgerEntry: Record "Item Ledger Entry";        ItemAnalysisViewEntry: Record "Item Analysis View Entry";        IsHandled: Boolean;    begin        OnBeforeDrillDownQuantity(ItemStatisticsBuffer, Invoiced, IsHandled);        if IsHandled then            exit;        if ItemStatisticsBuffer.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuffer.SetRange(ItemStatisticsBuffer."Source Type Filter");        ItemStatisticsBuffer.SetRange(ItemStatisticsBuffer."Entry Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            if Invoiced then begin                FilterValueEntry(ItemStatisticsBuffer, ValueEntry);                Page.Run(0, ValueEntry, ValueEntry."Invoiced Quantity");            end else begin                FilterItemLedgEntry(ItemStatisticsBuffer, ItemLedgerEntry);                Page.Run(0, ItemLedgerEntry, ItemLedgerEntry.Quantity);            end;        end else begin            FilterItemAnalyViewEntry(ItemStatisticsBuffer, ItemAnalysisViewEntry);            if Invoiced then                Page.Run(0, ItemAnalysisViewEntry, ItemAnalysisViewEntry."Invoiced Quantity")            else                Page.Run(0, ItemAnalysisViewEntry, ItemAnalysisViewEntry.Quantity);        end;    end;    local procedure DrillDownUnitPrice(var ItemStatisticsBuf: Record "Item Statistics Buffer")    var        Item: Record Item;        SalesLine: Record "Sales Line";        TempPriceListLine: Record "Price List Line" temporary;        PriceCalculationMgt: Codeunit "Price Calculation Mgt.";        LineWithPrice: Interface "Line With Price";        PriceCalculation: Interface "Price Calculation";        PriceType: Enum "Price Type";    begin        if Item.Get(CopyStr(ItemStatisticsBuf.GetFilter("Item Filter"), 1, MaxStrLen(Item."No."))) then begin            SalesLine.Type := SalesLine.Type::Item;            SalesLine."No." := Item."No.";            SalesLine."Posting Date" := ItemStatisticsBuf.GetRangeMin("Date Filter");            SalesLine.GetLineWithPrice(LineWithPrice);            LineWithPrice.SetLine(PriceType::Sale, SalesLine);            PriceCalculationMgt.GetHandler(LineWithPrice, PriceCalculation);            if PriceCalculation.FindPrice(TempPriceListLine, false) then                PriceCalculation.ShowPrices(TempPriceListLine)            else begin                ItemStatisticsBuf.CopyFilter("Item Filter", Item."No.");                PAGE.RunModal(PAGE::"Item Card", Item, Item."Unit Price");            end;        end;    end;    local procedure DrillDownStdCost(var ItemStatisticsBuf: Record "Item Statistics Buffer")    var        Item: Record Item;    begin        ItemStatisticsBuf.CopyFilter("Item Filter", Item."No.");        PAGE.RunModal(PAGE::"Item Card", Item, Item."Standard Cost");    end;    local procedure DrillDownIndirectCost(var ItemStatisticsBuf: Record "Item Statistics Buffer")    var        Item: Record Item;    begin        ItemStatisticsBuf.CopyFilter("Item Filter", Item."No.");        PAGE.RunModal(PAGE::"Item Card", Item, Item."Indirect Cost %");    end;    local procedure DrillDownUnitCost(var ItemStatisticsBuf: Record "Item Statistics Buffer")    var        Item: Record Item;    begin        ItemStatisticsBuf.CopyFilter("Item Filter", Item."No.");        PAGE.RunModal(PAGE::"Item Card", Item, Item."Unit Cost");    end;    local procedure DrillDownBudgetSalesAmount(var ItemStatisticsBuf: Record "Item Statistics Buffer")    var        ItemBudgetEntry: Record "Item Budget Entry";        ItemAnalysisViewBudgEntry: Record "Item Analysis View Budg. Entry";    begin        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange(ItemStatisticsBuf."Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            FilterItemBudgetEntry(ItemStatisticsBuf, ItemBudgetEntry);            PAGE.Run(0, ItemBudgetEntry, ItemBudgetEntry."Sales Amount");        end else begin            FilterItemAnalyViewBudgEntry(ItemStatisticsBuf, ItemAnalysisViewBudgEntry);            PAGE.Run(0, ItemAnalysisViewBudgEntry, ItemAnalysisViewBudgEntry."Sales Amount");        end;    end;    local procedure DrillDownBudgetCostAmount(var ItemStatisticsBuf: Record "Item Statistics Buffer")    var        ItemBudgetEntry: Record "Item Budget Entry";        ItemAnalysisViewBudgEntry: Record "Item Analysis View Budg. Entry";    begin        if ItemStatisticsBuf.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuf.SetRange(ItemStatisticsBuf."Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            FilterItemBudgetEntry(ItemStatisticsBuf, ItemBudgetEntry);            PAGE.Run(0, ItemBudgetEntry, ItemBudgetEntry."Cost Amount");        end else begin            FilterItemAnalyViewBudgEntry(ItemStatisticsBuf, ItemAnalysisViewBudgEntry);            PAGE.Run(0, ItemAnalysisViewBudgEntry, ItemAnalysisViewBudgEntry."Cost Amount");        end;    end;    local procedure DrillDownBudgetQuantity(var ItemStatisticsBuffer: Record "Item Statistics Buffer")    var        ItemBudgetEntry: Record "Item Budget Entry";        ItemAnalysisViewBudgEntry: Record "Item Analysis View Budg. Entry";        IsHandled: Boolean;    begin        OnBeforeDrillDownBudgetQuantity(ItemStatisticsBuffer, IsHandled);        if IsHandled then            exit;        if ItemStatisticsBuffer.GetFilter("Source No. Filter") = '' then            ItemStatisticsBuffer.SetRange(ItemStatisticsBuffer."Source Type Filter");        if AnalysisLineTemplate."Item Analysis View Code" = '' then begin            FilterItemBudgetEntry(ItemStatisticsBuffer, ItemBudgetEntry);            Page.Run(0, ItemBudgetEntry, ItemBudgetEntry.Quantity);        end else begin            FilterItemAnalyViewBudgEntry(ItemStatisticsBuffer, ItemAnalysisViewBudgEntry);            Page.Run(0, ItemAnalysisViewBudgEntry, ItemAnalysisViewBudgEntry.Quantity);        end;    end;    local procedure FilterValueEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ValueEntry: Record "Value Entry")    begin        if ItemStatisticsBuf.GetFilter("Item Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Item Filter", ValueEntry."Item No.");        if ItemStatisticsBuf.GetFilter("Date Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Date Filter", ValueEntry."Posting Date");        if ItemStatisticsBuf.GetFilter("Entry Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Entry Type Filter", ValueEntry."Entry Type");        if ItemStatisticsBuf.GetFilter("Item Ledger Entry Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Item Ledger Entry Type Filter", ValueEntry."Item Ledger Entry Type");        if ItemStatisticsBuf.GetFilter("Location Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Location Filter", ValueEntry."Location Code");        if ItemStatisticsBuf.GetFilter("Global Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 1 Filter", ValueEntry."Global Dimension 1 Code");        if ItemStatisticsBuf.GetFilter("Global Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 2 Filter", ValueEntry."Global Dimension 2 Code");        if ItemStatisticsBuf.GetFilter("Source Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Source Type Filter", ValueEntry."Source Type");        ItemStatisticsBuf.FilterGroup := 2;        ValueEntry.FilterGroup := 2;        if ItemStatisticsBuf.GetFilter("Global Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 1 Filter", ValueEntry."Global Dimension 1 Code");        if ItemStatisticsBuf.GetFilter("Global Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 2 Filter", ValueEntry."Global Dimension 2 Code");        ItemStatisticsBuf.FilterGroup := 0;        ValueEntry.FilterGroup := 0;        if ItemStatisticsBuf.GetFilter("Source No. Filter") <> '' then begin            ValueEntry.SetCurrentKey("Source Type", "Source No.");            ItemStatisticsBuf.CopyFilter("Source No. Filter", ValueEntry."Source No.");        end else            ValueEntry.SetCurrentKey("Item No.", "Posting Date");        OnAfterFilterValueEntry(ItemStatisticsBuf, ValueEntry);    end;    local procedure FilterItemLedgEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ItemLedgEntry: Record "Item Ledger Entry")    begin        if ItemStatisticsBuf.GetFilter("Item Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Item Filter", ItemLedgEntry."Item No.");        if ItemStatisticsBuf.GetFilter("Date Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Date Filter", ItemLedgEntry."Posting Date");        if ItemStatisticsBuf.GetFilter("Item Ledger Entry Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Item Ledger Entry Type Filter", ItemLedgEntry."Entry Type");        if ItemStatisticsBuf.GetFilter("Location Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Location Filter", ItemLedgEntry."Location Code");        if ItemStatisticsBuf.GetFilter("Global Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 1 Filter", ItemLedgEntry."Global Dimension 1 Code");        if ItemStatisticsBuf.GetFilter("Global Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 2 Filter", ItemLedgEntry."Global Dimension 2 Code");        if ItemStatisticsBuf.GetFilter("Source Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Source Type Filter", ItemLedgEntry."Source Type");        ItemStatisticsBuf.FilterGroup := 2;        ItemLedgEntry.FilterGroup := 2;        if ItemStatisticsBuf.GetFilter("Global Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 1 Filter", ItemLedgEntry."Global Dimension 1 Code");        if ItemStatisticsBuf.GetFilter("Global Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 2 Filter", ItemLedgEntry."Global Dimension 2 Code");        ItemStatisticsBuf.FilterGroup := 0;        ItemLedgEntry.FilterGroup := 0;        if ItemStatisticsBuf.GetFilter("Source No. Filter") <> '' then begin            ItemLedgEntry.SetCurrentKey("Source Type", "Source No.");            ItemStatisticsBuf.CopyFilter("Source No. Filter", ItemLedgEntry."Source No.");        end else            ItemLedgEntry.SetCurrentKey("Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date");        OnAfterFilterItemLedgEntry(ItemStatisticsBuf, ItemLedgEntry);    end;    local procedure FilterItemBudgetEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ItemBudgetEntry: Record "Item Budget Entry")    begin        ItemStatisticsBuf.CopyFilter("Analysis Area Filter", ItemBudgetEntry."Analysis Area");        ItemStatisticsBuf.CopyFilter("Budget Filter", ItemBudgetEntry."Budget Name");        if ItemStatisticsBuf.GetFilter("Item Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Item Filter", ItemBudgetEntry."Item No.");        if ItemStatisticsBuf.GetFilter("Date Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Date Filter", ItemBudgetEntry.Date);        if ItemStatisticsBuf.GetFilter("Global Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 1 Filter", ItemBudgetEntry."Global Dimension 1 Code");        if ItemStatisticsBuf.GetFilter("Global Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 2 Filter", ItemBudgetEntry."Global Dimension 2 Code");        if ItemStatisticsBuf.GetFilter("Source Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Source Type Filter", ItemBudgetEntry."Source Type");        ItemStatisticsBuf.FilterGroup := 2;        ItemBudgetEntry.FilterGroup := 2;        if ItemStatisticsBuf.GetFilter("Global Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 1 Filter", ItemBudgetEntry."Global Dimension 1 Code");        if ItemStatisticsBuf.GetFilter("Global Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Global Dimension 2 Filter", ItemBudgetEntry."Global Dimension 2 Code");        ItemStatisticsBuf.FilterGroup := 0;        ItemBudgetEntry.FilterGroup := 0;        if ItemStatisticsBuf.GetFilter("Source No. Filter") <> '' then begin            ItemBudgetEntry.SetCurrentKey("Analysis Area", "Budget Name", "Source Type", "Source No.");            ItemStatisticsBuf.CopyFilter("Source No. Filter", ItemBudgetEntry."Source No.");        end else            ItemBudgetEntry.SetCurrentKey("Analysis Area", "Budget Name", "Item No.");        OnAfterFilterItemBudgetEntry(ItemStatisticsBuf, ItemBudgetEntry);    end;    local procedure FilterItemAnalyViewEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ItemAnalysisViewEntry: Record "Item Analysis View Entry")    begin        ItemStatisticsBuf.CopyFilter("Analysis Area Filter", ItemAnalysisViewEntry."Analysis Area");        ItemStatisticsBuf.CopyFilter("Analysis View Filter", ItemAnalysisViewEntry."Analysis View Code");        if ItemStatisticsBuf.GetFilter("Item Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Item Filter", ItemAnalysisViewEntry."Item No.");        if ItemStatisticsBuf.GetFilter("Date Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Date Filter", ItemAnalysisViewEntry."Posting Date");        if ItemStatisticsBuf.GetFilter("Entry Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Entry Type Filter", ItemAnalysisViewEntry."Entry Type");        if ItemStatisticsBuf.GetFilter("Item Ledger Entry Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Item Ledger Entry Type Filter", ItemAnalysisViewEntry."Item Ledger Entry Type");        if ItemStatisticsBuf.GetFilter("Location Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Location Filter", ItemAnalysisViewEntry."Location Code");        if ItemStatisticsBuf.GetFilter("Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 1 Filter", ItemAnalysisViewEntry."Dimension 1 Value Code");        if ItemStatisticsBuf.GetFilter("Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 2 Filter", ItemAnalysisViewEntry."Dimension 2 Value Code");        if ItemStatisticsBuf.GetFilter("Dimension 3 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 3 Filter", ItemAnalysisViewEntry."Dimension 3 Value Code");        if ItemStatisticsBuf.GetFilter("Source Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Source Type Filter", ItemAnalysisViewEntry."Source Type");        if ItemStatisticsBuf.GetFilter("Source No. Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Source No. Filter", ItemAnalysisViewEntry."Source No.");        ItemStatisticsBuf.FilterGroup := 2;        ItemAnalysisViewEntry.FilterGroup := 2;        if ItemStatisticsBuf.GetFilter("Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 1 Filter", ItemAnalysisViewEntry."Dimension 1 Value Code");        if ItemStatisticsBuf.GetFilter("Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 2 Filter", ItemAnalysisViewEntry."Dimension 2 Value Code");        if ItemStatisticsBuf.GetFilter("Dimension 3 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 3 Filter", ItemAnalysisViewEntry."Dimension 3 Value Code");        ItemStatisticsBuf.FilterGroup := 0;        ItemAnalysisViewEntry.FilterGroup := 0;        OnAfterFilterItemAnalyViewEntry(ItemStatisticsBuf, ItemAnalysisViewEntry);    end;    local procedure FilterItemAnalyViewBudgEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ItemAnalysisViewBudgEntry: Record "Item Analysis View Budg. Entry")    begin        ItemStatisticsBuf.CopyFilter("Analysis Area Filter", ItemAnalysisViewBudgEntry."Analysis Area");        ItemStatisticsBuf.CopyFilter("Analysis View Filter", ItemAnalysisViewBudgEntry."Analysis View Code");        ItemStatisticsBuf.CopyFilter("Budget Filter", ItemAnalysisViewBudgEntry."Budget Name");        if ItemStatisticsBuf.GetFilter("Item Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Item Filter", ItemAnalysisViewBudgEntry."Item No.");        if ItemStatisticsBuf.GetFilter("Date Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Date Filter", ItemAnalysisViewBudgEntry."Posting Date");        if ItemStatisticsBuf.GetFilter("Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 1 Filter", ItemAnalysisViewBudgEntry."Dimension 1 Value Code");        if ItemStatisticsBuf.GetFilter("Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 2 Filter", ItemAnalysisViewBudgEntry."Dimension 2 Value Code");        if ItemStatisticsBuf.GetFilter("Dimension 3 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 3 Filter", ItemAnalysisViewBudgEntry."Dimension 3 Value Code");        if ItemStatisticsBuf.GetFilter("Source Type Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Source Type Filter", ItemAnalysisViewBudgEntry."Source Type");        if ItemStatisticsBuf.GetFilter("Source No. Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Source No. Filter", ItemAnalysisViewBudgEntry."Source No.");        ItemStatisticsBuf.FilterGroup := 2;        ItemAnalysisViewBudgEntry.FilterGroup := 2;        if ItemStatisticsBuf.GetFilter("Dimension 1 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 1 Filter", ItemAnalysisViewBudgEntry."Dimension 1 Value Code");        if ItemStatisticsBuf.GetFilter("Dimension 2 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 2 Filter", ItemAnalysisViewBudgEntry."Dimension 2 Value Code");        if ItemStatisticsBuf.GetFilter("Dimension 3 Filter") <> '' then            ItemStatisticsBuf.CopyFilter("Dimension 3 Filter", ItemAnalysisViewBudgEntry."Dimension 3 Value Code");        ItemStatisticsBuf.FilterGroup := 0;        ItemAnalysisViewBudgEntry.FilterGroup := 0;        OnAfterFilterItemAnalyViewBudgEntry(ItemStatisticsBuf, ItemAnalysisViewBudgEntry);    end;    local procedure SetGroupDimFilter(var ItemStatisticsBuf: Record "Item Statistics Buffer"; GroupDimCode: Code[20]; DimValueFilter: Text[250])    var        ItemAnalysisView: Record "Item Analysis View";    begin        if AnalysisLineTemplate."Item Analysis View Code" <> '' then begin            ItemAnalysisView.Get(AnalysisLineTemplate."Analysis Area", AnalysisLineTemplate."Item Analysis View Code");            case GroupDimCode of                '':                    exit;                ItemAnalysisView."Dimension 1 Code":                    ItemStatisticsBuf.SetFilter("Dimension 1 Filter", DimValueFilter);                ItemAnalysisView."Dimension 2 Code":                    ItemStatisticsBuf.SetFilter("Dimension 2 Filter", DimValueFilter);                ItemAnalysisView."Dimension 3 Code":                    ItemStatisticsBuf.SetFilter("Dimension 3 Filter", DimValueFilter);                else                    Error(Text022,                      AnalysisLineTemplate.FieldCaption("Item Analysis View Code"),                      AnalysisLineTemplate.TableCaption(),                      AnalysisLineTemplate."Analysis Area",                      AnalysisLineTemplate.Name,                      GroupDimCode);            end;        end else begin            GLSetup.Get();            case GroupDimCode of                '':                    exit;                GLSetup."Global Dimension 1 Code":                    ItemStatisticsBuf.SetFilter("Global Dimension 1 Filter", DimValueFilter);                GLSetup."Global Dimension 2 Code":                    ItemStatisticsBuf.SetFilter("Global Dimension 2 Filter", DimValueFilter);                else                    Error(Text022,                      AnalysisLineTemplate.FieldCaption("Item Analysis View Code"),                      AnalysisLineTemplate.TableCaption(),                      AnalysisLineTemplate."Analysis Area",                      AnalysisLineTemplate.Name,                      GroupDimCode);            end;        end;    end;    local procedure FilterToValue(var AnalysisLine: Record "Analysis Line"): Enum "Analysis Source Type"    var        AnalysisLine2: Record "Analysis Line";    begin        for AnalysisLine2."Source Type Filter" := AnalysisLine2."Source Type Filter"::" " to AnalysisLine2."Source Type Filter"::Item do            if AnalysisLine.GetFilter("Source Type Filter") = Format(AnalysisLine2."Source Type Filter") then                exit(AnalysisLine2."Source Type Filter");    end;    local procedure GetSalesSetup()    begin        if SalesSetupRead then            exit;        SalesSetup.Get();        SalesSetupRead := true;    end;    local procedure GetInventorySetup()    begin        if InventorySetupRead then            exit;        InventorySetup.Get();        InventorySetupRead := true;    end;    procedure SetExpression(Expression: Text[250])    begin        TryExpression := Expression;    end;    local procedure IsValidAnalysisExpression(var AnalysisLine: Record "Analysis Line"; Expression: Text[250]): Boolean    var        AnalysisReportMgt: Codeunit "Analysis Report Management";    begin        AnalysisReportMgt.SetExpression(Expression);        if AnalysisReportMgt.Run(AnalysisLine) then            exit(true);        exit(false);    end;    procedure ValidateFilter(var "Filter": Text; RecNo: Integer; FieldNumber: Integer; ConvertToNumbers: Boolean)    var        AnalysisColumn: Record "Analysis Column";        AnalysisType: Record "Analysis Type";        ItemStatisticsBuffer: Record "Item Statistics Buffer";    begin        OnBeforeValidateFilter(Filter, RecNo, FieldNumber);        case RecNo of            DATABASE::"Analysis Column":                case FieldNumber of                    AnalysisColumn.FieldNo("Item Ledger Entry Type Filter"):                        begin                            ItemStatisticsBuffer.SetFilter("Item Ledger Entry Type Filter", Filter);                            Filter := ItemStatisticsBuffer.GetFilter("Item Ledger Entry Type Filter");                        end;                    AnalysisColumn.FieldNo("Value Entry Type Filter"):                        begin                            ItemStatisticsBuffer.SetFilter("Entry Type Filter", Filter);                            Filter := ItemStatisticsBuffer.GetFilter("Entry Type Filter");                        end;                end;            DATABASE::"Analysis Type":                case FieldNumber of                    AnalysisType.FieldNo("Item Ledger Entry Type Filter"):                        begin                            ItemStatisticsBuffer.SetFilter("Item Ledger Entry Type Filter", Filter);                            Filter := ItemStatisticsBuffer.GetFilter("Item Ledger Entry Type Filter");                        end;                    AnalysisType.FieldNo("Value Entry Type Filter"):                        begin                            ItemStatisticsBuffer.SetFilter("Entry Type Filter", Filter);                            Filter := ItemStatisticsBuffer.GetFilter("Entry Type Filter");                        end;                end;        end;        if ConvertToNumbers then            ConvertOptionNameToNo(Filter, RecNo, FieldNumber);    end;    local procedure ConvertOptionNameToNo(var "Filter": Text; RecNo: Integer; FieldNumber: Integer)    var        AnalysisColumn: Record "Analysis Column";        AnalysisType: Record "Analysis Type";        VarInteger: Integer;        OptionNo: Integer;        OptionName: Text[30];    begin        while true do begin            case RecNo of                DATABASE::"Analysis Column":                    case FieldNumber of                        AnalysisColumn.FieldNo("Item Ledger Entry Type Filter"):                            OptionName := Format(Enum::"Item Ledger Entry Type".FromInteger(OptionNo));                        AnalysisColumn.FieldNo("Value Entry Type Filter"):                            OptionName := Format(Enum::"Cost Entry Type".FromInteger(OptionNo));                    end;                DATABASE::"Analysis Type":                    case FieldNumber of                        AnalysisType.FieldNo("Item Ledger Entry Type Filter"):                            OptionName := Format(Enum::"Item Ledger Entry Type".FromInteger(OptionNo));                        AnalysisType.FieldNo("Value Entry Type Filter"):                            OptionName := Format(Enum::"Cost Entry Type".FromInteger(OptionNo));                    end;            end;            if Evaluate(VarInteger, OptionName) then                if VarInteger = OptionNo then                    exit;            FindAndReplace(Filter, OptionName, Format(OptionNo));            OptionNo += 1;        end;    end;    local procedure FindAndReplace(var "Filter": Text; FindWhat: Text[30]; ReplaceWith: Text[30])    var        Position: Integer;    begin        while true do begin            Position := StrPos(Filter, FindWhat);            if Position = 0 then                exit;            Filter := InsStr(DelStr(Filter, Position, StrLen(FindWhat)), ReplaceWith, Position);        end;    end;    local procedure GetSourceNoFilter(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var AnalysisLine: Record "Analysis Line"): Text    begin        case FilterToValue(AnalysisLine) of            AnalysisLine."Source Type Filter"::Item:                exit(DelChr(StrSubstNo('%1&%2',                      ItemStatisticsBuf.GetFilter("Item Filter"), AnalysisLine.GetFilter("Source No. Filter")), '<>', '&'));            else                exit(DelChr(StrSubstNo('%1&%2',                      ItemStatisticsBuf.GetFilter("Source No. Filter"), AnalysisLine.GetFilter("Source No. Filter")), '<>', '&'));        end;    end;    local procedure CalcFieldError(RowNo: Integer; ColumnNo: Integer) ErrorText: Text    var        AllErrorType: Boolean;    begin        TempAnalysisFieldValue.SetRange("Row Ref. No.", RowNo);        TempAnalysisFieldValue.SetRange("Column No.", ColumnNo);        if TempAnalysisFieldValue.FindFirst() then begin            AllErrorType :=              TempAnalysisFieldValue."Has Error" and              TempAnalysisFieldValue."Period Error" and              TempAnalysisFieldValue."Formula Error" and              TempAnalysisFieldValue."Cyclic Error";            if AllErrorType then                exit(Format(ShowError::All));            if TempAnalysisFieldValue."Has Error" then                ErrorText := Format(ShowError::"Division by Zero") + SeparatorTok;            if TempAnalysisFieldValue."Period Error" then                ErrorText := Format(ShowError::"Period Error") + SeparatorTok;            if TempAnalysisFieldValue."Formula Error" then                ErrorText := Format(ShowError::"Invalid Formula") + SeparatorTok;            if TempAnalysisFieldValue."Cyclic Error" then                ErrorText := Format(ShowError::"Cyclic Formula") + SeparatorTok;            ErrorText := DelChr(ErrorText, '>', SeparatorTok);        end;        TempAnalysisFieldValue.SetRange("Row Ref. No.");        TempAnalysisFieldValue.SetRange("Column No.");    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCalcItemStatistics(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var AnalysisLine: Record "Analysis Line"; var AnalysisColumn: Record "Analysis Column"; DrillDown: Boolean; var ColValue: Decimal);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCalcIndirectCost(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; Item: Record Item; var Result: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFilterItemAnalyViewEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ItemAnalysisViewEntry: Record "Item Analysis View Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFilterItemAnalyViewBudgEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ItemAnalysisViewBudgEntry: Record "Item Analysis View Budg. Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFilterItemBudgetEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ItemBudgetEntry: Record "Item Budget Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFilterItemLedgEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ItemLedgEntry: Record "Item Ledger Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFilterValueEntry(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var ValueEntry: Record "Value Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetItemColumnFilters(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; var AnalysisColumn: Record "Analysis Column")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetItemRowFilters(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var AnalysisLine: Record "Analysis Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateFilter(var FilterText: Text; RecNo: Integer; FieldNumber: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcItemStatisticsOnAfterSetFilters(var ItemStatisticsBuf: Record "Item Statistics Buffer"; var AnalysisLine: Record "Analysis Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcUnitPriceOnBeforeReturnUnitPrice(var TempPriceListLine: Record "Price List Line"; Item: Record Item)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeOpenAnalysisLinesForm(var AnalysisLine2: Record "Analysis Line"; CurrentAnalysisLineTempl: Code[10]; var IsHandled: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeOpenAnalysisColumnsForm(var AnalysisLine: Record "Analysis Line"; CurrentColumnTempl: Code[10]; var IsHandled: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterOpenColumns(var CurrentColumnTempl: Code[10]; var AnalysisLine: Record "Analysis Line"; var AnalysisColumn: Record "Analysis Column");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCopyColumnsToTempOnBeforeAnalysisColumnFindset(var AnalysisColumn: Record "Analysis Column"; ColumnName: Code[10]);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDoLookupSourceNoOnElseCurrentSourceTypeFilter(CurrentSourceTypeFilter: Enum "Analysis Source Type"; var CurrentSourceTypeNoFilter: Text)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcSalesAmount(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; Invoiced: Boolean; var IsHandled: Boolean; var Result: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcQuantity(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; Invoiced: Boolean; var IsHandled: Boolean; var Result: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcBudgetQuantity(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; var IsHandled: Boolean; var Result: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeDrillDownQuantity(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; Invoiced: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeDrillDownBudgetQuantity(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; var IsHandled: Boolean)    begin    end;}