Page 9209 Invt. Analys by Dim. Matrix

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/InvtAnalysbyDimMatrix.Page.al753 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 System.Text;page 9209 "Invt. Analys by Dim. Matrix"{    Caption = 'Invt. Analys by Dim. Matrix';    DataCaptionExpression = CurrentItemAnalysisViewCode;    Editable = false;    LinksAllowed = false;    PageType = List;    SourceTable = "Dimension Code Buffer";    layout    {        area(content)        {            repeater(Control1)            {                IndentationColumn = NameIndent;                IndentationControls = Name;                ShowCaption = false;                field("Code"; Rec.Code)                {                    ApplicationArea = Suite;                    StyleExpr = 'Strong';                    ToolTip = 'Specifies the code of the record.';                    trigger OnLookup(var Text: Text): Boolean                    begin                        ItemAnalysisMgt.LookupDimCode(LineDimType, LineDimCode, Rec.Code);                    end;                }                field(Name; Rec.Name)                {                    ApplicationArea = Suite;                    StyleExpr = 'Strong';                    ToolTip = 'Specifies the name of the record.';                }                field(TotalQuantity; Rec.Quantity)                {                    ApplicationArea = Suite;                    BlankZero = true;                    Caption = 'Total Quantity';                    StyleExpr = 'Strong';                    ToolTip = 'Specifies the total quantity of the item that is currently in inventory. The Total Quantity field is used to calculate the Available Inventory field as follows: Available Inventory = Total Quantity - Reserved Quantity.';                    trigger OnDrillDown()                    begin                        ItemAnalysisMgt.DrillDownAmount(                          CurrentAnalysisArea, ItemStatisticsBuffer, CurrentItemAnalysisViewCode,                          ItemFilter, LocationFilter, DateFilter,                          Dim1Filter, Dim2Filter, Dim3Filter, BudgetFilter,                          LineDimType, Rec,                          ColumnDimType, MatrixRecord,                          false, "Item Analysis Value Type"::Quantity, ShowActualBudget);                        // Line with .. ColumnDimOption,MatrixRecord, might be wrong...                    end;                }                field(TotalInvtValue; Rec.Amount)                {                    ApplicationArea = Suite;                    BlankZero = true;                    Caption = 'Total Inventory Value';                    StyleExpr = 'Strong';                    ToolTip = 'Specifies the value of the total quantity in inventory.';                    trigger OnDrillDown()                    begin                        ItemAnalysisMgt.DrillDownAmount(                          CurrentAnalysisArea, ItemStatisticsBuffer, CurrentItemAnalysisViewCode,                          ItemFilter, LocationFilter, DateFilter,                          Dim1Filter, Dim2Filter, Dim3Filter, BudgetFilter,                          LineDimType, Rec,                          ColumnDimType, Rec,                          false, "Item Analysis Value Type"::"Cost Amount", ShowActualBudget);                        // Line with might be wrong... ColumnDimOption,Rec,                    end;                }                field(Field1; MATRIX_CellData[1])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[1];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(1);                    end;                }                field(Field2; MATRIX_CellData[2])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[2];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(2);                    end;                }                field(Field3; MATRIX_CellData[3])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[3];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(3);                    end;                }                field(Field4; MATRIX_CellData[4])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[4];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(4);                    end;                }                field(Field5; MATRIX_CellData[5])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[5];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(5);                    end;                }                field(Field6; MATRIX_CellData[6])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[6];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(6);                    end;                }                field(Field7; MATRIX_CellData[7])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[7];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(7);                    end;                }                field(Field8; MATRIX_CellData[8])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[8];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(8);                    end;                }                field(Field9; MATRIX_CellData[9])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[9];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(9);                    end;                }                field(Field10; MATRIX_CellData[10])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[10];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(10);                    end;                }                field(Field11; MATRIX_CellData[11])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[11];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(11);                    end;                }                field(Field12; MATRIX_CellData[12])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[12];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(12);                    end;                }                field(Field13; MATRIX_CellData[13])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[13];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(13);                    end;                }                field(Field14; MATRIX_CellData[14])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[14];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(14);                    end;                }                field(Field15; MATRIX_CellData[15])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[15];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(15);                    end;                }                field(Field16; MATRIX_CellData[16])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[16];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(16);                    end;                }                field(Field17; MATRIX_CellData[17])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[17];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(17);                    end;                }                field(Field18; MATRIX_CellData[18])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[18];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(18);                    end;                }                field(Field19; MATRIX_CellData[19])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[19];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(19);                    end;                }                field(Field20; MATRIX_CellData[20])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[20];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(20);                    end;                }                field(Field21; MATRIX_CellData[21])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[21];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(21);                    end;                }                field(Field22; MATRIX_CellData[22])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[22];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(22);                    end;                }                field(Field23; MATRIX_CellData[23])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[23];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(23);                    end;                }                field(Field24; MATRIX_CellData[24])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[24];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(24);                    end;                }                field(Field25; MATRIX_CellData[25])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[25];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(25);                    end;                }                field(Field26; MATRIX_CellData[26])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[26];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(26);                    end;                }                field(Field27; MATRIX_CellData[27])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[27];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(27);                    end;                }                field(Field28; MATRIX_CellData[28])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[28];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(28);                    end;                }                field(Field29; MATRIX_CellData[29])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[29];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(29);                    end;                }                field(Field30; MATRIX_CellData[30])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[30];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(30);                    end;                }                field(Field31; MATRIX_CellData[31])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[31];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(31);                    end;                }                field(Field32; MATRIX_CellData[32])                {                    ApplicationArea = Suite;                    AutoFormatType = 1;                    AutoFormatExpression = '';                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_CaptionSet[32];                    StyleExpr = 'Strong';                    trigger OnDrillDown()                    begin                        MATRIX_OnDrillDown(32);                    end;                }            }        }    }    actions    {    }    trigger OnAfterGetCurrRecord()    begin        // IF CurrForm.TotalQuantity.VISIBLE THEN        Rec.Quantity := CalcAmt("Item Analysis Value Type"::Quantity, false);        // IF CurrForm.TotalInvtValue.VISIBLE THEN        Rec.Amount := CalcAmt("Item Analysis Value Type"::"Cost Amount", false);    end;    trigger OnAfterGetRecord()    var        MATRIX_CurrentColumnOrdinal: Integer;    begin        NameIndent := 0;        // IF CurrForm.TotalQuantity.VISIBLE THEN        Rec.Quantity := CalcAmt("Item Analysis Value Type"::Quantity, false);        // IF CurrForm.TotalQuantity.VISIBLE THEN        Rec.Amount := CalcAmt("Item Analysis Value Type"::"Cost Amount", false);        MATRIX_CurrentColumnOrdinal := 0;        while MATRIX_CurrentColumnOrdinal < MATRIX_CurrentNoOfMatrixColumn do begin            MATRIX_CurrentColumnOrdinal := MATRIX_CurrentColumnOrdinal + 1;            MATRIX_OnAfterGetRecord(MATRIX_CurrentColumnOrdinal);        end;        FormatLine();        QuantityOnFormat(Format(Rec.Quantity));        AmountOnFormat(Format(Rec.Amount));    end;    trigger OnFindRecord(Which: Text): Boolean    begin        exit(          ItemAnalysisMgt.FindRecord(            ItemAnalysisView, LineDimType, Rec, Which,            ItemFilter, LocationFilter, PeriodType, DateFilter, PeriodInitialized, InternalDateFilter,            Dim1Filter, Dim2Filter, Dim3Filter));    end;    trigger OnNextRecord(Steps: Integer): Integer    begin        exit(          ItemAnalysisMgt.NextRecord(            ItemAnalysisView, LineDimType, Rec, Steps,            ItemFilter, LocationFilter, PeriodType, DateFilter,            Dim1Filter, Dim2Filter, Dim3Filter));    end;    trigger OnOpenPage()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeOnOpenPage(CurrentAnalysisArea, CurrentItemAnalysisViewCode, ItemAnalysisView, ItemStatisticsBuffer, Dim1Filter, Dim2Filter, Dim3Filter, IsHandled);        if IsHandled then            exit;        CurrentAnalysisArea := CurrentAnalysisArea::Inventory;        GLSetup.Get();        ItemAnalysisMgt.AnalysisViewSelection(          CurrentAnalysisArea.AsInteger(), CurrentItemAnalysisViewCode, ItemAnalysisView, ItemStatisticsBuffer,          Dim1Filter, Dim2Filter, Dim3Filter);    end;    var        GLSetup: Record "General Ledger Setup";        ItemStatisticsBuffer: Record "Item Statistics Buffer";        MatrixRecords: array[32] of Record "Dimension Code Buffer";        MatrixRecord: Record "Dimension Code Buffer";        ItemAnalysisMgt: Codeunit "Item Analysis Management";        CurrentAnalysisArea: Enum "Analysis Area Type";        CurrentItemAnalysisViewCode: Code[10];        ItemFilter: Code[250];        LocationFilter: Code[250];        BudgetFilter: Code[250];        ValueType: Enum "Item Analysis Value Type";        ShowActualBudget: Enum "Item Analysis Show Type";        RoundingFactor: Enum "Analysis Rounding Factor";        LineDimType: Enum "Item Analysis Dimension Type";        ColumnDimType: Enum "Item Analysis Dimension Type";        PeriodType: Enum "Analysis Period Type";        Dim1Filter: Code[250];        Dim2Filter: Code[250];        Dim3Filter: Code[250];        LineDimCode: Text[30];        DateFilter: Text[30];        InternalDateFilter: Text[30];        PeriodInitialized: Boolean;        AnalysisValue: Decimal;        ShowOppositeSign: Boolean;        MATRIX_CurrentNoOfMatrixColumn: Integer;        MATRIX_CellData: array[32] of Decimal;        MATRIX_CaptionSet: array[32] of Text[80];        NameIndent: Integer;    protected var        ItemAnalysisView: Record "Item Analysis View";    local procedure CalcAmt(ValueType: Enum "Item Analysis Value Type"; SetColFilter: Boolean) Amt: Decimal    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcAmt(            Rec, ItemAnalysisView, LineDimType, ColumnDimType, MatrixRecord, SetColFilter,            ItemFilter, LocationFilter, DateFilter, ValueType, SetColFilter, ShowOppositeSign, Amt, IsHandled);        if IsHandled then            exit(Amt);        Amt := ItemAnalysisMgt.CalculateAmount(            ValueType, SetColFilter,            CurrentAnalysisArea, ItemStatisticsBuffer, CurrentItemAnalysisViewCode,            ItemFilter, LocationFilter, DateFilter, BudgetFilter,            Dim1Filter, Dim2Filter, Dim3Filter,            LineDimType, Rec,            ColumnDimType, MatrixRecord,            ShowActualBudget);        if ShowOppositeSign then            Amt := -Amt;    end;    procedure Load(MatrixColumns1: array[32] of Text[1024]; var MatrixRecords1: array[32] of Record "Dimension Code Buffer"; CurrentNoOfMatrixColumns: Integer; _LineDimOption: Integer; _ColumnDimOption: Integer; _RoundingFactor: Integer; _DateFilter: Text[30]; _ValueType: Integer; _ItemAnalysisView: Record "Item Analysis View"; _CurrentItemAnalysisViewCode: Code[10]; _ItemFilter: Code[250]; _LocationFilter: Code[250]; _BudgetFilter: Code[250]; _Dim1Filter: Code[250]; _Dim2Filter: Code[250]; _Dim3Filter: Code[250]; ShowOppSign: Boolean)    begin    end;    procedure LoadMatrix(NewMatrixColumns: array[32] of Text[1024]; var NewMatrixRecords: array[32] of Record "Dimension Code Buffer"; CurrentNoOfMatrixColumns: Integer; NewLineDimType: Enum "Item Analysis Dimension Type"; NewColumnDimType: Enum "Item Analysis Dimension Type"; NewRoundingFactor: Enum "Analysis Rounding Factor"; NewDateFilter: Text[30]; NewValueType: Enum "Item Analysis Value Type"; NewItemAnalysisView: Record "Item Analysis View"; NewCurrentItemAnalysisViewCode: Code[10]; NewItemFilter: Code[250]; NewLocationFilter: Code[250]; NewBudgetFilter: Code[250]; NewDim1Filter: Code[250]; NewDim2Filter: Code[250]; NewDim3Filter: Code[250]; NewShowOppSign: Boolean)    var        FilterTokens: Codeunit "Filter Tokens";        i: Integer;    begin        CopyArray(MATRIX_CaptionSet, NewMatrixColumns, 1);        for i := 1 to ArrayLen(MatrixRecords) do            MatrixRecords[i].Copy(NewMatrixRecords[i]);        MATRIX_CurrentNoOfMatrixColumn := CurrentNoOfMatrixColumns;        LineDimType := NewLineDimType;        ColumnDimType := NewColumnDimType;        RoundingFactor := NewRoundingFactor;        ValueType := NewValueType;        ItemAnalysisView := NewItemAnalysisView;        CurrentItemAnalysisViewCode := NewCurrentItemAnalysisViewCode;        FilterTokens.MakeDateFilter(NewDateFilter);        ItemStatisticsBuffer.SetFilter("Date Filter", NewDateFilter);        DateFilter := ItemStatisticsBuffer.GetFilter("Date Filter");        ItemFilter := NewItemFilter;        LocationFilter := NewLocationFilter;        BudgetFilter := NewBudgetFilter;        Dim1Filter := NewDim1Filter;        Dim2Filter := NewDim2Filter;        Dim3Filter := NewDim3Filter;        InternalDateFilter := DateFilter;        ShowOppositeSign := NewShowOppSign;    end;    local procedure MATRIX_OnDrillDown(MATRIX_ColumnOrdinal: Integer)    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeMATRIX_OnDrillDown(Rec, ItemAnalysisView, LineDimType, ColumnDimType, MatrixRecords[MATRIX_ColumnOrdinal], IsHandled);        if IsHandled then            exit;        ItemAnalysisMgt.DrillDownAmount(          CurrentAnalysisArea, ItemStatisticsBuffer, CurrentItemAnalysisViewCode,          ItemFilter, LocationFilter, DateFilter,          Dim1Filter, Dim2Filter, Dim3Filter, BudgetFilter,          LineDimType, Rec,          ColumnDimType, MatrixRecords[MATRIX_ColumnOrdinal],          true, ValueType, ShowActualBudget);    end;    local procedure MATRIX_OnAfterGetRecord(MATRIX_ColumnOrdinal: Integer)    begin        MatrixRecord := MatrixRecords[MATRIX_ColumnOrdinal];        AnalysisValue := CalcAmt(ValueType, true);        MATRIX_CellData[MATRIX_ColumnOrdinal] := AnalysisValue;    end;    local procedure FormatLine()    begin        NameIndent := Rec.Indentation;    end;    local procedure QuantityOnFormat(Text: Text[1024])    begin        ItemAnalysisMgt.FormatToAmount(Text, RoundingFactor);    end;    local procedure AmountOnFormat(Text: Text[1024])    begin        ItemAnalysisMgt.FormatToAmount(Text, RoundingFactor);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcAmt(LineDimCodeBuf: Record "Dimension Code Buffer"; var ItemAnalysisView: Record "Item Analysis View"; LineDimType: Enum "Item Analysis Dimension Type"; ColumnDimType: Enum "Item Analysis Dimension Type"; ColumnDimCodeBuf: Record "Dimension Code Buffer"; SetColumnFilter: Boolean; ItemFilter: Code[250]; LocationFilter: Code[250]; DateFilter: Text[30]; ValueType: Enum "Item Analysis Value Type"; SetColFilter: Boolean; ShowOppositeSign: Boolean; var Amt: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeMATRIX_OnDrillDown(LineDimCodeBuf: Record "Dimension Code Buffer"; var ItemAnalysisView: Record "Item Analysis View"; LineDimType: Enum "Item Analysis Dimension Type"; ColumnDimType: Enum "Item Analysis Dimension Type"; ColDimCodeBuf: Record "Dimension Code Buffer"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeOnOpenPage(var CurrentAnalysisArea: Enum "Analysis Area Type"; var CurrentItemAnalysisViewCode: Code[10]; var ItemAnalysisView: Record "Item Analysis View"; var ItemStatisticsBuffer: Record "Item Statistics Buffer"; var Dim1Filter: Code[250]; var Dim2Filter: Code[250]; var Dim3Filter: Code[250]; var IsHandled: Boolean)    begin    end;}