Page 9223 Item Statistics Matrix
src/Layers/W1/BaseApp/Inventory/Analysis/ItemStatisticsMatrix.Page.al1,318 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.Foundation.Enums;using Microsoft.Foundation.Period;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using System.Utilities;page 9223 "Item Statistics Matrix"{ Caption = 'Item Statistics Matrix'; DataCaptionExpression = ItemName; Editable = false; LinksAllowed = false; PageType = List; SourceTable = "Dimension Code Buffer"; layout { area(content) { repeater(Control1) { IndentationColumn = NameIndent; IndentationControls = Name; ShowCaption = false; field(Name; Rec.Name) { ApplicationArea = Suite; StyleExpr = 'Strong'; ToolTip = 'Specifies the name of the record.'; } field(Amount; Rec.Amount) { ApplicationArea = Suite; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; Caption = 'Total Amount'; StyleExpr = 'Strong'; ToolTip = 'Specifies the total value for the amount type that you select in the Show field.'; trigger OnDrillDown() begin if not ((ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Profit Calculation") and ((Rec.Name = ItemBuffer.FieldCaption("Profit (LCY)")) or (Rec.Name = ItemBuffer.FieldCaption("Profit %"))) or ((ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Cost Specification") and (Rec.Name = ItemBuffer.FieldCaption("Inventoriable Costs")))) then begin SetCommonFilters(ItemBuffer); SetFilters(ItemBuffer, 0); DrillDown(); end; end; } field(Field1; MATRIX_CellData[1]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[1]; Visible = Field1Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(1); end; } field(Field2; MATRIX_CellData[2]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[2]; Visible = Field2Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(2); end; } field(Field3; MATRIX_CellData[3]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[3]; Visible = Field3Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(3); end; } field(Field4; MATRIX_CellData[4]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[4]; Visible = Field4Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(4); end; } field(Field5; MATRIX_CellData[5]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[5]; Visible = Field5Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(5); end; } field(Field6; MATRIX_CellData[6]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[6]; Visible = Field6Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(6); end; } field(Field7; MATRIX_CellData[7]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[7]; Visible = Field7Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(7); end; } field(Field8; MATRIX_CellData[8]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[8]; Visible = Field8Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(8); end; } field(Field9; MATRIX_CellData[9]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[9]; Visible = Field9Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(9); end; } field(Field10; MATRIX_CellData[10]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[10]; Visible = Field10Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(10); end; } field(Field11; MATRIX_CellData[11]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[11]; Visible = Field11Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(11); end; } field(Field12; MATRIX_CellData[12]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[12]; Visible = Field12Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(12); end; } field(Field13; MATRIX_CellData[13]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[13]; Visible = Field13Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(13); end; } field(Field14; MATRIX_CellData[14]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[14]; Visible = Field14Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(14); end; } field(Field15; MATRIX_CellData[15]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[15]; Visible = Field15Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(15); end; } field(Field16; MATRIX_CellData[16]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[16]; Visible = Field16Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(16); end; } field(Field17; MATRIX_CellData[17]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[17]; Visible = Field17Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(17); end; } field(Field18; MATRIX_CellData[18]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[18]; Visible = Field18Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(18); end; } field(Field19; MATRIX_CellData[19]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[19]; Visible = Field19Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(19); end; } field(Field20; MATRIX_CellData[20]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[20]; Visible = Field20Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(20); end; } field(Field21; MATRIX_CellData[21]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[21]; Visible = Field21Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(21); end; } field(Field22; MATRIX_CellData[22]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[22]; Visible = Field22Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(22); end; } field(Field23; MATRIX_CellData[23]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[23]; Visible = Field23Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(23); end; } field(Field24; MATRIX_CellData[24]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[24]; Visible = Field24Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(24); end; } field(Field25; MATRIX_CellData[25]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[25]; Visible = Field25Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(25); end; } field(Field26; MATRIX_CellData[26]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[26]; Visible = Field26Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(26); end; } field(Field27; MATRIX_CellData[27]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[27]; Visible = Field27Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(27); end; } field(Field28; MATRIX_CellData[28]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[28]; Visible = Field28Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(28); end; } field(Field29; MATRIX_CellData[29]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[29]; Visible = Field29Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(29); end; } field(Field30; MATRIX_CellData[30]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[30]; Visible = Field30Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(30); end; } field(Field31; MATRIX_CellData[31]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[31]; Visible = Field31Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(31); end; } field(Field32; MATRIX_CellData[32]) { ApplicationArea = All; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + MATRIX_CaptionSet[32]; Visible = Field32Visible; trigger OnDrillDown() begin MATRIX_OnDrillDown(32); end; } } } } actions { } trigger OnAfterGetRecord() var MATRIX_Steps: Integer; begin NameIndent := 0; Rec.Amount := Calculate(false); MATRIX_ColumnOrdinal := 0; if MATRIX_OnFindRecord('=><') then begin MATRIX_ColumnOrdinal := 1; repeat MATRIX_OnAfterGetRecord(MATRIX_ColumnOrdinal); MATRIX_Steps := MATRIX_OnNextRecord(1); MATRIX_ColumnOrdinal := MATRIX_ColumnOrdinal + MATRIX_Steps; until (MATRIX_ColumnOrdinal - MATRIX_Steps = ArrayLen(MatrixRecords)) or (MATRIX_Steps = 0); if MATRIX_ColumnOrdinal <> 1 then MATRIX_OnNextRecord(1 - MATRIX_ColumnOrdinal); end; NameOnFormat(); end; trigger OnFindRecord(Which: Text): Boolean begin IntegerLineSetFilter(); exit(FindRec(ItemBuffer."Line Option", Rec, Which)); 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 OnNextRecord(Steps: Integer): Integer begin exit(NextRec(ItemBuffer."Line Option", Rec, Steps)); end; trigger OnOpenPage() begin Field1Visible := 1 <= MATRIX_CurrentNoOfMatrixColumn; Field2Visible := 2 <= MATRIX_CurrentNoOfMatrixColumn; Field3Visible := 3 <= MATRIX_CurrentNoOfMatrixColumn; Field4Visible := 4 <= MATRIX_CurrentNoOfMatrixColumn; Field5Visible := 5 <= MATRIX_CurrentNoOfMatrixColumn; Field6Visible := 6 <= MATRIX_CurrentNoOfMatrixColumn; Field7Visible := 7 <= MATRIX_CurrentNoOfMatrixColumn; Field8Visible := 8 <= MATRIX_CurrentNoOfMatrixColumn; Field9Visible := 9 <= MATRIX_CurrentNoOfMatrixColumn; Field10Visible := 10 <= MATRIX_CurrentNoOfMatrixColumn; Field11Visible := 11 <= MATRIX_CurrentNoOfMatrixColumn; Field12Visible := 12 <= MATRIX_CurrentNoOfMatrixColumn; Field13Visible := 13 <= MATRIX_CurrentNoOfMatrixColumn; Field14Visible := 14 <= MATRIX_CurrentNoOfMatrixColumn; Field15Visible := 15 <= MATRIX_CurrentNoOfMatrixColumn; Field16Visible := 16 <= MATRIX_CurrentNoOfMatrixColumn; Field17Visible := 17 <= MATRIX_CurrentNoOfMatrixColumn; Field18Visible := 18 <= MATRIX_CurrentNoOfMatrixColumn; Field19Visible := 19 <= MATRIX_CurrentNoOfMatrixColumn; Field20Visible := 20 <= MATRIX_CurrentNoOfMatrixColumn; Field21Visible := 21 <= MATRIX_CurrentNoOfMatrixColumn; Field22Visible := 22 <= MATRIX_CurrentNoOfMatrixColumn; Field23Visible := 23 <= MATRIX_CurrentNoOfMatrixColumn; Field24Visible := 24 <= MATRIX_CurrentNoOfMatrixColumn; Field25Visible := 25 <= MATRIX_CurrentNoOfMatrixColumn; Field26Visible := 26 <= MATRIX_CurrentNoOfMatrixColumn; Field27Visible := 27 <= MATRIX_CurrentNoOfMatrixColumn; Field28Visible := 28 <= MATRIX_CurrentNoOfMatrixColumn; Field29Visible := 29 <= MATRIX_CurrentNoOfMatrixColumn; Field30Visible := 30 <= MATRIX_CurrentNoOfMatrixColumn; Field31Visible := 31 <= MATRIX_CurrentNoOfMatrixColumn; Field32Visible := 32 <= MATRIX_CurrentNoOfMatrixColumn; 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); end; var Item: Record Item; ItemBuffer: Record "Item Statistics Buffer"; IntegerLine: Record "Integer"; MatrixRecord: Record "Dimension Code Buffer"; MatrixRecords: array[32] of Record "Dimension Code Buffer"; MatrixMgt: Codeunit "Matrix Management"; 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; ItemChargesFilter: Text; PeriodInitialized: Boolean; PerUnit: Boolean; Qty: Decimal; CellAmount: Decimal;#pragma warning disable AA0074 Text002: Label 'Period';#pragma warning restore AA0074 MATRIX_CurrentNoOfMatrixColumn: Integer; MATRIX_ColumnOrdinal: Integer; MATRIX_CellData: array[32] of Decimal; MATRIX_CaptionSet: array[32] of Text[80]; RoundingFactorFormatString: Text; 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; NameIndent: Integer; protected var IncludeExpected: Boolean; 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 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 Column 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.Reset(); if DateFilter <> '' then Period.SetFilter("Period Start", DateFilter) else if not PeriodInitialized and (InternalDateFilter <> '') then Period.SetFilter("Period Start", InternalDateFilter); if DimCodeBuf."Period Start" = 0D then Period.FindFirst() else Period."Period Start" := DimCodeBuf."Period Start"; 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 NextRec(DimOption: Enum "Item Statistics Column Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Steps: Integer): Integer var ItemCharge: Record "Item Charge"; Location: Record Location; Period: Record Date; PeriodPageMgt: Codeunit PeriodPageManagement; ResultSteps: Integer; begin case DimOption of DimOption::"Profit Calculation", DimOption::"Cost Specification": begin if Evaluate(IntegerLine.Number, DimCodeBuf.Code) then; ResultSteps := IntegerLine.Next(Steps); if ResultSteps <> 0 then CopyDimValueToBuf(IntegerLine, DimCodeBuf); end; DimOption::"Purch. Item Charge Spec.", DimOption::"Sales Item Charge Spec.": begin ItemCharge."No." := DimCodeBuf.Code; if ItemChargesFilter <> '' then ItemCharge.SetFilter("No.", ItemChargesFilter); ResultSteps := ItemCharge.Next(Steps); if ResultSteps <> 0 then CopyAddChargesToBuf(ItemCharge, DimCodeBuf); end; DimOption::Period: begin if DateFilter <> '' then Period.SetFilter("Period Start", DateFilter); Period."Period Start" := DimCodeBuf."Period Start"; ResultSteps := PeriodPageMgt.NextDate(Steps, Period, PeriodType); if ResultSteps <> 0 then CopyPeriodToBuf(Period, DimCodeBuf); end; DimOption::Location: begin Location.Code := DimCodeBuf.Code; if LocationFilter <> '' then Location.SetFilter(Code, LocationFilter); ResultSteps := Location.Next(Steps); if ResultSteps <> 0 then CopyLocationToBuf(Location, DimCodeBuf); end; end; exit(ResultSteps); 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; protected 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("Date Filter") then ItemBuffer.SetRange("Date Filter", ItemBuffer.GetRangeMin("Date Filter")); end else ItemBuffer.SetRange("Date Filter", 0D, Calendar."Period End"); InternalDateFilter := ItemBuffer.GetFilter("Date Filter"); end; local procedure DrillDown() var ValueEntry: Record "Value Entry"; begin ValueEntry.SetCurrentKey( "Item No.", "Posting Date", "Item Ledger Entry Type", "Entry Type", "Variance Type", "Item Charge No.", "Location Code", "Variant Code"); if ItemBuffer.GetFilter("Item Filter") <> '' then ItemBuffer.CopyFilter("Item Filter", ValueEntry."Item No."); if ItemBuffer.GetFilter("Date Filter") <> '' then ItemBuffer.CopyFilter("Date Filter", ValueEntry."Posting Date") else ValueEntry.SetRange("Posting Date", 0D, DMY2Date(31, 12, 9999)); if ItemBuffer.GetFilter("Entry Type Filter") <> '' then ItemBuffer.CopyFilter("Entry Type Filter", ValueEntry."Entry Type"); if ItemBuffer.GetFilter("Item Ledger Entry Type Filter") <> '' then ItemBuffer.CopyFilter("Item Ledger Entry Type Filter", ValueEntry."Item Ledger Entry Type"); if ItemBuffer.GetFilter("Variance Type Filter") <> '' then ItemBuffer.CopyFilter("Variance Type Filter", ValueEntry."Variance Type"); if ItemBuffer.GetFilter("Item Charge No. Filter") <> '' then ItemBuffer.CopyFilter("Item Charge No. Filter", ValueEntry."Item Charge No."); if ItemBuffer.GetFilter("Location Filter") <> '' then ItemBuffer.CopyFilter("Location Filter", ValueEntry."Location Code"); if ItemBuffer.GetFilter("Variant Filter") <> '' then ItemBuffer.CopyFilter("Variant Filter", ValueEntry."Variant Code"); case true of ((ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Profit Calculation") and (Rec.Name = ItemBuffer.FieldCaption("Sales (LCY)"))) or (ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Sales Item Charge Spec."): PAGE.Run(0, ValueEntry, ValueEntry."Sales Amount (Actual)"); Rec.Name = ItemBuffer.FieldCaption("Non-Invtbl. Costs (LCY)"): PAGE.Run(0, ValueEntry, ValueEntry."Cost Amount (Non-Invtbl.)"); else PAGE.Run(0, ValueEntry, ValueEntry."Cost Amount (Actual)"); end; end; protected procedure SetCommonFilters(var TheItemBuffer: Record "Item Statistics Buffer") begin TheItemBuffer.Reset(); if ItemFilter <> '' then TheItemBuffer.SetFilter("Item Filter", ItemFilter); if DateFilter <> '' then TheItemBuffer.SetFilter("Date Filter", DateFilter); if LocationFilter <> '' then TheItemBuffer.SetFilter("Location Filter", LocationFilter); if VariantFilter <> '' then TheItemBuffer.SetFilter("Variant Filter", VariantFilter); end; protected procedure SetFilters(var ItemBuffer: Record "Item Statistics Buffer"; LineOrColumn: Option Line,Column) var DimCodeBuf: Record "Dimension Code Buffer"; DimOption: Enum "Item Statistics Column Option"; begin if LineOrColumn = LineOrColumn::Line then begin DimCodeBuf := Rec; DimOption := ItemBuffer."Line Option"; end else begin DimCodeBuf := MatrixRecords[MATRIX_ColumnOrdinal]; DimOption := ItemBuffer."Column Option"; end; case DimOption of DimOption::Location: ItemBuffer.SetRange("Location Filter", DimCodeBuf.Code); DimOption::Period: if AmountType = AmountType::"Net Change" then ItemBuffer.SetRange("Date Filter", DimCodeBuf."Period Start", DimCodeBuf."Period End") else ItemBuffer.SetRange("Date Filter", 0D, DimCodeBuf."Period End"); DimOption::"Profit Calculation", DimOption::"Cost Specification": case Rec.Name of ItemBuffer.FieldCaption("Sales (LCY)"), ItemBuffer.FieldCaption("COGS (LCY)"), ItemBuffer.FieldCaption("Profit (LCY)"), ItemBuffer.FieldCaption("Profit %"): begin ItemBuffer.SetRange("Item Ledger Entry Type Filter", ItemBuffer."Item Ledger Entry Type Filter"::Sale); if DimOption = DimOption::"Profit Calculation" then ItemBuffer.SetFilter("Entry Type Filter", '<>%1', ItemBuffer."Entry Type Filter"::Revaluation); ItemBuffer.SetRange("Variance Type Filter", ItemBuffer."Variance Type Filter"::" "); end; ItemBuffer.FieldCaption("Direct Cost (LCY)"), ItemBuffer.FieldCaption("Revaluation (LCY)"), ItemBuffer.FieldCaption("Rounding (LCY)"), ItemBuffer.FieldCaption("Indirect Cost (LCY)"), ItemBuffer.FieldCaption("Variance (LCY)"), ItemBuffer.FieldCaption("Inventoriable Costs, Total"): begin ItemBuffer.SetFilter( ItemBuffer."Item Ledger Entry Type Filter", '<>%1&<>%2', ItemBuffer."Item Ledger Entry Type Filter"::Sale, ItemBuffer."Item Ledger Entry Type Filter"::" "); ItemBuffer.SetRange("Variance Type Filter", ItemBuffer."Variance Type Filter"::" "); case Rec.Name of ItemBuffer.FieldCaption("Direct Cost (LCY)"): ItemBuffer.SetRange("Entry Type Filter", ItemBuffer."Entry Type Filter"::"Direct Cost"); ItemBuffer.FieldCaption("Revaluation (LCY)"): ItemBuffer.SetRange("Entry Type Filter", ItemBuffer."Entry Type Filter"::Revaluation); ItemBuffer.FieldCaption("Rounding (LCY)"): ItemBuffer.SetRange("Entry Type Filter", ItemBuffer."Entry Type Filter"::Rounding); ItemBuffer.FieldCaption("Indirect Cost (LCY)"): ItemBuffer.SetRange("Entry Type Filter", ItemBuffer."Entry Type Filter"::"Indirect Cost"); ItemBuffer.FieldCaption("Variance (LCY)"): begin ItemBuffer.SetRange("Entry Type Filter", ItemBuffer."Entry Type Filter"::Variance); ItemBuffer.SetFilter("Variance Type Filter", '<>%1', ItemBuffer."Variance Type Filter"::" "); end; ItemBuffer.FieldCaption("Inventoriable Costs, Total"): ItemBuffer.SetRange("Variance Type Filter"); end; end; else ItemBuffer.SetRange("Item Ledger Entry Type Filter"); ItemBuffer.SetRange("Variance Type Filter"); end; DimOption::"Purch. Item Charge Spec.": begin ItemBuffer.SetRange("Variance Type Filter", ItemBuffer."Variance Type Filter"::" "); ItemBuffer.SetRange("Item Ledger Entry Type Filter", ItemBuffer."Item Ledger Entry Type Filter"::Purchase); ItemBuffer.SetRange("Item Charge No. Filter", DimCodeBuf.Code); end; DimOption::"Sales Item Charge Spec.": begin ItemBuffer.SetRange("Variance Type Filter", ItemBuffer."Variance Type Filter"::" "); ItemBuffer.SetRange("Item Ledger Entry Type Filter", ItemBuffer."Item Ledger Entry Type Filter"::Sale); ItemBuffer.SetRange("Item Charge No. Filter", DimCodeBuf.Code); end; else OnSetFiltersElseCase(ItemBuffer, DimCodeBuf); end; if ItemBuffer.GetFilter(ItemBuffer."Item Ledger Entry Type Filter") = '' then ItemBuffer.SetFilter( ItemBuffer."Item Ledger Entry Type Filter", '<>%1', ItemBuffer."Item Ledger Entry Type Filter"::" ") end; local procedure Calculate(SetColumnFilter: Boolean) Amount: Decimal begin OnBeforeCalculate(ItemBuffer, Amount, Qty, Rec.Name, SetColumnFilter); case ItemBuffer."Line Option" of ItemBuffer."Line Option"::"Profit Calculation", ItemBuffer."Line Option"::"Cost Specification": case Rec.Name of ItemBuffer.FieldCaption("Sales (LCY)"): Amount := CalcSalesAmount(SetColumnFilter); ItemBuffer.FieldCaption("COGS (LCY)"): Amount := CalcCostAmount(SetColumnFilter); ItemBuffer.FieldCaption("Non-Invtbl. Costs (LCY)"): Amount := CalcCostAmountNonInvnt(SetColumnFilter); ItemBuffer.FieldCaption("Profit (LCY)"): Amount := CalcSalesAmount(SetColumnFilter) + CalcCostAmount(SetColumnFilter) + CalcCostAmountNonInvnt(SetColumnFilter); ItemBuffer.FieldCaption("Profit %"): if CalcSalesAmount(SetColumnFilter) <> 0 then Amount := Round(100 * (CalcSalesAmount(SetColumnFilter) + CalcCostAmount(SetColumnFilter) + CalcCostAmountNonInvnt(SetColumnFilter)) / CalcSalesAmount(SetColumnFilter)) else Amount := 0; ItemBuffer.FieldCaption("Direct Cost (LCY)"), ItemBuffer.FieldCaption("Revaluation (LCY)"), ItemBuffer.FieldCaption("Rounding (LCY)"), ItemBuffer.FieldCaption("Indirect Cost (LCY)"), ItemBuffer.FieldCaption("Variance (LCY)"), ItemBuffer.FieldCaption("Inventory (LCY)"), ItemBuffer.FieldCaption("Inventoriable Costs, Total"): Amount := CalcCostAmount(SetColumnFilter); else Amount := 0; end; ItemBuffer."Line Option"::"Sales Item Charge Spec.": Amount := CalcSalesAmount(SetColumnFilter); ItemBuffer."Line Option"::"Purch. Item Charge Spec.": Amount := CalcCostAmount(SetColumnFilter); end; if PerUnit then begin if (ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Profit Calculation") and (Rec.Name = ItemBuffer.FieldCaption("Profit %")) then Qty := 1 else Qty := CalcQty(SetColumnFilter); if Qty <> 0 then Amount := Amount / Abs(Qty) else Amount := 0; end; if Rec.Name <> ItemBuffer.FieldCaption("Profit %") then Amount := MatrixMgt.RoundAmount(Amount, RoundingFactor); OnAfterCalculate(ItemBuffer, SetColumnFilter, Amount, Rec.Name, CalcSalesAmount(SetColumnFilter)); end; local procedure CalcSalesAmount(SetColumnFilter: Boolean): Decimal begin SetCommonFilters(ItemBuffer); SetFilters(ItemBuffer, 0); if SetColumnFilter then SetFilters(ItemBuffer, 1); if IncludeExpected then begin ItemBuffer.CalcFields("Sales Amount (Actual)", "Sales Amount (Expected)"); exit(ItemBuffer."Sales Amount (Actual)" + ItemBuffer."Sales Amount (Expected)"); end; ItemBuffer.CalcFields("Sales Amount (Actual)"); exit(ItemBuffer."Sales Amount (Actual)"); end; local procedure CalcCostAmount(SetColumnFilter: Boolean): Decimal begin SetCommonFilters(ItemBuffer); SetFilters(ItemBuffer, 0); if SetColumnFilter then SetFilters(ItemBuffer, 1); if IncludeExpected then begin ItemBuffer.CalcFields("Cost Amount (Actual)", "Cost Amount (Expected)"); exit(ItemBuffer."Cost Amount (Actual)" + ItemBuffer."Cost Amount (Expected)"); end; ItemBuffer.CalcFields("Cost Amount (Actual)"); exit(ItemBuffer."Cost Amount (Actual)"); end; local procedure CalcCostAmountNonInvnt(SetColumnFilter: Boolean): Decimal var ValueEntry: Record "Value Entry"; TotalCostAmountNonInvnt: Decimal; begin SetCommonFilters(ItemBuffer); SetFilters(ItemBuffer, 0); if SetColumnFilter then SetFilters(ItemBuffer, 1); ItemBuffer.SetRange("Item Ledger Entry Type Filter"); CopyValueEntryFilters(ValueEntry); if ValueEntry.FindSet() then repeat case ValueEntry."Document Type" of ValueEntry."Document Type"::"Purchase Credit Memo": TotalCostAmountNonInvnt -= ValueEntry."Cost Amount (Non-Invtbl.)"; ValueEntry."Document Type"::"Purchase Invoice": TotalCostAmountNonInvnt += GetSign(ValueEntry) * ValueEntry."Cost Amount (Non-Invtbl.)" else TotalCostAmountNonInvnt += ValueEntry."Cost Amount (Non-Invtbl.)"; end; until ValueEntry.Next() = 0; exit(TotalCostAmountNonInvnt); end; local procedure CalcQty(SetColumnFilter: Boolean): Decimal begin SetCommonFilters(ItemBuffer); SetFilters(ItemBuffer, 0); if SetColumnFilter then SetFilters(ItemBuffer, 1); ItemBuffer.SetRange("Entry Type Filter"); ItemBuffer.SetRange("Item Charge No. Filter"); if IncludeExpected then begin ItemBuffer.CalcFields(Quantity); exit(ItemBuffer.Quantity); end; ItemBuffer.CalcFields("Invoiced Quantity"); exit(ItemBuffer."Invoiced Quantity"); end; procedure SetItem(var NewItem: Record Item) begin Item.Get(NewItem."No."); Item.CopyFilters(NewItem); end; procedure LoadMatrix(NewMatrixColumns: array[32] of Text[1024]; var NewMatrixRecords: array[32] of Record "Dimension Code Buffer"; CurrentNoOfMatrixColumns: Integer; NewRoundingFactor: Enum "Analysis Rounding Factor"; NewPerUnit: Boolean; NewIncludeExpected: Boolean; NewItemBuffer: Record "Item Statistics Buffer"; NewItem: Record Item; NewPeriodType: Enum "Analysis Period Type"; NewAmountType: Enum "Analysis Amount Type"; NewColumnDimCode: Text[30]; NewDateFilter: Text; NewItemFilter: Text; NewLocationFilter: Text; NewVariantFilter: Text) begin CopyArray(MATRIX_CaptionSet, NewMatrixColumns, 1); CopyArray(MatrixRecords, NewMatrixRecords, 1); MATRIX_CurrentNoOfMatrixColumn := CurrentNoOfMatrixColumns; RoundingFactor := NewRoundingFactor; PerUnit := NewPerUnit; IncludeExpected := NewIncludeExpected; ItemBuffer := NewItemBuffer; Item := NewItem; PeriodType := NewPeriodType; AmountType := NewAmountType; ColumnDimCode := NewColumnDimCode; DateFilter := NewDateFilter; ItemFilter := NewItemFilter; LocationFilter := NewLocationFilter; VariantFilter := NewVariantFilter; RoundingFactorFormatString := MatrixMgt.FormatRoundingFactor(RoundingFactor, false); end; local procedure MATRIX_OnDrillDown(_MATRIX_ColumnOrdinal: Integer) begin if not ((ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Profit Calculation") and ((Rec.Name = ItemBuffer.FieldCaption(ItemBuffer."Profit (LCY)")) or (Rec.Name = ItemBuffer.FieldCaption(ItemBuffer."Profit %"))) or ((ItemBuffer."Line Option" = ItemBuffer."Line Option"::"Cost Specification") and (Rec.Name = ItemBuffer.FieldCaption(ItemBuffer."Inventoriable Costs")))) then begin SetCommonFilters(ItemBuffer); SetFilters(ItemBuffer, 0); MATRIX_ColumnOrdinal := _MATRIX_ColumnOrdinal; SetFilters(ItemBuffer, 1); DrillDown(); end; end; local procedure MATRIX_OnAfterGetRecord(MATRIX_ColumnOrdinal: Integer) begin CellAmount := Calculate(true); MATRIX_CellData[MATRIX_ColumnOrdinal] := CellAmount; end; local procedure MATRIX_OnFindRecord(Which: Text[1024]): Boolean begin exit(FindRec(ItemBuffer."Column Option", MatrixRecord, Which)); end; local procedure MATRIX_OnNextRecord(Steps: Integer): Integer begin exit(NextRec(ItemBuffer."Column Option", MatrixRecord, Steps)); end; local procedure NameOnFormat() begin NameIndent := Rec.Indentation; end; local procedure CopyValueEntryFilters(var ValueEntry: Record "Value Entry") begin ValueEntry.SetFilter("Item No.", ItemFilter); ValueEntry.SetFilter("Variant Code", VariantFilter); ValueEntry.SetFilter("Item Ledger Entry Type", ItemBuffer.GetFilter("Item Ledger Entry Type Filter")); ValueEntry.SetFilter("Variance Type", ItemBuffer.GetFilter("Variance Type Filter")); ValueEntry.SetFilter("Entry Type", ItemBuffer.GetFilter("Entry Type Filter")); ValueEntry.SetFilter("Global Dimension 1 Code", ItemBuffer.GetFilter("Global Dimension 1 Filter")); ValueEntry.SetFilter("Global Dimension 2 Code", ItemBuffer.GetFilter("Global Dimension 2 Filter")); ValueEntry.SetFilter("Item Charge No.", ItemBuffer.GetFilter("Item Charge No. Filter")); ValueEntry.SetFilter("Source Type", ItemBuffer.GetFilter("Source Type Filter")); ValueEntry.SetFilter("Source Code", ItemBuffer.GetFilter("Source No. Filter")); ValueEntry.SetFilter("Posting Date", ItemBuffer.GetFilter("Date Filter")); ValueEntry.SetFilter("Location Code", ItemBuffer.GetFilter("Location Filter")); end; local procedure GetSign(ValueEntry: Record "Value Entry"): Decimal var ItemLedgerEntry: Record "Item Ledger Entry"; begin ItemLedgerEntry.Get(ValueEntry."Item Ledger Entry No."); if (ValueEntry."Item Ledger Entry Type" = ValueEntry."Item Ledger Entry Type"::Purchase) and (ItemLedgerEntry."Entry Type" = ItemLedgerEntry."Entry Type"::Sale) then exit(1); exit(-1); end; local procedure FormatStr(): Text begin exit(RoundingFactorFormatString); end; [IntegrationEvent(false, false)] local procedure OnSetFiltersElseCase(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; var DimensionCodeBuffer: Record "Dimension Code Buffer") begin end; [IntegrationEvent(false, false)] local procedure OnAfterIntegerLineSetFilter(var ItemBuffer: Record "Item Statistics Buffer"; var IntegerLine: Record "Integer"); begin end; [IntegrationEvent(true, false)] local procedure OnAfterCopyDimValueToBuf(var ItemBuffer: Record "Item Statistics Buffer"; var TheDimValue: Record "Integer"; var TheDimCodeBuf: Record "Dimension Code Buffer"); begin end; [IntegrationEvent(false, false)] local procedure OnAfterCalculate(var ItemBuffer: Record "Item Statistics Buffer"; SetColumnFilter: Boolean; var Amount: Decimal; Name: Text[100]; SalesAmount: Decimal); begin end; [IntegrationEvent(true, false)] local procedure OnBeforeCalculate(var ItemStatisticsBuffer: Record "Item Statistics Buffer"; var Amount: Decimal; var Qty: Decimal; Name: Text; SetColumnFilter: Boolean) begin end;}