Page 5827 Item Statistics
src/Layers/W1/BaseApp/Inventory/Analysis/ItemStatistics.Page.al658 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.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using System.Utilities;page 5827 "Item Statistics"{ Caption = 'Item Statistics'; DataCaptionExpression = ItemName; DeleteAllowed = false; InsertAllowed = false; LinksAllowed = false; ModifyAllowed = false; PageType = Card; SaveValues = true; SourceTable = "Dimension Code Buffer"; layout { area(content) { group(General) { Caption = 'General'; field(ShowAsLines; ItemBuffer."Line Option") { ApplicationArea = Basic, Suite; Caption = 'Show as Lines'; ToolTip = 'Specifies which values you want to show as lines in the window. This allows you to see the same matrix window from various perspectives, especially when you use both the Show as Lines field and the Show as Columns field.'; trigger OnValidate() begin ItemBufferLineOptionOnAfterVal(); end; } field(ColumnDimCode; ColumnDimCode) { ApplicationArea = Suite; Caption = 'Show as Columns'; ToolTip = 'Specifies which values you want to show as columns in the window. This allows you to see the same matrix window from various perspectives, especially when you use both the Show as Lines field and the Show as Columns field.'; trigger OnLookup(var Text: Text): Boolean var NewCode: Text[30]; begin NewCode := GetDimSelection(ColumnDimCode); if NewCode = ColumnDimCode then begin GenerateColumnCaptions("Matrix Page Step Type"::Same); exit(false); end; Text := NewCode; ColumnDimCode := NewCode; ValidateColumnDimCode(); GenerateColumnCaptions("Matrix Page Step Type"::Initial); CurrPage.Update(); exit(true); end; trigger OnValidate() begin ValidateColumnDimCode(); ColumnDimCodeOnAfterValidate(); end; } field(DateFilter; DateFilter) { ApplicationArea = Basic, Suite; Caption = 'Date Filter'; ToolTip = 'Specifies the dates that will be used to filter the amounts in the window.'; trigger OnValidate() begin ItemBuffer.SetFilter("Date Filter", DateFilter); DateFilter := ItemBuffer.GetFilter("Date Filter"); InternalDateFilter := DateFilter; DateFilterOnAfterValidate(); end; } field(ItemFilter; ItemFilter) { ApplicationArea = Basic, Suite; Caption = 'Item Filter'; ToolTip = 'Specifies a filter to specify the items that will be shown in the window.'; trigger OnLookup(var Text: Text): Boolean var Item: Record Item; ItemList: Page "Item List"; begin ItemList.SetTableView(Item); ItemList.LookupMode := true; if ItemList.RunModal() = ACTION::LookupOK then begin ItemList.GetRecord(Item); Text := Item."No."; exit(true); end; exit(false); end; trigger OnValidate() begin ItemFilterOnAfterValidate(); end; } field(LocationFilter; LocationFilter) { ApplicationArea = Location; Caption = 'Location Filter'; ToolTip = 'Specifies the locations that statistics are shown for.'; trigger OnLookup(var Text: Text): Boolean var Location: Record Location; Locations: Page "Location List"; begin Locations.SetTableView(Location); Locations.LookupMode := true; if Locations.RunModal() = ACTION::LookupOK then begin Locations.GetRecord(Location); Text := Location.Code; exit(true); end; exit(false); end; } field(VariantFilter; VariantFilter) { ApplicationArea = Planning; Caption = 'Variant Filter'; ToolTip = 'Specifies a filter to specify the variants that will be shown in the window.'; trigger OnLookup(var Text: Text): Boolean var ItemVariant: Record "Item Variant"; ItemVariants: Page "Item Variants"; begin ItemVariant.SetRange("Item No.", Item."No."); ItemVariants.SetTableView(ItemVariant); ItemVariants.LookupMode := true; if ItemVariants.RunModal() = ACTION::LookupOK then begin ItemVariants.GetRecord(ItemVariant); Text := ItemVariant.Code; exit(true); end; exit(false); end; } } group(Options) { Caption = 'Options'; field(RoundingFactor; RoundingFactor) { ApplicationArea = Basic, Suite; Caption = 'Rounding Factor'; ToolTip = 'Specifies the factor that is used to round the amounts.'; } field(PerUnit; PerUnit) { ApplicationArea = Basic, Suite; Caption = 'Calculate per Unit'; ToolTip = 'Specifies that item statistics will be calculated per unit.'; } field(IncludeExpected; IncludeExpected) { ApplicationArea = Basic, Suite; Caption = 'Include Expected'; ToolTip = 'Specifies whether to include costs that have not yet been invoiced in the item statistics. When goods have been received but not yet invoiced, the costs of those receipts are expected costs.'; } } group("Matrix Options") { Caption = 'Matrix Options'; field(ViewBy; PeriodType) { ApplicationArea = Basic, Suite; Caption = 'View by'; ToolTip = 'Specifies by which period amounts are displayed.'; trigger OnValidate() begin FindPeriod(''); PeriodTypeOnAfterValidate(); end; } field(AmountType; AmountType) { ApplicationArea = Basic, Suite; Caption = 'View as'; ToolTip = 'Specifies how amounts are displayed. Net Change: The net change in the balance for the selected period. Balance at Date: The balance as of the last day in the selected period.'; trigger OnValidate() begin GenerateColumnCaptions("Matrix Page Step Type"::Initial); end; } field(MATRIX_CaptionRange; MATRIX_CaptionRange) { ApplicationArea = Basic, Suite; Caption = 'Column Set'; Editable = false; ToolTip = 'Specifies the range of values that are displayed in the matrix window, for example, the total period. To change the contents of the field, choose Next Set or Previous Set.'; } } } } actions { area(processing) { action(ShowMatrix) { ApplicationArea = Basic, Suite; Caption = '&Show Matrix'; Image = ShowMatrix; ToolTip = 'View the data overview according to the selected filters and options.'; trigger OnAction() var MatrixForm: Page "Item Statistics Matrix"; begin Clear(MatrixForm); MatrixForm.LoadMatrix( MATRIX_CaptionSet, MATRIX_MatrixRecords, MATRIX_CurrentNoOfColumns, RoundingFactor, PerUnit, IncludeExpected, ItemBuffer, Item, PeriodType, AmountType, ColumnDimCode, DateFilter, ItemFilter, LocationFilter, VariantFilter); MatrixForm.SetTableView(Rec); MatrixForm.RunModal(); end; } action("Previous Set") { ApplicationArea = Basic, Suite; Caption = 'Previous Set'; Image = PreviousSet; ToolTip = 'Go to the previous set of data.'; trigger OnAction() begin GenerateColumnCaptions("Matrix Page Step Type"::Previous); end; } action("Next Set") { ApplicationArea = Basic, Suite; Caption = 'Next Set'; Image = NextSet; ToolTip = 'Go to the next set of data.'; trigger OnAction() begin GenerateColumnCaptions("Matrix Page Step Type"::Next); end; } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref("Previous Set_Promoted"; "Previous Set") { } actionref(ShowMatrix_Promoted; ShowMatrix) { } actionref("Next Set_Promoted"; "Next Set") { } } } } trigger OnFindRecord(Which: Text): Boolean begin IntegerLineSetFilter(); exit(FindRec(ItemBuffer."Line Option", Rec, Which)); end; trigger OnOpenPage() begin GLSetup.Get(); if Item."No." <> '' then ItemFilter := Item."No."; if Item.GetFilter("Date Filter") <> '' then DateFilter := Item.GetFilter(Item."Date Filter"); if Item.GetFilter("Variant Filter") <> '' then VariantFilter := Item.GetFilter(Item."Variant Filter"); if Item.GetFilter("Location Filter") <> '' then LocationFilter := Item.GetFilter(Item."Location Filter"); if ColumnDimCode = '' then ColumnDimCode := Text002; ItemBuffer."Column Option" := DimCodeToOption(ColumnDimCode); PeriodInitialized := DateFilter <> ''; FindPeriod(''); ItemName := StrSubstNo('%1 %2', Item."No.", Item.Description); GenerateColumnCaptions("Matrix Page Step Type"::Initial); end; var GLSetup: Record "General Ledger Setup"; Item: Record Item; ItemBuffer: Record "Item Statistics Buffer"; IntegerLine: Record "Integer"; MATRIX_MatrixRecords: array[32] of Record "Dimension Code Buffer"; MATRIX_CaptionSet: array[32] of Text[80]; MATRIX_CaptionRange: Text; MATRIX_PrimKeyFirstCaptionInCu: Text; ColumnDimCode: Text[30]; ItemName: Text[250]; PeriodType: Enum "Analysis Period Type"; RoundingFactor: Enum "Analysis Rounding Factor"; AmountType: Enum "Analysis Amount Type"; DateFilter: Text; InternalDateFilter: Text; ItemFilter: Text; VariantFilter: Text; LocationFilter: Text; PeriodInitialized: Boolean; PerUnit: Boolean; IncludeExpected: Boolean;#pragma warning disable AA0074 Text002: Label 'Period';#pragma warning disable AA0470 Text003: Label '%1 is not a valid column definition.';#pragma warning restore AA0470#pragma warning restore AA0074 MATRIX_CurrentNoOfColumns: Integer; local procedure IntegerLineSetFilter() begin if ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Profit Calculation" then IntegerLine.SetRange(Number, 1, 5) else if ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Cost Specification" then IntegerLine.SetRange(Number, 1, 9); OnAfterIntegerLineSetFilter(ItemBuffer, IntegerLine); end; local procedure GenerateColumnCaptions(StepType: Enum "Matrix Page Step Type") var MATRIX_PeriodRecords: array[32] of Record Date; Location: Record Location; MatrixMgt: Codeunit "Matrix Management"; RecRef: RecordRef; i: Integer; begin Clear(MATRIX_CaptionSet); Clear(MATRIX_MatrixRecords); case ColumnDimCode of Text002: begin MatrixMgt.GeneratePeriodMatrixData( StepType.AsInteger(), ArrayLen(MATRIX_CaptionSet), false, PeriodType, DateFilter, MATRIX_PrimKeyFirstCaptionInCu, MATRIX_CaptionSet, MATRIX_CaptionRange, MATRIX_CurrentNoOfColumns, MATRIX_PeriodRecords); for i := 1 to ArrayLen(MATRIX_CaptionSet) do begin MATRIX_MatrixRecords[i]."Period Start" := MATRIX_PeriodRecords[i]."Period Start"; MATRIX_MatrixRecords[i]."Period End" := MATRIX_PeriodRecords[i]."Period End"; end; end; Location.TableCaption: begin Clear(MATRIX_CaptionSet); RecRef.GetTable(Location); RecRef.SetTable(Location); MatrixMgt.GenerateMatrixData( RecRef, StepType.AsInteger(), ArrayLen(MATRIX_CaptionSet), 1, MATRIX_PrimKeyFirstCaptionInCu, MATRIX_CaptionSet, MATRIX_CaptionRange, MATRIX_CurrentNoOfColumns); for i := 1 to MATRIX_CurrentNoOfColumns do MATRIX_MatrixRecords[i].Code := MATRIX_CaptionSet[i]; end; end; end; local procedure DimCodeToOption(DimCode: Text[30]): Enum "Item Statistics Column Option" var Location: Record Location; begin case DimCode of '': exit(Enum::"Item Statistics Column Option"::Undefined); Text002: exit(Enum::"Item Statistics Column Option"::Period); Location.TableCaption(): exit(Enum::"Item Statistics Column Option"::Location); else exit(Enum::"Item Statistics Column Option"::Undefined); end; end; local procedure FindRec(DimOption: Enum "Item Statistics Line Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Which: Text[250]): Boolean var ItemCharge: Record "Item Charge"; Location: Record Location; Period: Record Date; PeriodPageMgt: Codeunit PeriodPageManagement; Found: Boolean; begin case DimOption of DimOption::"Profit Calculation", DimOption::"Cost Specification": begin if Evaluate(IntegerLine.Number, DimCodeBuf.Code) then; Found := IntegerLine.Find(Which); if Found then CopyDimValueToBuf(IntegerLine, DimCodeBuf); end; DimOption::"Purch. Item Charge Spec.", DimOption::"Sales Item Charge Spec.": begin ItemCharge."No." := DimCodeBuf.Code; Found := ItemCharge.Find(Which); if Found then CopyAddChargesToBuf(ItemCharge, DimCodeBuf); end; DimOption::Period: begin if not PeriodInitialized then DateFilter := ''; PeriodInitialized := true; Period."Period Start" := DimCodeBuf."Period Start"; if DateFilter <> '' then Period.SetFilter("Period Start", DateFilter) else if not PeriodInitialized and (InternalDateFilter <> '') then Period.SetFilter("Period Start", InternalDateFilter); Found := PeriodPageMgt.FindDate(Which, Period, PeriodType); if Found then CopyPeriodToBuf(Period, DimCodeBuf); end; DimOption::Location: begin Location.Code := DimCodeBuf.Code; if LocationFilter <> '' then Location.SetFilter(Code, LocationFilter); Found := Location.Find(Which); if Found then CopyLocationToBuf(Location, DimCodeBuf); end; end; exit(Found); end; local procedure CopyDimValueToBuf(var TheDimValue: Record "Integer"; var TheDimCodeBuf: Record "Dimension Code Buffer") begin case ItemBuffer."Line Option" of ItemBuffer."Line Option"::"Profit Calculation": case TheDimValue.Number of 1: InsertRow('1', ItemBuffer.FieldCaption("Sales (LCY)"), 0, false, TheDimCodeBuf); 2: InsertRow('2', ItemBuffer.FieldCaption("COGS (LCY)"), 0, false, TheDimCodeBuf); 3: InsertRow('3', ItemBuffer.FieldCaption("Non-Invtbl. Costs (LCY)"), 0, false, TheDimCodeBuf); 4: InsertRow('4', ItemBuffer.FieldCaption("Profit (LCY)"), 0, false, TheDimCodeBuf); 5: InsertRow('5', ItemBuffer.FieldCaption("Profit %"), 0, false, TheDimCodeBuf); end; ItemBuffer."Line Option"::"Cost Specification": case TheDimValue.Number of 1: InsertRow('1', ItemBuffer.FieldCaption("Inventoriable Costs"), 0, true, TheDimCodeBuf); 2: InsertRow('2', ItemBuffer.FieldCaption("Direct Cost (LCY)"), 1, false, TheDimCodeBuf); 3: InsertRow('3', ItemBuffer.FieldCaption("Revaluation (LCY)"), 1, false, TheDimCodeBuf); 4: InsertRow('4', ItemBuffer.FieldCaption("Rounding (LCY)"), 1, false, TheDimCodeBuf); 5: InsertRow('5', ItemBuffer.FieldCaption("Indirect Cost (LCY)"), 1, false, TheDimCodeBuf); 6: InsertRow('6', ItemBuffer.FieldCaption("Variance (LCY)"), 1, false, TheDimCodeBuf); 7: InsertRow('7', ItemBuffer.FieldCaption("Inventoriable Costs, Total"), 0, true, TheDimCodeBuf); 8: InsertRow('8', ItemBuffer.FieldCaption("COGS (LCY)"), 0, true, TheDimCodeBuf); 9: InsertRow('9', ItemBuffer.FieldCaption("Inventory (LCY)"), 0, true, TheDimCodeBuf); end; end; OnAfterCopyDimValueToBuf(ItemBuffer, TheDimValue, TheDimCodeBuf); end; local procedure CopyAddChargesToBuf(var TheItemCharge: Record "Item Charge"; var TheDimCodeBuf: Record "Dimension Code Buffer") begin TheDimCodeBuf.Init(); TheDimCodeBuf.Code := TheItemCharge."No."; TheDimCodeBuf.Name := CopyStr( StrSubstNo('%1 %2', TheItemCharge."No.", TheItemCharge.Description), 1, 50); end; local procedure CopyLocationToBuf(var TheLocation: Record Location; var TheDimCodeBuf: Record "Dimension Code Buffer") begin TheDimCodeBuf.Init(); TheDimCodeBuf.Code := TheLocation.Code; TheDimCodeBuf.Name := TheLocation.Name; end; local procedure CopyPeriodToBuf(var ThePeriod: Record Date; var TheDimCodeBuf: Record "Dimension Code Buffer") begin TheDimCodeBuf.Init(); TheDimCodeBuf.Code := Format(ThePeriod."Period Start"); TheDimCodeBuf."Period Start" := ThePeriod."Period Start"; TheDimCodeBuf."Period End" := ThePeriod."Period End"; TheDimCodeBuf.Name := ThePeriod."Period Name"; end; local procedure InsertRow(Code1: Code[10]; Name1: Text[80]; Indentation1: Integer; Bold1: Boolean; var TheDimCodeBuf: Record "Dimension Code Buffer") begin TheDimCodeBuf.Init(); TheDimCodeBuf.Code := Code1; TheDimCodeBuf.Name := CopyStr(Name1, 1, MaxStrLen(TheDimCodeBuf.Name)); TheDimCodeBuf.Indentation := Indentation1; TheDimCodeBuf."Show in Bold" := Bold1; end; local procedure FindPeriod(SearchText: Code[10]) var Calendar: Record Date; PeriodPageMgt: Codeunit PeriodPageManagement; begin if DateFilter <> '' then begin Calendar.SetFilter("Period Start", DateFilter); if not PeriodPageMgt.FindDate('+', Calendar, PeriodType) then PeriodPageMgt.FindDate('+', Calendar, PeriodType::Day); Calendar.SetRange("Period Start"); end; PeriodPageMgt.FindDate(SearchText, Calendar, PeriodType); if AmountType = AmountType::"Net Change" then begin ItemBuffer.SetRange("Date Filter", Calendar."Period Start", Calendar."Period End"); if ItemBuffer.GetRangeMin("Date Filter") = ItemBuffer.GetRangeMax(ItemBuffer."Date Filter") then ItemBuffer.SetRange("Date Filter", ItemBuffer.GetRangeMin(ItemBuffer."Date Filter")); end else ItemBuffer.SetRange("Date Filter", 0D, Calendar."Period End"); InternalDateFilter := ItemBuffer.GetFilter("Date Filter"); end; local procedure GetDimSelection(OldDimSelCode: Text[30]): Text[30] var Location: Record Location; DimSelection: Page "Dimension Selection"; begin DimSelection.InsertDimSelBuf(false, Location.TableCaption(), Location.TableCaption()); DimSelection.InsertDimSelBuf(false, Text002, Text002); DimSelection.LookupMode := true; if DimSelection.RunModal() = ACTION::LookupOK then exit(DimSelection.GetDimSelCode()); exit(OldDimSelCode); end; local procedure ValidateColumnDimCode() var Location: Record Location; begin if (UpperCase(ColumnDimCode) <> UpperCase(Location.TableCaption())) and (UpperCase(ColumnDimCode) <> UpperCase(Text002)) and (ColumnDimCode <> '') then begin Message(Text003, ColumnDimCode); ColumnDimCode := ''; end; ItemBuffer."Column Option" := DimCodeToOption(ColumnDimCode); InternalDateFilter := ItemBuffer.GetFilter("Date Filter"); if (ItemBuffer."Line Option" <> ItemBuffer."Line Option"::Period) and (ItemBuffer."Column Option" <> ItemBuffer."Column Option"::Period) then begin DateFilter := InternalDateFilter; if StrPos(DateFilter, '&') > 1 then DateFilter := CopyStr(DateFilter, 1, StrPos(DateFilter, '&') - 1); end else PeriodInitialized := false; end; procedure SetItem(var NewItem: Record Item) begin Item.Get(NewItem."No."); Item.CopyFilters(NewItem); OnAfterSetItem(Item, ItemFilter); end; local procedure ItemBufferLineOptionOnAfterVal() begin CurrPage.Update(); end; local procedure DateFilterOnAfterValidate() begin GenerateColumnCaptions("Matrix Page Step Type"::Initial); CurrPage.Update(); end; local procedure ColumnDimCodeOnAfterValidate() begin CurrPage.Update(); end; local procedure ItemFilterOnAfterValidate() begin Item."No." := ItemFilter; Item.Description := ''; if StrLen(ItemFilter) <= 30 then if Item.Get(ItemFilter) then ItemName := StrSubstNo('%1 %2', Item."No.", Item.Description); ItemName := StrSubstNo('%1 %2', Item."No.", Item.Description); end; local procedure PeriodTypeOnAfterValidate() begin // IF ColumnDimOption = ColumnDimOption::Period THEN if ItemBuffer."Column Option" = ItemBuffer."Column Option"::Period then GenerateColumnCaptions("Matrix Page Step Type"::Initial); end; [IntegrationEvent(false, false)] local procedure OnAfterSetItem(var Item: Record item; var ItemFilter: Text); begin end; [IntegrationEvent(false, false)] local procedure OnAfterIntegerLineSetFilter(var ItemBuffer: Record "Item Statistics Buffer"; var IntegerLine: Record "Integer"); begin end; [IntegrationEvent(false, false)] local procedure OnAfterCopyDimValueToBuf(var ItemBuffer: Record "Item Statistics Buffer"; var TheDimValue: Record "Integer"; var TheDimCodeBuf: Record "Dimension Code Buffer"); begin end;}