Page 9209 Invt. Analys by Dim. Matrix
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;}