Page 9231 Items by Location Matrix
- App
- Base Application
- Namespace
- Microsoft.Inventory.Analysis
- Versions
- 17-28
- Source table
- 27
Versions171819202122232425262728
Source29
Source in 29
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
}