Report 7150 Item Dimensions - Detail
src/Layers/W1/BaseApp/Inventory/Reports/ItemDimensionsDetail.Report.al815 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.Reports;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Period;using Microsoft.Inventory.Analysis;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using System.Text;using System.Utilities;report 7150 "Item Dimensions - Detail"{ ApplicationArea = Dimensions; Caption = 'Item Dimensions - Detail'; ToolTip = 'Run the Item Dimensions - Detail report.'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Item Analysis View"; "Item Analysis View") { DataItemTableView = sorting("Analysis Area", Code); column(ViewLastUpdatedText; ViewLastUpdatedText) { } column(Name_ItemAnalysisView; Name) { } column(Code_ItemAnalysisView; Code) { } column(DateFilter; DateFilter) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(TodayFormatted; Format(Today, 0, 4)) { } column(DimFilterText; DimFilterText) { } column(PeriodCaption; PeriodCaptionLbl) { } column(AnalysisViewCaption; AnalysisViewCaptionLbl) { } column(LastDateUpdatedCaption; LastDateUpdatedCaptionLbl) { } column(PageCaption; PageCaptionLbl) { } column(ItemDimsDetailCptn; ItemDimsDetailCptnLbl) { } column(FiltersCaption; FiltersCaptionLbl) { } column(CostAmtCaption; CostAmtCaptionLbl) { } column(SalesAmtCaption; SalesAmtCaptionLbl) { } column(DescriptionCaption; DescriptionCaptionLbl) { } column(PostingDateCaption; PostingDateCaptionLbl) { } column(ItemNoCaption; ItemNoCaptionLbl) { } column(EntryNoCaption; EntryNoCaptionLbl) { } column(QuantityCaption; QuantityCaptionLbl) { } dataitem(Level1; "Integer") { DataItemTableView = sorting(Number); column(DimValCode1; DimValCode[1]) { } column(DimCode1; DimCode[1]) { } column(DimValName1; DimValName[1]) { } dataitem(Level2; "Integer") { DataItemTableView = sorting(Number); column(DimValCode2; DimValCode[2]) { } column(DimCode2; DimCode[2]) { } column(DimValName2; DimValName[2]) { } column(TempValueEntryItemNo; TempValueEntry."Item No.") { } column(TempValueEntryPostingDate; Format(TempValueEntry."Posting Date")) { } column(TempValueEntryDescription; TempValueEntry.Description) { } column(TempValEntrySaleAmtActExp; TempValueEntry."Sales Amount (Actual)" + TempValueEntry."Sales Amount (Expected)") { } column(TVECostAmtActExpNonInvtbl; TempValueEntry."Cost Amount (Actual)" + TempValueEntry."Cost Amount (Expected)" + TempValueEntry."Cost Amount (Non-Invtbl.)") { } column(TempValueEntryEntryNo; TempValueEntry."Entry No.") { } column(TempValueEntryValuedQty; TempValueEntry."Valued Quantity") { DecimalPlaces = 0 : 5; } dataitem(Level3; "Integer") { DataItemTableView = sorting(Number); column(DimValCode3; DimValCode[3]) { } column(DimCode3; DimCode[3]) { } column(DimValName3; DimValName[3]) { } dataitem(Level4; "Integer") { DataItemTableView = sorting(Number); column(DimValCode4; DimValCode[4]) { } column(DimCode4; DimCode[4]) { } column(DimValName4; DimValName[4]) { } trigger OnAfterGetRecord() begin if DimCode[4] <> '' then begin if not CalcLine(4) and not PrintEmptyLines then CurrReport.Skip(); end else if not PrintDetail(4) then CurrReport.Break(); end; trigger OnPreDataItem() begin if DimCode[3] = '' then CurrReport.Break(); FindFirstDim[4] := true; FindFirstValueEntry[4] := true; end; } dataitem(Level3e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(SalesAmtTotal3; SalesAmtTotal[3]) { AutoFormatType = 1; } column(CostAmtTotal3; CostAmtTotal[3]) { AutoFormatType = 1; } column(QtyTotal3; QtyTotal[3]) { AutoFormatType = 1; DecimalPlaces = 0 : 5; } trigger OnPostDataItem() begin SalesAmtTotal[3] := 0; CostAmtTotal[3] := 0; QtyTotal[3] := 0; end; } trigger OnAfterGetRecord() begin if DimCode[3] <> '' then begin if not CalcLine(3) and not PrintEmptyLines then CurrReport.Skip(); end else if not PrintDetail(3) then CurrReport.Break(); end; trigger OnPreDataItem() begin if DimCode[2] = '' then CurrReport.Break(); FindFirstDim[3] := true; FindFirstValueEntry[3] := true; end; } dataitem(Level2e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(SalesAmtTotal2; SalesAmtTotal[2]) { AutoFormatType = 1; } column(CostAmtTotal2; CostAmtTotal[2]) { AutoFormatType = 1; } column(QtyTotal2; QtyTotal[2]) { AutoFormatType = 1; DecimalPlaces = 0 : 5; } trigger OnPostDataItem() begin SalesAmtTotal[2] := 0; CostAmtTotal[2] := 0; QtyTotal[2] := 0; end; } trigger OnAfterGetRecord() begin if DimCode[2] <> '' then begin if not CalcLine(2) and not PrintEmptyLines then CurrReport.Skip(); end else if not PrintDetail(2) then CurrReport.Break(); end; trigger OnPreDataItem() begin if DimCode[1] = '' then CurrReport.Break(); FindFirstDim[2] := true; FindFirstValueEntry[2] := true; end; } dataitem(Level1e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(CostAmtTotal1; CostAmtTotal[1]) { AutoFormatType = 1; } column(SalesAmtTotal1; SalesAmtTotal[1]) { AutoFormatType = 1; } column(QtyTotal1; QtyTotal[1]) { AutoFormatType = 1; DecimalPlaces = 0 : 5; } trigger OnPostDataItem() begin SalesAmtTotal[1] := 0; CostAmtTotal[1] := 0; QtyTotal[1] := 0; end; } trigger OnAfterGetRecord() begin if not CalcLine(1) and not PrintEmptyLines then CurrReport.Skip(); end; trigger OnPreDataItem() begin if DimCode[1] = '' then CurrReport.Break(); FindFirstDim[1] := true; FindFirstValueEntry[1] := true; end; } trigger OnAfterGetRecord() var AccountingPeriod: Record "Accounting Period"; i: Integer; StartDate: Date; EndDate: Date; ThisFilter: Text[250]; begin if "Last Date Updated" <> 0D then ViewLastUpdatedText := StrSubstNo('%1', "Last Date Updated") else ViewLastUpdatedText := Text004; ItemAnalysisViewEntry.Reset(); ItemAnalysisViewEntry.SetRange("Analysis Area", "Analysis Area"); ItemAnalysisViewEntry.SetRange("Analysis View Code", Code); ItemAnalysisViewEntry.SetFilter("Posting Date", DateFilter); StartDate := ItemAnalysisViewEntry.GetRangeMin("Posting Date"); EndDate := ItemAnalysisViewEntry.GetRangeMax("Posting Date"); case "Date Compression" of "Date Compression"::Week: begin StartDate := CalcDate('<CW+1D-1W>', StartDate); EndDate := ClosingDate(CalcDate('<CW>', EndDate)); end; "Date Compression"::Month: begin StartDate := CalcDate('<CM+1D-1M>', StartDate); EndDate := ClosingDate(CalcDate('<CM>', EndDate)); end; "Date Compression"::Quarter: begin StartDate := CalcDate('<CQ+1D-1Q>', StartDate); EndDate := ClosingDate(CalcDate('<CQ>', EndDate)); end; "Date Compression"::Year: begin StartDate := CalcDate('<CY+1D-1Y>', StartDate); EndDate := ClosingDate(CalcDate('<CY>', EndDate)); end; "Date Compression"::Period: begin AccountingPeriod.SetRange("Starting Date", 0D, StartDate); if AccountingPeriod.Find('+') then StartDate := AccountingPeriod."Starting Date"; AccountingPeriod.SetRange("Starting Date", EndDate, DMY2Date(31, 12, 9999)); if AccountingPeriod.Find('-') then if AccountingPeriod.Next() <> 0 then EndDate := ClosingDate(AccountingPeriod."Starting Date" - 1); end; end; ItemAnalysisViewEntry.SetRange("Posting Date", StartDate, EndDate); ItemAnalysisViewEntry.FilterGroup(2); TempAnalysisSelectedDim.Reset(); TempAnalysisSelectedDim.SetCurrentKey( "User ID", "Object Type", "Object ID", "Analysis Area", "Analysis View Code", Level); TempAnalysisSelectedDim.SetFilter("Dimension Value Filter", '<>%1', ''); DimFilterText := ''; if TempAnalysisSelectedDim.Find('-') then repeat ThisFilter := ''; if DimFilterText <> '' then ThisFilter := ', '; ThisFilter := ThisFilter + TempAnalysisSelectedDim."Dimension Code" + ': ' + TempAnalysisSelectedDim."Dimension Value Filter"; if StrLen(DimFilterText) + StrLen(ThisFilter) <= 250 then DimFilterText := DimFilterText + ThisFilter; SetItemAnalysisViewEntryFilter( TempAnalysisSelectedDim."Dimension Code", TempAnalysisSelectedDim."Dimension Value Filter"); until TempAnalysisSelectedDim.Next() = 0; ItemAnalysisViewEntry.FilterGroup(0); TempAnalysisSelectedDim.Reset(); TempAnalysisSelectedDim.SetCurrentKey( "User ID", "Object Type", "Object ID", "Analysis Area", "Analysis View Code", Level); TempAnalysisSelectedDim.SetFilter(Level, '<>%1', TempAnalysisSelectedDim.Level::" "); i := 1; if TempAnalysisSelectedDim.Find('-') then repeat DimCode[i] := TempAnalysisSelectedDim."Dimension Code"; LevelFilter[i] := TempAnalysisSelectedDim."Dimension Value Filter"; i := i + 1; until (TempAnalysisSelectedDim.Next() = 0) or (i > 3); end; trigger OnPreDataItem() begin SetRange("Analysis Area", AnalysisArea); SetRange(Code, ItemAnalysisViewCode); end; } } requestpage { AboutTitle = 'About Item Dimensions - Detail'; AboutText = 'Build a grouping of dimensions for each permutation of dimension values, defined through a hierarchy of dimension levels from an analysis view, and list all GL entries for each group.'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(AnalysisArea; AnalysisArea) { ApplicationArea = Dimensions; Caption = 'Analysis Area'; ToolTip = 'Specifies if the analysis area is set up in the Sales, Purchasing, or Inventory application area.'; trigger OnValidate() begin ItemAnalysisViewCode := ''; UpdateColumnDim(); end; } field(AnalysisViewCode; ItemAnalysisViewCode) { ApplicationArea = Dimensions; Caption = 'Analysis View Code'; ToolTip = 'Specifies the code for the analysis view that the filter belongs to.'; trigger OnLookup(var Text: Text): Boolean var ItemAnalysisView: Record "Item Analysis View"; begin ItemAnalysisView.FilterGroup := 2; ItemAnalysisView.SetRange("Analysis Area", AnalysisArea); ItemAnalysisView.FilterGroup := 0; if PAGE.RunModal(0, ItemAnalysisView) = ACTION::LookupOK then begin Text := ItemAnalysisView.Code; UpdateColumnDim(); exit(true); end; end; trigger OnValidate() var ItemAnalysisView: Record "Item Analysis View"; begin if ItemAnalysisViewCode <> '' then ItemAnalysisView.Get(AnalysisArea, ItemAnalysisViewCode); UpdateColumnDim(); end; } field(IncludeDimensions; ColumnDim) { ApplicationArea = Dimensions; Caption = 'Include Dimensions'; Editable = false; ToolTip = 'Specifies the dimensions that you want to include in the report. You can only select dimensions included in the analysis view that you selected in the Analysis View field.'; trigger OnAssistEdit() begin AnalysisDimSelectionBuf.SetDimSelectionLevel( 3, REPORT::"Item Dimensions - Detail", AnalysisArea.AsInteger(), ItemAnalysisViewCode, ColumnDim); end; } field(DateFilterCtrl; DateFilter) { ApplicationArea = Dimensions; Caption = 'Date Filter'; ToolTip = 'Specifies a filter, that will filter entries by date. You can enter a particular date or a time interval.'; trigger OnValidate() var FilterTokens: Codeunit "Filter Tokens"; begin FilterTokens.MakeDateFilter(DateFilter); TempItem.SetFilter("Date Filter", DateFilter); DateFilter := TempItem.GetFilter("Date Filter"); end; } field(PrintEmptyLines; PrintEmptyLines) { ApplicationArea = Dimensions; Caption = 'Print Empty Lines'; MultiLine = true; ToolTip = 'Specifies if you want the report to include dimensions and dimension values that have a balance equal to zero.'; } } } } actions { } trigger OnOpenPage() begin UpdateColumnDim(); end; } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Inventory/Reports/ItemDimensionsDetail.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() var AnalysisSelectedDim: Record "Analysis Selected Dimension"; begin if ItemAnalysisViewCode = '' then Error(Text000); if DateFilter = '' then Error(Text001); AnalysisDimSelectionBuf.CompareDimText( 3, REPORT::"Item Dimensions - Detail", AnalysisArea.AsInteger(), ItemAnalysisViewCode, ColumnDim, Text002); TempAnalysisSelectedDim.Reset(); TempAnalysisSelectedDim.SetFilter("Dimension Value Filter", '<>%1', ''); TempAnalysisSelectedDim.SetFilter("Dimension Code", TempItem.TableCaption()); if TempAnalysisSelectedDim.Find('-') then Item.SetFilter("No.", TempAnalysisSelectedDim."Dimension Value Filter"); if Item.Find('-') then repeat TempItem.Init(); TempItem := Item; TempItem.Insert(); until Item.Next() = 0; TempLocation.Init(); TempLocation.Insert(); TempAnalysisSelectedDim.SetFilter("Dimension Code", Location.TableCaption()); if TempAnalysisSelectedDim.Find('-') then Location.SetFilter(Code, TempAnalysisSelectedDim."Dimension Value Filter"); if Location.Find('-') then repeat TempLocation.Init(); TempLocation := Location; TempLocation.Insert(); until Location.Next() = 0; AnalysisSelectedDim.GetSelectedDim( UserId, 3, REPORT::"Item Dimensions - Detail", AnalysisArea.AsInteger(), ItemAnalysisViewCode, TempAnalysisSelectedDim); TempAnalysisSelectedDim.Reset(); TempAnalysisSelectedDim.SetCurrentKey( "User ID", "Object Type", "Object ID", "Analysis Area", "Analysis View Code", Level); TempAnalysisSelectedDim.SetFilter(Level, '<>%1', TempAnalysisSelectedDim.Level::" "); DimVal.SetRange("Dimension Value Type", DimVal."Dimension Value Type"::Standard); if TempAnalysisSelectedDim.Find('-') then repeat TempDimVal.Init(); TempDimVal.Code := ''; TempDimVal."Dimension Code" := TempAnalysisSelectedDim."Dimension Code"; TempDimVal.Name := Text003; TempDimVal.Insert(); DimVal.SetRange("Dimension Code", TempAnalysisSelectedDim."Dimension Code"); if TempAnalysisSelectedDim."Dimension Value Filter" <> '' then DimVal.SetFilter(Code, TempAnalysisSelectedDim."Dimension Value Filter") else DimVal.SetRange(Code); if DimVal.Find('-') then repeat TempDimVal.Init(); TempDimVal := DimVal; TempDimVal.Insert(); until DimVal.Next() = 0; until TempAnalysisSelectedDim.Next() = 0; end; var ItemAnalysisViewEntry: Record "Item Analysis View Entry"; TempAnalysisSelectedDim: Record "Analysis Selected Dimension" temporary; Item: Record Item; Location: Record Location; DimVal: Record "Dimension Value"; TempValueEntry: Record "Value Entry" temporary; TempItem: Record Item temporary; TempLocation: Record Location temporary; TempDimVal: Record "Dimension Value" temporary; AnalysisDimSelectionBuf: Record "Analysis Dim. Selection Buffer"; PrintEmptyLines: Boolean; ViewLastUpdatedText: Text[30]; ColumnDim: Text[250]; AnalysisArea: Enum "Analysis Area Type"; ItemAnalysisViewCode: Code[10]; DateFilter: Text; FindFirstDim: array[4] of Boolean; FindFirstValueEntry: array[4] of Boolean; DimCode: array[4] of Text[30]; DimValCode: array[4] of Code[20]; DimValName: array[4] of Text[100]; LevelFilter: array[3] of Text[250]; SalesAmtTotal: array[3] of Decimal; CostAmtTotal: array[3] of Decimal; QtyTotal: array[3] of Decimal; DimFilterText: Text[250];#pragma warning disable AA0074 Text000: Label 'Enter an analysis view code.'; Text001: Label 'Enter a date filter.'; Text002: Label 'Include Dimensions'; Text003: Label '(no dimension value)'; Text004: Label 'Not updated'; Text014: Label '(no location code)';#pragma warning restore AA0074 PeriodCaptionLbl: Label 'Period'; AnalysisViewCaptionLbl: Label 'Analysis View'; LastDateUpdatedCaptionLbl: Label 'Last Date Updated'; PageCaptionLbl: Label 'Page'; ItemDimsDetailCptnLbl: Label 'Item Dimensions - Detail'; FiltersCaptionLbl: Label 'Filters'; CostAmtCaptionLbl: Label 'Cost Amount'; SalesAmtCaptionLbl: Label 'Sales Amount'; DescriptionCaptionLbl: Label 'Description'; PostingDateCaptionLbl: Label 'Posting Date'; ItemNoCaptionLbl: Label 'Item No.'; EntryNoCaptionLbl: Label 'Entry No.'; QuantityCaptionLbl: Label 'Quantity'; local procedure CalcLine(Level: Integer): Boolean var HasEntries: Boolean; i: Integer; begin if Level < 3 then for i := Level + 1 to 3 do SetItemAnalysisViewEntryFilter(DimCode[i], '*'); if Iteration( FindFirstDim[Level], DimCode[Level], DimValCode[Level], DimValName[Level], LevelFilter[Level]) then begin SetItemAnalysisViewEntryFilter(DimCode[Level], DimValCode[Level]); HasEntries := ItemAnalysisViewEntry.Find('-'); end else CurrReport.Break(); exit(HasEntries); end; local procedure PrintDetail(Level: Integer): Boolean var ItemAViewEntryToValueEntries: Codeunit ItemAViewEntryToValueEntries; begin if FindFirstValueEntry[Level] then begin FindFirstValueEntry[Level] := false; TempValueEntry.Reset(); TempValueEntry.DeleteAll(); if ItemAnalysisViewEntry.Find('-') then repeat ItemAViewEntryToValueEntries.GetValueEntries(ItemAnalysisViewEntry, TempValueEntry); until ItemAnalysisViewEntry.Next() = 0; TempValueEntry.SetCurrentKey("Item No.", "Posting Date"); TempValueEntry.SetFilter("Posting Date", DateFilter); if not TempValueEntry.Find('-') then exit(false); end else if TempValueEntry.Next() = 0 then exit(false); if Level > 1 then CalcTotalValues(Level - 1); exit(true); end; local procedure CalcTotalValues(Level: Integer) var i: Integer; begin for i := 1 to Level do begin SalesAmtTotal[i] := SalesAmtTotal[i] + TempValueEntry."Sales Amount (Actual)" + TempValueEntry."Sales Amount (Expected)"; CostAmtTotal[i] := CostAmtTotal[i] + TempValueEntry."Cost Amount (Actual)" + TempValueEntry."Cost Amount (Expected)" + TempValueEntry."Cost Amount (Non-Invtbl.)"; QtyTotal[i] := QtyTotal[i] + TempValueEntry."Valued Quantity"; end; end; local procedure UpdateColumnDim() var AnalysisSelectedDim: Record "Analysis Selected Dimension"; TempAnalysisDimSelectionBuf: Record "Analysis Dim. Selection Buffer" temporary; ItemAnalysisView: Record "Item Analysis View"; begin ItemAnalysisView.CopyAnalysisViewFilters(3, REPORT::"Item Dimensions - Detail", AnalysisArea.AsInteger(), ItemAnalysisViewCode); ColumnDim := ''; AnalysisSelectedDim.SetRange("User ID", UserId); AnalysisSelectedDim.SetRange("Object Type", 3); AnalysisSelectedDim.SetRange("Object ID", REPORT::"Item Dimensions - Detail"); AnalysisSelectedDim.SetRange("Analysis Area", AnalysisArea); AnalysisSelectedDim.SetRange("Analysis View Code", ItemAnalysisViewCode); if AnalysisSelectedDim.Find('-') then begin repeat TempAnalysisDimSelectionBuf.Init(); TempAnalysisDimSelectionBuf.Code := AnalysisSelectedDim."Dimension Code"; TempAnalysisDimSelectionBuf.Selected := true; TempAnalysisDimSelectionBuf."Dimension Value Filter" := AnalysisSelectedDim."Dimension Value Filter"; TempAnalysisDimSelectionBuf.Level := AnalysisSelectedDim.Level; TempAnalysisDimSelectionBuf.Insert(); until AnalysisSelectedDim.Next() = 0; TempAnalysisDimSelectionBuf.SetDimSelection( 3, REPORT::"Item Dimensions - Detail", AnalysisArea.AsInteger(), ItemAnalysisViewCode, ColumnDim, TempAnalysisDimSelectionBuf); end; end; local procedure Iteration(var FindFirstRec: Boolean; IterationDimCode: Text[30]; var IterationDimValCode: Code[20]; var IterationDimValName: Text[100]; IterationFilter: Text[250]): Boolean var SearchResult: Boolean; begin case IterationDimCode of TempItem.TableCaption: begin TempItem.Reset(); TempItem.SetFilter("No.", IterationFilter); if FindFirstRec then SearchResult := TempItem.Find('-') else if TempItem.Get(IterationDimValCode) then SearchResult := TempItem.Next() <> 0; if SearchResult then begin IterationDimValCode := TempItem."No."; IterationDimValName := TempItem.Description; end; end; TempLocation.TableCaption: begin TempLocation.Reset(); TempLocation.SetFilter(Code, IterationFilter); if FindFirstRec then SearchResult := TempLocation.Find('-') else if TempLocation.Get(IterationDimValCode) then SearchResult := TempLocation.Next() <> 0; if SearchResult then begin IterationDimValCode := TempLocation.Code; if TempLocation.Code <> '' then IterationDimValName := TempLocation.Name else IterationDimValName := Text014; end; end; else begin TempDimVal.Reset(); TempDimVal.SetRange("Dimension Code", IterationDimCode); TempDimVal.SetFilter(Code, IterationFilter); if FindFirstRec then SearchResult := TempDimVal.Find('-') else if TempDimVal.Get(IterationDimCode, IterationDimValCode) then SearchResult := TempDimVal.Next() <> 0; if SearchResult then begin IterationDimValCode := TempDimVal.Code; IterationDimValName := TempDimVal.Name; end; end; end; if not SearchResult then begin IterationDimValCode := ''; IterationDimValName := ''; end; FindFirstRec := false; exit(SearchResult); end; local procedure SetItemAnalysisViewEntryFilter(ItemAnalysisViewDimCode: Text[30]; ItemAnalysisViewFilter: Text[250]) begin if ItemAnalysisViewFilter = '' then ItemAnalysisViewFilter := ''''''; case ItemAnalysisViewDimCode of TempItem.TableCaption: if ItemAnalysisViewFilter = '*' then ItemAnalysisViewEntry.SetRange("Item No.") else ItemAnalysisViewEntry.SetFilter("Item No.", ItemAnalysisViewFilter); TempLocation.TableCaption: if ItemAnalysisViewFilter = '*' then ItemAnalysisViewEntry.SetRange("Location Code") else ItemAnalysisViewEntry.SetFilter("Location Code", ItemAnalysisViewFilter); "Item Analysis View"."Dimension 1 Code": if ItemAnalysisViewFilter = '*' then ItemAnalysisViewEntry.SetRange("Dimension 1 Value Code") else ItemAnalysisViewEntry.SetFilter("Dimension 1 Value Code", ItemAnalysisViewFilter); "Item Analysis View"."Dimension 2 Code": if ItemAnalysisViewFilter = '*' then ItemAnalysisViewEntry.SetRange("Dimension 2 Value Code") else ItemAnalysisViewEntry.SetFilter("Dimension 2 Value Code", ItemAnalysisViewFilter); "Item Analysis View"."Dimension 3 Code": if ItemAnalysisViewFilter = '*' then ItemAnalysisViewEntry.SetRange("Dimension 3 Value Code") else ItemAnalysisViewEntry.SetFilter("Dimension 3 Value Code", ItemAnalysisViewFilter); end; end;}