Page 9201 Inventory Analysis Matrix
src/Layers/W1/BaseApp/Inventory/Analysis/InventoryAnalysisMatrix.Page.al804 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.Analysis;using Microsoft.Foundation.Enums;page 9201 "Inventory Analysis Matrix"{ Caption = 'Inventory Analysis Matrix'; Editable = false; LinksAllowed = false; PageType = List; SourceTable = "Analysis Line"; layout { area(content) { repeater(Control1) { ShowCaption = false; field("Row Ref. No."; Rec."Row Ref. No.") { ApplicationArea = InventoryAnalysis; Style = Strong; StyleExpr = Emphasize; } field(Description; Rec.Description) { ApplicationArea = InventoryAnalysis; Style = Strong; StyleExpr = Emphasize; } field(Field1; MatrixData[1]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(1); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[1]; StyleExpr = Field1Style; Visible = Field1Visible; trigger OnDrillDown() begin FieldDrillDown(1); end; } field(Field2; MatrixData[2]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(2); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[2]; StyleExpr = Field2Style; Visible = Field2Visible; trigger OnDrillDown() begin FieldDrillDown(2); end; } field(Field3; MatrixData[3]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(3); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[3]; StyleExpr = Field3Style; Visible = Field3Visible; trigger OnDrillDown() begin FieldDrillDown(3); end; } field(Field4; MatrixData[4]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(4); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[4]; StyleExpr = Field4Style; Visible = Field4Visible; trigger OnDrillDown() begin FieldDrillDown(4); end; } field(Field5; MatrixData[5]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(5); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[5]; StyleExpr = Field5Style; Visible = Field5Visible; trigger OnDrillDown() begin FieldDrillDown(5); end; } field(Field6; MatrixData[6]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(6); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[6]; StyleExpr = Field6Style; Visible = Field6Visible; trigger OnDrillDown() begin FieldDrillDown(6); end; } field(Field7; MatrixData[7]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(7); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[7]; StyleExpr = Field7Style; Visible = Field7Visible; trigger OnDrillDown() begin FieldDrillDown(7); end; } field(Field8; MatrixData[8]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(8); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[8]; StyleExpr = Field8Style; Visible = Field8Visible; trigger OnDrillDown() begin FieldDrillDown(8); end; } field(Field9; MatrixData[9]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(9); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[9]; StyleExpr = Field9Style; Visible = Field9Visible; trigger OnDrillDown() begin FieldDrillDown(9); end; } field(Field10; MatrixData[10]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(10); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[10]; StyleExpr = Field10Style; Visible = Field10Visible; trigger OnDrillDown() begin FieldDrillDown(10); end; } field(Field11; MatrixData[11]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(11); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[11]; StyleExpr = Field11Style; Visible = Field11Visible; trigger OnDrillDown() begin FieldDrillDown(11); end; } field(Field12; MatrixData[12]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(12); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[12]; StyleExpr = Field12Style; Visible = Field12Visible; trigger OnDrillDown() begin FieldDrillDown(12); end; } field(Field13; MatrixData[13]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(13); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[13]; StyleExpr = Field13Style; Visible = Field13Visible; trigger OnDrillDown() begin FieldDrillDown(13); end; } field(Field14; MatrixData[14]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(14); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[14]; StyleExpr = Field14Style; Visible = Field14Visible; trigger OnDrillDown() begin FieldDrillDown(14); end; } field(Field15; MatrixData[15]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(15); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[15]; StyleExpr = Field15Style; Visible = Field15Visible; trigger OnDrillDown() begin FieldDrillDown(15); end; } field(Field16; MatrixData[16]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(16); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[16]; StyleExpr = Field16Style; Visible = Field16Visible; trigger OnDrillDown() begin FieldDrillDown(16); end; } field(Field17; MatrixData[17]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(17); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[17]; StyleExpr = Field17Style; Visible = Field17Visible; trigger OnDrillDown() begin FieldDrillDown(17); end; } field(Field18; MatrixData[18]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(18); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[18]; StyleExpr = Field18Style; Visible = Field18Visible; trigger OnDrillDown() begin FieldDrillDown(18); end; } field(Field19; MatrixData[19]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(19); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[19]; StyleExpr = Field19Style; Visible = Field19Visible; trigger OnDrillDown() begin FieldDrillDown(19); end; } field(Field20; MatrixData[20]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(20); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[20]; StyleExpr = Field20Style; Visible = Field20Visible; trigger OnDrillDown() begin FieldDrillDown(20); end; } field(Field21; MatrixData[21]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(21); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[21]; StyleExpr = Field21Style; Visible = Field21Visible; trigger OnDrillDown() begin FieldDrillDown(21); end; } field(Field22; MatrixData[22]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(22); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[22]; StyleExpr = Field22Style; Visible = Field22Visible; trigger OnDrillDown() begin FieldDrillDown(22); end; } field(Field23; MatrixData[23]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(23); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[23]; StyleExpr = Field23Style; Visible = Field23Visible; trigger OnDrillDown() begin FieldDrillDown(23); end; } field(Field24; MatrixData[24]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(24); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[24]; StyleExpr = Field24Style; Visible = Field24Visible; trigger OnDrillDown() begin FieldDrillDown(24); end; } field(Field25; MatrixData[25]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(25); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[25]; StyleExpr = Field25Style; Visible = Field25Visible; trigger OnDrillDown() begin FieldDrillDown(25); end; } field(Field26; MatrixData[26]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(26); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[26]; StyleExpr = Field26Style; Visible = Field26Visible; trigger OnDrillDown() begin FieldDrillDown(26); end; } field(Field27; MatrixData[27]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(27); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[27]; StyleExpr = Field27Style; Visible = Field27Visible; trigger OnDrillDown() begin FieldDrillDown(27); end; } field(Field28; MatrixData[28]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(28); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[28]; StyleExpr = Field28Style; Visible = Field28Visible; trigger OnDrillDown() begin FieldDrillDown(28); end; } field(Field29; MatrixData[29]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(29); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[29]; StyleExpr = Field29Style; Visible = Field29Visible; trigger OnDrillDown() begin FieldDrillDown(29); end; } field(Field30; MatrixData[30]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(30); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[30]; StyleExpr = Field30Style; Visible = Field30Visible; trigger OnDrillDown() begin FieldDrillDown(30); end; } field(Field31; MatrixData[31]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(31); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[31]; StyleExpr = Field31Style; Visible = Field31Visible; trigger OnDrillDown() begin FieldDrillDown(31); end; } field(Field32; MatrixData[32]) { ApplicationArea = InventoryAnalysis; AutoFormatExpression = FormatStr(32); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MatrixColumnCaptions[32]; StyleExpr = Field32Style; Visible = Field32Visible; trigger OnDrillDown() begin FieldDrillDown(32); end; } } } } actions { } trigger OnAfterGetRecord() var CellValue: Decimal; begin i := 1; if AnalysisColumn.Find('-') then repeat if i <= ArrayLen(MatrixData) then begin if Rec.Range = '' then CellValue := 0 else CellValue := AnalysisReportMgt.CalcCell(Rec, AnalysisColumn, false); MatrixData[i] := MatrixMgt.RoundAmount(CellValue, AnalysisColumn."Rounding Factor"); MatrixRounding[i] := AnalysisColumn."Rounding Factor"; CachedContainsError[i] := FindError(); end; SetStyle(i); i := i + 1; until AnalysisColumn.Next() = 0; Emphasize := Rec.Bold; end; trigger OnInit() begin Field32Visible := true; Field31Visible := true; Field30Visible := true; Field29Visible := true; Field28Visible := true; Field27Visible := true; Field26Visible := true; Field25Visible := true; Field24Visible := true; Field23Visible := true; Field22Visible := true; Field21Visible := true; Field20Visible := true; Field19Visible := true; Field18Visible := true; Field17Visible := true; Field16Visible := true; Field15Visible := true; Field14Visible := true; Field13Visible := true; Field12Visible := true; Field11Visible := true; Field10Visible := true; Field9Visible := true; Field8Visible := true; Field7Visible := true; Field6Visible := true; Field5Visible := true; Field4Visible := true; Field3Visible := true; Field2Visible := true; Field1Visible := true; end; trigger OnOpenPage() begin Rec.SetFilter(Show, '<>%1', Rec.Show::No); AnalysisColumn.SetRange("Analysis Area", AnalysisColumn."Analysis Area"::Inventory); AnalysisColumn.SetRange("Analysis Column Template", AnalysisColumn."Analysis Column Template"); AnalysisColumn.SetRange("Line No.", FirstLineNo, LastLineNo); AnalysisColumn.SetFilter(Show, '<>%1', AnalysisColumn.Show::Never); SetVisible(); end; var AnalysisColumn: Record "Analysis Column"; AnalysisColumn2: Record "Analysis Column"; AnalysisReportMgt: Codeunit "Analysis Report Management"; MatrixMgt: Codeunit "Matrix Management"; MatrixColumnCaptions: array[32] of Text[1024]; i: Integer; MatrixData: array[32] of Decimal; MatrixRounding: array[32] of Enum "Analysis Rounding Factor"; FirstLineNo: Integer; LastLineNo: Integer; CachedContainsError: array[32] of Boolean; Field1Visible: Boolean; Field2Visible: Boolean; Field3Visible: Boolean; Field4Visible: Boolean; Field5Visible: Boolean; Field6Visible: Boolean; Field7Visible: Boolean; Field8Visible: Boolean; Field9Visible: Boolean; Field10Visible: Boolean; Field11Visible: Boolean; Field12Visible: Boolean; Field13Visible: Boolean; Field14Visible: Boolean; Field15Visible: Boolean; Field16Visible: Boolean; Field17Visible: Boolean; Field18Visible: Boolean; Field19Visible: Boolean; Field20Visible: Boolean; Field21Visible: Boolean; Field22Visible: Boolean; Field23Visible: Boolean; Field24Visible: Boolean; Field25Visible: Boolean; Field26Visible: Boolean; Field27Visible: Boolean; Field28Visible: Boolean; Field29Visible: Boolean; Field30Visible: Boolean; Field31Visible: Boolean; Field32Visible: Boolean; Emphasize: Boolean; Field1Style: Text; Field2Style: Text; Field3Style: Text; Field4Style: Text; Field5Style: Text; Field6Style: Text; Field7Style: Text; Field8Style: Text; Field9Style: Text; Field10Style: Text; Field11Style: Text; Field12Style: Text; Field13Style: Text; Field14Style: Text; Field15Style: Text; Field16Style: Text; Field17Style: Text; Field18Style: Text; Field19Style: Text; Field20Style: Text; Field21Style: Text; Field22Style: Text; Field23Style: Text; Field24Style: Text; Field25Style: Text; Field26Style: Text; Field27Style: Text; Field28Style: Text; Field29Style: Text; Field30Style: Text; Field31Style: Text; Field32Style: Text; procedure Load(AnalysisColumn1: Record "Analysis Column"; MatrixColumnCaptions1: array[32] of Text[1024]; FirstLineNo1: Integer; LastLineNo1: Integer) begin AnalysisColumn.Copy(AnalysisColumn1); CopyArray(MatrixColumnCaptions, MatrixColumnCaptions1, 1); FirstLineNo := FirstLineNo1; LastLineNo := LastLineNo1; end; local procedure GetHorizontalRecord(HorizontalRecordOrdinal: Integer; var HorizontalRecord: Record "Analysis Column") var n: Integer; begin n := 1; if HorizontalRecord.Find('-') then while n <> HorizontalRecordOrdinal do begin n := n + 1; HorizontalRecord.Next(); end; end; local procedure FindError(): Boolean begin if AnalysisReportMgt.GetDivisionError() or AnalysisReportMgt.GetPeriodError() or AnalysisReportMgt.GetFormulaError() or AnalysisReportMgt.GetCyclicError() then exit(true); exit(false); end; local procedure FieldDrillDown(ColumnID: Integer) begin AnalysisColumn2.Copy(AnalysisColumn); GetHorizontalRecord(ColumnID, AnalysisColumn2); AnalysisReportMgt.CalcCell(Rec, AnalysisColumn2, true); end; procedure SetVisible() begin Field1Visible := MatrixColumnCaptions[1] <> ''; Field2Visible := MatrixColumnCaptions[2] <> ''; Field3Visible := MatrixColumnCaptions[3] <> ''; Field4Visible := MatrixColumnCaptions[4] <> ''; Field5Visible := MatrixColumnCaptions[5] <> ''; Field6Visible := MatrixColumnCaptions[6] <> ''; Field7Visible := MatrixColumnCaptions[7] <> ''; Field8Visible := MatrixColumnCaptions[8] <> ''; Field9Visible := MatrixColumnCaptions[9] <> ''; Field10Visible := MatrixColumnCaptions[10] <> ''; Field11Visible := MatrixColumnCaptions[11] <> ''; Field12Visible := MatrixColumnCaptions[12] <> ''; Field13Visible := MatrixColumnCaptions[13] <> ''; Field14Visible := MatrixColumnCaptions[14] <> ''; Field15Visible := MatrixColumnCaptions[15] <> ''; Field16Visible := MatrixColumnCaptions[16] <> ''; Field17Visible := MatrixColumnCaptions[17] <> ''; Field18Visible := MatrixColumnCaptions[18] <> ''; Field19Visible := MatrixColumnCaptions[19] <> ''; Field20Visible := MatrixColumnCaptions[20] <> ''; Field21Visible := MatrixColumnCaptions[21] <> ''; Field22Visible := MatrixColumnCaptions[22] <> ''; Field23Visible := MatrixColumnCaptions[23] <> ''; Field24Visible := MatrixColumnCaptions[24] <> ''; Field25Visible := MatrixColumnCaptions[25] <> ''; Field26Visible := MatrixColumnCaptions[26] <> ''; Field27Visible := MatrixColumnCaptions[27] <> ''; Field28Visible := MatrixColumnCaptions[28] <> ''; Field29Visible := MatrixColumnCaptions[29] <> ''; Field30Visible := MatrixColumnCaptions[30] <> ''; Field31Visible := MatrixColumnCaptions[31] <> ''; Field32Visible := MatrixColumnCaptions[32] <> ''; end; procedure GetMatrixDimension(): Integer begin exit(ArrayLen(MatrixColumnCaptions)); end; procedure FormatStr(ColumnNo: Integer): Text begin exit(MatrixMgt.FormatRoundingFactor(MatrixRounding[ColumnNo], false)); end; local procedure SetStyle(ColumnID: Integer) begin SetFieldStyle(Field1Style, ColumnID); SetFieldStyle(Field2Style, ColumnID); SetFieldStyle(Field3Style, ColumnID); SetFieldStyle(Field4Style, ColumnID); SetFieldStyle(Field5Style, ColumnID); SetFieldStyle(Field6Style, ColumnID); SetFieldStyle(Field7Style, ColumnID); SetFieldStyle(Field8Style, ColumnID); SetFieldStyle(Field9Style, ColumnID); SetFieldStyle(Field10Style, ColumnID); SetFieldStyle(Field11Style, ColumnID); SetFieldStyle(Field12Style, ColumnID); SetFieldStyle(Field13Style, ColumnID); SetFieldStyle(Field14Style, ColumnID); SetFieldStyle(Field15Style, ColumnID); SetFieldStyle(Field16Style, ColumnID); SetFieldStyle(Field17Style, ColumnID); SetFieldStyle(Field18Style, ColumnID); SetFieldStyle(Field19Style, ColumnID); SetFieldStyle(Field20Style, ColumnID); SetFieldStyle(Field21Style, ColumnID); SetFieldStyle(Field22Style, ColumnID); SetFieldStyle(Field23Style, ColumnID); SetFieldStyle(Field24Style, ColumnID); SetFieldStyle(Field25Style, ColumnID); SetFieldStyle(Field26Style, ColumnID); SetFieldStyle(Field27Style, ColumnID); SetFieldStyle(Field28Style, ColumnID); SetFieldStyle(Field29Style, ColumnID); SetFieldStyle(Field30Style, ColumnID); SetFieldStyle(Field31Style, ColumnID); SetFieldStyle(Field32Style, ColumnID); end; local procedure SetFieldStyle(var FieldStyle: Text; ColumnID: Integer) begin if CachedContainsError[ColumnID] then FieldStyle := 'Unfavorable' else FieldStyle := 'Standard'; end;}