Page 9231 Items by Location Matrix
src/Layers/W1/BaseApp/Inventory/Analysis/ItemsbyLocationMatrix.Page.al759 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.Inventory.Availability;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;page 9231 "Items by Location Matrix"{ Caption = 'Items by Location Matrix'; Editable = false; LinksAllowed = false; PageType = ListPart; SourceTable = Item; SourceTableView = where(Type = const(Inventory)); layout { area(content) { repeater(Control1) { ShowCaption = false; field("No."; Rec."No.") { ApplicationArea = Location; ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.'; } field(Description; Rec.Description) { ApplicationArea = Location; } field(Field1; MATRIX_CellData[1]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[1]; DecimalPlaces = 0 : 5; Visible = Field1Visible; trigger OnDrillDown() begin MatrixOnDrillDown(1); end; } field(Field2; MATRIX_CellData[2]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[2]; DecimalPlaces = 0 : 5; Visible = Field2Visible; trigger OnDrillDown() begin MatrixOnDrillDown(2); end; } field(Field3; MATRIX_CellData[3]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[3]; DecimalPlaces = 0 : 5; Visible = Field3Visible; trigger OnDrillDown() begin MatrixOnDrillDown(3); end; } field(Field4; MATRIX_CellData[4]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[4]; DecimalPlaces = 0 : 5; Visible = Field4Visible; trigger OnDrillDown() begin MatrixOnDrillDown(4); end; } field(Field5; MATRIX_CellData[5]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[5]; DecimalPlaces = 0 : 5; Visible = Field5Visible; trigger OnDrillDown() begin MatrixOnDrillDown(5); end; } field(Field6; MATRIX_CellData[6]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[6]; DecimalPlaces = 0 : 5; Visible = Field6Visible; trigger OnDrillDown() begin MatrixOnDrillDown(6); end; } field(Field7; MATRIX_CellData[7]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[7]; DecimalPlaces = 0 : 5; Visible = Field7Visible; trigger OnDrillDown() begin MatrixOnDrillDown(7); end; } field(Field8; MATRIX_CellData[8]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[8]; DecimalPlaces = 0 : 5; Visible = Field8Visible; trigger OnDrillDown() begin MatrixOnDrillDown(8); end; } field(Field9; MATRIX_CellData[9]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[9]; DecimalPlaces = 0 : 5; Visible = Field9Visible; trigger OnDrillDown() begin MatrixOnDrillDown(9); end; } field(Field10; MATRIX_CellData[10]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[10]; DecimalPlaces = 0 : 5; Visible = Field10Visible; trigger OnDrillDown() begin MatrixOnDrillDown(10); end; } field(Field11; MATRIX_CellData[11]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[11]; DecimalPlaces = 0 : 5; Visible = Field11Visible; trigger OnDrillDown() begin MatrixOnDrillDown(11); end; } field(Field12; MATRIX_CellData[12]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[12]; DecimalPlaces = 0 : 5; Visible = Field12Visible; trigger OnDrillDown() begin MatrixOnDrillDown(12); end; } field(Field13; MATRIX_CellData[13]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[13]; DecimalPlaces = 0 : 5; Visible = Field13Visible; trigger OnDrillDown() begin MatrixOnDrillDown(13); end; } field(Field14; MATRIX_CellData[14]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[14]; DecimalPlaces = 0 : 5; Visible = Field14Visible; trigger OnDrillDown() begin MatrixOnDrillDown(14); end; } field(Field15; MATRIX_CellData[15]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[15]; DecimalPlaces = 0 : 5; Visible = Field15Visible; trigger OnDrillDown() begin MatrixOnDrillDown(15); end; } field(Field16; MATRIX_CellData[16]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[16]; DecimalPlaces = 0 : 5; Visible = Field16Visible; trigger OnDrillDown() begin MatrixOnDrillDown(16); end; } field(Field17; MATRIX_CellData[17]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[17]; DecimalPlaces = 0 : 5; Visible = Field17Visible; trigger OnDrillDown() begin MatrixOnDrillDown(17); end; } field(Field18; MATRIX_CellData[18]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[18]; DecimalPlaces = 0 : 5; Visible = Field18Visible; trigger OnDrillDown() begin MatrixOnDrillDown(18); end; } field(Field19; MATRIX_CellData[19]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[19]; DecimalPlaces = 0 : 5; Visible = Field19Visible; trigger OnDrillDown() begin MatrixOnDrillDown(19); end; } field(Field20; MATRIX_CellData[20]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[20]; DecimalPlaces = 0 : 5; Visible = Field20Visible; trigger OnDrillDown() begin MatrixOnDrillDown(20); end; } field(Field21; MATRIX_CellData[21]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[21]; DecimalPlaces = 0 : 5; Visible = Field21Visible; trigger OnDrillDown() begin MatrixOnDrillDown(21); end; } field(Field22; MATRIX_CellData[22]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[22]; DecimalPlaces = 0 : 5; Visible = Field22Visible; trigger OnDrillDown() begin MatrixOnDrillDown(22); end; } field(Field23; MATRIX_CellData[23]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[23]; DecimalPlaces = 0 : 5; Visible = Field23Visible; trigger OnDrillDown() begin MatrixOnDrillDown(23); end; } field(Field24; MATRIX_CellData[24]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[24]; DecimalPlaces = 0 : 5; Visible = Field24Visible; trigger OnDrillDown() begin MatrixOnDrillDown(24); end; } field(Field25; MATRIX_CellData[25]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[25]; DecimalPlaces = 0 : 5; Visible = Field25Visible; trigger OnDrillDown() begin MatrixOnDrillDown(25); end; } field(Field26; MATRIX_CellData[26]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[26]; DecimalPlaces = 0 : 5; Visible = Field26Visible; trigger OnDrillDown() begin MatrixOnDrillDown(26); end; } field(Field27; MATRIX_CellData[27]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[27]; DecimalPlaces = 0 : 5; Visible = Field27Visible; trigger OnDrillDown() begin MatrixOnDrillDown(27); end; } field(Field28; MATRIX_CellData[28]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[28]; DecimalPlaces = 0 : 5; Visible = Field28Visible; trigger OnDrillDown() begin MatrixOnDrillDown(28); end; } field(Field29; MATRIX_CellData[29]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[29]; DecimalPlaces = 0 : 5; Visible = Field29Visible; trigger OnDrillDown() begin MatrixOnDrillDown(29); end; } field(Field30; MATRIX_CellData[30]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[30]; DecimalPlaces = 0 : 5; Visible = Field30Visible; trigger OnDrillDown() begin MatrixOnDrillDown(30); end; } field(Field31; MATRIX_CellData[31]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[31]; DecimalPlaces = 0 : 5; Visible = Field31Visible; trigger OnDrillDown() begin MatrixOnDrillDown(31); end; } field(Field32; MATRIX_CellData[32]) { ApplicationArea = Location; AutoFormatType = 0; BlankNumbers = BlankZero; CaptionClass = '3,' + MATRIX_ColumnCaption[32]; DecimalPlaces = 0 : 5; Visible = Field32Visible; trigger OnDrillDown() begin MatrixOnDrillDown(32); end; } } } } actions { area(processing) { group("&Item") { Caption = '&Item'; Image = Item; group("&Item Availability by") { Caption = '&Item Availability by'; Image = ItemAvailability; action("<Action3>") { ApplicationArea = Location; Caption = 'Event'; Image = "Event"; ToolTip = 'View how the actual and the projected available balance of an item will develop over time according to supply and demand events.'; trigger OnAction() begin ItemAvailFormsMgt.ShowItemAvailabilityFromItem(Rec, "Item Availability Type"::"Event"); end; } action(Period) { ApplicationArea = Location; Caption = 'Period'; Image = Period; RunObject = Page "Item Availability by Periods"; RunPageLink = "No." = field("No."), "Global Dimension 1 Filter" = field("Global Dimension 1 Filter"), "Global Dimension 2 Filter" = field("Global Dimension 2 Filter"), "Location Filter" = field("Location Filter"), "Drop Shipment Filter" = field("Drop Shipment Filter"), "Variant Filter" = field("Variant Filter"); ToolTip = 'Show the projected quantity of the item over time according to time periods, such as day, week, or month.'; } action(Variant) { ApplicationArea = Planning; Caption = 'Variant'; Image = ItemVariant; RunObject = Page "Item Availability by Variant"; RunPageLink = "No." = field("No."), "Global Dimension 1 Filter" = field("Global Dimension 1 Filter"), "Global Dimension 2 Filter" = field("Global Dimension 2 Filter"), "Location Filter" = field("Location Filter"), "Drop Shipment Filter" = field("Drop Shipment Filter"), "Variant Filter" = field("Variant Filter"); ToolTip = 'View or edit the item''s variants. Instead of setting up each color of an item as a separate item, you can set up the various colors as variants of the item.'; } action(Location) { ApplicationArea = Location; Caption = 'Location'; Image = Warehouse; RunObject = Page "Item Availability by Location"; RunPageLink = "No." = field("No."), "Global Dimension 1 Filter" = field("Global Dimension 1 Filter"), "Global Dimension 2 Filter" = field("Global Dimension 2 Filter"), "Location Filter" = field("Location Filter"), "Drop Shipment Filter" = field("Drop Shipment Filter"), "Variant Filter" = field("Variant Filter"); ToolTip = 'View the actual and projected quantity of the item per location.'; } action("BOM Level") { ApplicationArea = Location; Caption = 'BOM Level'; Image = BOMLevel; ToolTip = 'View availability figures for items on bills of materials that show how many units of a parent item you can make based on the availability of child items.'; trigger OnAction() begin ItemAvailFormsMgt.ShowItemAvailabilityFromItem(Rec, "Item Availability Type"::"Event"); end; } } } } } trigger OnAfterGetRecord() var MATRIX_CurrentColumnOrdinal: Integer; begin MATRIX_CurrentColumnOrdinal := 0; if TempMatrixLocation.FindSet() then repeat MATRIX_CurrentColumnOrdinal := MATRIX_CurrentColumnOrdinal + 1; MATRIX_OnAfterGetRecord(MATRIX_CurrentColumnOrdinal); until (TempMatrixLocation.Next() = 0) or (MATRIX_CurrentColumnOrdinal = MATRIX_NoOfMatrixColumns); 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 MATRIX_NoOfMatrixColumns := ArrayLen(MATRIX_CellData); end; var ItemLedgerEntry: Record "Item Ledger Entry"; MatrixRecords: array[32] of Record Location; TempMatrixLocation: Record Location temporary; ItemAvailFormsMgt: Codeunit "Item Availability Forms Mgt"; MATRIX_NoOfMatrixColumns: Integer; MATRIX_CellData: array[32] of Decimal; MATRIX_ColumnCaption: array[32] of Text[1024]; MATRIX_CurrSetLength: Integer; 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; local procedure MATRIX_OnAfterGetRecord(ColumnID: Integer) var TempItem: Record Item temporary; begin TempItem.Copy(Rec); TempItem.SetRange("Location Filter", MatrixRecords[ColumnID].Code); TempItem.CalcFields(Inventory); MATRIX_CellData[ColumnID] := TempItem.Inventory; SetVisible(); OnAfterMATRIX_OnAfterGetRecord(MATRIX_CellData, MatrixRecords, TempItem, ColumnID); end; procedure Load(MatrixColumns1: array[32] of Text[1024]; var MatrixRecords1: array[32] of Record Location; var MatrixRecord1: Record Location; CurrSetLength: Integer) begin MATRIX_CurrSetLength := CurrSetLength; CopyArray(MATRIX_ColumnCaption, MatrixColumns1, 1); CopyArray(MatrixRecords, MatrixRecords1, 1); TempMatrixLocation.Copy(MatrixRecord1, true); end; local procedure MatrixOnDrillDown(ColumnID: Integer) var IsHandled: Boolean; begin IsHandled := false; OnBeforeMatrixOnDrillDown(Rec, ItemLedgerEntry, ColumnID, IsHandled, MatrixRecords); if IsHandled then exit; ItemLedgerEntry.SetCurrentKey( "Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date"); ItemLedgerEntry.SetRange("Item No.", Rec."No."); ItemLedgerEntry.SetRange("Location Code", MatrixRecords[ColumnID].Code); OnMatrixOnDrillDownOnAfterItemLedgerEntrySetFilters(Rec, ItemLedgerEntry, ColumnID); PAGE.Run(0, ItemLedgerEntry); end; procedure SetVisible() begin Field1Visible := MATRIX_CurrSetLength > 0; Field2Visible := MATRIX_CurrSetLength > 1; Field3Visible := MATRIX_CurrSetLength > 2; Field4Visible := MATRIX_CurrSetLength > 3; Field5Visible := MATRIX_CurrSetLength > 4; Field6Visible := MATRIX_CurrSetLength > 5; Field7Visible := MATRIX_CurrSetLength > 6; Field8Visible := MATRIX_CurrSetLength > 7; Field9Visible := MATRIX_CurrSetLength > 8; Field10Visible := MATRIX_CurrSetLength > 9; Field11Visible := MATRIX_CurrSetLength > 10; Field12Visible := MATRIX_CurrSetLength > 11; Field13Visible := MATRIX_CurrSetLength > 12; Field14Visible := MATRIX_CurrSetLength > 13; Field15Visible := MATRIX_CurrSetLength > 14; Field16Visible := MATRIX_CurrSetLength > 15; Field17Visible := MATRIX_CurrSetLength > 16; Field18Visible := MATRIX_CurrSetLength > 17; Field19Visible := MATRIX_CurrSetLength > 18; Field20Visible := MATRIX_CurrSetLength > 19; Field21Visible := MATRIX_CurrSetLength > 20; Field22Visible := MATRIX_CurrSetLength > 21; Field23Visible := MATRIX_CurrSetLength > 22; Field24Visible := MATRIX_CurrSetLength > 23; Field25Visible := MATRIX_CurrSetLength > 24; Field26Visible := MATRIX_CurrSetLength > 25; Field27Visible := MATRIX_CurrSetLength > 26; Field28Visible := MATRIX_CurrSetLength > 27; Field29Visible := MATRIX_CurrSetLength > 28; Field30Visible := MATRIX_CurrSetLength > 29; Field31Visible := MATRIX_CurrSetLength > 30; Field32Visible := MATRIX_CurrSetLength > 31; end; [IntegrationEvent(true, false)] local procedure OnAfterMATRIX_OnAfterGetRecord(var MATRIX_CellData: array[32] of Decimal; var MatrixRecords: array[32] of Record Location; var TempItem: Record Item temporary; ColumnID: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnMatrixOnDrillDownOnAfterItemLedgerEntrySetFilters(var Item: Record Item; var ItemLedgerEntry: Record "Item Ledger Entry"; ColumnID: integer) begin end;#pragma warning disable AS0077 [IntegrationEvent(false, false)] local procedure OnBeforeMatrixOnDrillDown(var Item: Record Item; var ItemLedgerEntry: Record "Item Ledger Entry"; ColumnID: Integer; var IsHandled: Boolean; var MatrixRecords: array[32] of Record Location) begin end;#pragma warning restore AS0077}