Report 28 Dimensions - Detail
src/Layers/W1/BaseApp/Finance/Dimension/DimensionsDetail.Report.al905 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.Finance.Dimension;using Microsoft.Finance.Analysis;using Microsoft.Finance.Consolidation;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Period;using System.Text;using System.Utilities;/// <summary>/// Generates detailed dimension analysis reports with G/L entry drill-down capabilities./// Provides comprehensive dimension-based financial analysis with multiple layout options and filtering./// </summary>/// <remarks>/// Supports analysis view integration, dimension value filtering, and detailed G/L entry reporting./// Includes extensibility through integration events for custom filtering and processing logic./// Essential tool for detailed financial analysis and dimension-based reporting requirements./// </remarks>report 28 "Dimensions - Detail"{ ApplicationArea = Dimensions; Caption = 'Dimensions - Detail'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Analysis View"; "Analysis View") { DataItemTableView = sorting(Code); column(ViewLastUpdatedText; ViewLastUpdatedText) { } column(Analysis_View_Name; Name) { } column(Analysis_View_Code; Code) { } column(DateFilter; DateFilter) { } column(COMPANYNAME; COMPANYPROPERTY.DisplayName()) { } column(DimFilterText; DimFilterText) { } column(DateFilterCaption; DateFilterCaptionLbl) { } column(Analysis_View_CodeCaption; Analysis_View_CodeCaptionLbl) { } column(ViewLastUpdatedTextCaption; ViewLastUpdatedTextCaptionLbl) { } column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl) { } column(Dimensions___DetailCaption; Dimensions___DetailCaptionLbl) { } column(FiltersCaption; FiltersCaptionLbl) { } column(Credit_AmountCaption; Credit_AmountCaptionLbl) { } column(Debit_AmountCaption; Debit_AmountCaptionLbl) { } column(DescriptionCaption; DescriptionCaptionLbl) { } column(Document_No_Caption; Document_No_CaptionLbl) { } column(Posting_DateCaption; Posting_DateCaptionLbl) { } column(G_L_Account_No_Caption; G_L_Account_No_CaptionLbl) { } column(Entry_No_Caption; Entry_No_CaptionLbl) { } dataitem(Level1; "Integer") { DataItemTableView = sorting(Number); column(DimValCode_1_; DimValCode[1]) { } column(DimCode_1_; DimCode[1]) { } column(DimValName_1_; DimValName[1]) { } column(UseAmtsInAddCurr; UseAmtsInAddCurr) { } column(Text015; Text015Lbl) { } column(AddRepCurrency; AddRepCurrency) { } column(LCYCODE; LCYCODE) { } dataitem(Level2; "Integer") { DataItemTableView = sorting(Number); column(DimValCode_2_; DimValCode[2]) { } column(DimCode_2_; DimCode[2]) { } column(DimValName_2_; DimValName[2]) { } column(TempGLEntry__G_L_Account_No__; TempGLEntry."G/L Account No.") { } column(TempGLEntry__Posting_Date_; Format(TempGLEntry."Posting Date")) { } column(TempGLEntry__Document_No__; TempGLEntry."Document No.") { } column(TempGLEntry_Description; TempGLEntry.Description) { } column(TempGLEntry__Debit_Amount_; TempGLEntry."Debit Amount") { } column(TempGLEntry__Credit_Amount_; TempGLEntry."Credit Amount") { } column(TempGLEntry__Entry_No__; TempGLEntry."Entry No.") { } dataitem(Level3; "Integer") { DataItemTableView = sorting(Number); column(DimValCode_3_; DimValCode[3]) { } column(DimCode_3_; DimCode[3]) { } column(DimValName_3_; DimValName[3]) { } column(TempGLEntry__Debit_Amount__Control25; TempGLEntry."Debit Amount") { } column(TempGLEntry__Credit_Amount__Control26; TempGLEntry."Credit Amount") { } column(TempGLEntry__Entry_No___Control86; TempGLEntry."Entry No.") { } dataitem(Level4; "Integer") { DataItemTableView = sorting(Number); column(DimValCode_4_; DimValCode[4]) { } column(DimCode_4_; DimCode[4]) { } column(DimValName_4_; DimValName[4]) { } column(TempGLEntry__Debit_Amount__Control36; TempGLEntry."Debit Amount") { } column(TempGLEntry__Credit_Amount__Control37; TempGLEntry."Credit Amount") { } column(TempGLEntry__Entry_No___Control87; TempGLEntry."Entry No.") { } dataitem(Level5; "Integer") { DataItemTableView = sorting(Number); column(TempGLEntry__Credit_Amount__Control52; TempGLEntry."Credit Amount") { } column(TempGLEntry__Debit_Amount__Control53; TempGLEntry."Debit Amount") { } column(TempGLEntry__Entry_No___Control88; TempGLEntry."Entry No.") { } trigger OnAfterGetRecord() begin if not PrintDetail(5) then CurrReport.Break(); end; trigger OnPreDataItem() begin if DimCode[4] = '' then CurrReport.Break(); FindFirstGLEntry[5] := true; end; } dataitem(Level4e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(DebitTotal_4_; DebitTotal[4]) { AutoFormatType = 1; } column(CreditTotal_4_; CreditTotal[4]) { AutoFormatType = 1; } trigger OnPostDataItem() begin DebitTotal[4] := 0; CreditTotal[4] := 0; end; } 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; FindFirstGLEntry[4] := true; end; } dataitem(Level3e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(DebitTotal_3_; DebitTotal[3]) { AutoFormatType = 1; } column(CreditTotal_3_; CreditTotal[3]) { AutoFormatType = 1; } trigger OnPostDataItem() begin DebitTotal[3] := 0; CreditTotal[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; FindFirstGLEntry[3] := true; end; } dataitem(Level2e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(DebitTotal_2_; DebitTotal[2]) { AutoFormatType = 1; } column(CreditTotal_2_; CreditTotal[2]) { AutoFormatType = 1; } trigger OnPostDataItem() begin DebitTotal[2] := 0; CreditTotal[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; FindFirstGLEntry[2] := true; end; } dataitem(Level1e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(CreditTotal_1_; CreditTotal[1]) { AutoFormatType = 1; } column(DebitTotal_1_; DebitTotal[1]) { AutoFormatType = 1; } trigger OnPostDataItem() begin DebitTotal[1] := 0; CreditTotal[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; FindFirstGLEntry[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; AnalysisViewEntry.Reset(); AnalysisViewEntry.SetRange("Analysis View Code", Code); AnalysisViewEntry.SetFilter("Posting Date", DateFilter); StartDate := AnalysisViewEntry.GetRangeMin("Posting Date"); EndDate := AnalysisViewEntry.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; AnalysisViewEntry.SetRange("Posting Date", StartDate, EndDate); OnAfterGetRecordAnalysisViewOnBeforeSetEntryFilterGroup(AnalysisViewEntry, "Analysis View"); AnalysisViewEntry.FilterGroup(2); TempSelectedDim.Reset(); TempSelectedDim.SetCurrentKey("User ID", "Object Type", "Object ID", "Analysis View Code", Level); TempSelectedDim.SetFilter("Dimension Value Filter", '<>%1', ''); DimFilterText := ''; if TempSelectedDim.Find('-') then repeat ThisFilter := ''; if DimFilterText <> '' then ThisFilter := ', '; ThisFilter := ThisFilter + TempSelectedDim."Dimension Code" + ': ' + TempSelectedDim."Dimension Value Filter"; if StrLen(DimFilterText) + StrLen(ThisFilter) <= 250 then DimFilterText := DimFilterText + ThisFilter; SetAnaViewEntryFilter( TempSelectedDim."Dimension Code", TempSelectedDim."Dimension Value Filter"); until TempSelectedDim.Next() = 0; AnalysisViewEntry.FilterGroup(0); TempSelectedDim.Reset(); TempSelectedDim.SetCurrentKey("User ID", "Object Type", "Object ID", "Analysis View Code", Level); TempSelectedDim.SetFilter(Level, '<>%1', TempSelectedDim.Level::" "); i := 1; if TempSelectedDim.Find('-') then repeat DimCode[i] := TempSelectedDim."Dimension Code"; LevelFilter[i] := TempSelectedDim."Dimension Value Filter"; i := i + 1; until (TempSelectedDim.Next() = 0) or (i > 4); end; trigger OnPreDataItem() begin SetRange(Code, AnalysisViewCode); GLSetup.Get(); LCYCODE := GLSetup."LCY Code"; AddRepCurrency := GLSetup."Additional Reporting Currency"; end; } } requestpage { SaveValues = true; AboutTitle = 'About Dimensions - Detail'; AboutText = 'Build a group of dimensions for combinations of dimension values. Define a hierarchy of dimension levels from an analysis view, and list all G/L entries for each group.'; layout { area(content) { group(Options) { Caption = 'Options'; field(AnalysisViewCode; AnalysisViewCode) { ApplicationArea = Dimensions; Caption = 'Analysis View Code'; Lookup = true; TableRelation = "Analysis View".Code; ToolTip = 'Specifies the code for the analysis view that the filter belongs to.'; trigger OnLookup(var Text: Text): Boolean var AnalysisView: Record "Analysis View"; begin if PAGE.RunModal(PAGE::"Analysis View List", AnalysisView) = ACTION::LookupOK then begin AnalysisViewCode := AnalysisView.Code; UpdateColumnDim(); end; end; trigger OnValidate() begin 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 select in the Analysis View Code field.'; trigger OnAssistEdit() begin DimSelectionBuf.SetDimSelectionLevelGLAcc(3, REPORT::"Dimensions - Detail", AnalysisViewCode, ColumnDim); end; } field(DtFilter; 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); TempGLAcc.SetFilter("Date Filter", DateFilter); DateFilter := TempGLAcc.GetFilter("Date Filter"); end; } field(PrintEmptyLines; PrintEmptyLines) { ApplicationArea = Dimensions; Caption = 'Print Empty Lines'; MultiLine = true; ToolTip = 'Specifies if you do not want the report to include dimensions and dimension values that have a balance of zero.'; } field(ShowAmountsInAddRepCurrency; UseAmtsInAddCurr) { ApplicationArea = Dimensions; Caption = 'Show Amounts in Add. Reporting Currency'; MultiLine = true; ToolTip = 'Specifies if the reported amounts are shown in the additional reporting currency.'; } } } } actions { } trigger OnOpenPage() begin GLSetup.Get(); if GLSetup."Additional Reporting Currency" = '' then UseAmtsInAddCurr := false; UpdateColumnDim(); end; } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Finance/Dimension/DimensionsDetail.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() var SelectedDim: Record "Selected Dimension"; begin if AnalysisViewCode = '' then Error(Text000); if DateFilter = '' then Error(Text001); DimSelectionBuf.CompareDimText( 3, REPORT::"Dimensions - Detail", AnalysisViewCode, ColumnDim, Text002); TempSelectedDim.Reset(); TempSelectedDim.SetFilter("Dimension Value Filter", '<>%1', ''); TempSelectedDim.SetFilter("Dimension Code", TempGLAcc.TableCaption()); if TempSelectedDim.Find('-') then GLAcc.SetFilter("No.", TempSelectedDim."Dimension Value Filter"); GLAcc.SetRange("Account Type", GLAcc."Account Type"::Posting); if GLAcc.Find('-') then repeat TempGLAcc.Init(); TempGLAcc := GLAcc; TempGLAcc.Insert(); until GLAcc.Next() = 0; TempBusUnit.Init(); TempBusUnit.Insert(); TempSelectedDim.SetFilter("Dimension Code", BusUnit.TableCaption()); if TempSelectedDim.Find('-') then BusUnit.SetFilter(Code, TempSelectedDim."Dimension Value Filter"); if BusUnit.Find('-') then repeat TempBusUnit.Init(); TempBusUnit := BusUnit; TempBusUnit.Insert(); until BusUnit.Next() = 0; SelectedDim.GetSelectedDim(UserId, 3, REPORT::"Dimensions - Detail", AnalysisViewCode, TempSelectedDim); TempSelectedDim.Reset(); TempSelectedDim.SetCurrentKey("User ID", "Object Type", "Object ID", "Analysis View Code", Level); TempSelectedDim.SetFilter(Level, '<>%1', TempSelectedDim.Level::" "); DimVal.SetFilter( "Dimension Value Type", '%1|%2', DimVal."Dimension Value Type"::Standard, DimVal."Dimension Value Type"::"Begin-Total"); if TempSelectedDim.Find('-') then repeat TempDimVal.Init(); TempDimVal.Code := ''; TempDimVal."Dimension Code" := TempSelectedDim."Dimension Code"; TempDimVal.Name := Text003; TempDimVal.Insert(); DimVal.SetRange("Dimension Code", TempSelectedDim."Dimension Code"); if TempSelectedDim."Dimension Value Filter" <> '' then DimVal.SetFilter(Code, TempSelectedDim."Dimension Value Filter") else DimVal.SetRange(Code); OnPreReportOnAfterDimValSetFilters(DimVal); if DimVal.Find('-') then repeat TempDimVal.Init(); TempDimVal := DimVal; TempDimVal.Insert(); until DimVal.Next() = 0; until TempSelectedDim.Next() = 0; end; var [SecurityFiltering(SecurityFilter::Filtered)] AnalysisViewEntry: Record "Analysis View Entry"; [SecurityFiltering(SecurityFilter::Filtered)] BusUnit: Record "Business Unit"; [SecurityFiltering(SecurityFilter::Filtered)] DimVal: Record "Dimension Value"; TempGLEntry: Record "G/L Entry" temporary; TempGLAcc: Record "G/L Account" temporary; TempBusUnit: Record "Business Unit" temporary; TempDimVal: Record "Dimension Value" temporary; TempSelectedDim: Record "Selected Dimension" temporary; DimSelectionBuf: Record "Dimension Selection Buffer"; GLSetup: Record "General Ledger Setup"; PrintEmptyLines: Boolean; UseAmtsInAddCurr: Boolean; ViewLastUpdatedText: Text[30]; ColumnDim: Text[250]; AnalysisViewCode: Code[10]; DateFilter: Text[250]; FindFirstDim: array[4] of Boolean; FindFirstGLEntry: array[5] of Boolean; DimCode: array[4] of Text[30]; DimValCode: array[4] of Code[20]; DimValName: array[4] of Text[100]; LevelFilter: array[4] of Text[250]; AddRepCurrency: Text[50]; LCYCODE: Text[50]; DebitTotal: array[4] of Decimal; CreditTotal: array[4] 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 business unit)';#pragma warning restore AA0074 DateFilterCaptionLbl: Label 'Period'; Analysis_View_CodeCaptionLbl: Label 'Analysis View'; ViewLastUpdatedTextCaptionLbl: Label 'Last Date Updated'; CurrReport_PAGENOCaptionLbl: Label 'Page'; Dimensions___DetailCaptionLbl: Label 'Dimensions - Detail'; FiltersCaptionLbl: Label 'Filters'; Credit_AmountCaptionLbl: Label 'Credit Amount'; Debit_AmountCaptionLbl: Label 'Debit Amount'; DescriptionCaptionLbl: Label 'Description'; Document_No_CaptionLbl: Label 'Document No.'; Posting_DateCaptionLbl: Label 'Posting Date'; G_L_Account_No_CaptionLbl: Label 'G/L Account No.'; Entry_No_CaptionLbl: Label 'Entry No.'; Text015Lbl: Label 'All amounts are in '; protected var [SecurityFiltering(SecurityFilter::Filtered)] GLAcc: Record "G/L Account"; local procedure CalcLine(Level: Integer): Boolean var HasEntries: Boolean; i: Integer; begin if Level < 4 then for i := Level + 1 to 4 do SetAnaViewEntryFilter(DimCode[i], '*'); if Iteration( FindFirstDim[Level], DimCode[Level], DimValCode[Level], DimValName[Level], LevelFilter[Level]) then begin SetAnaViewEntryFilter(DimCode[Level], DimValCode[Level]); HasEntries := AnalysisViewEntry.Find('-'); end else CurrReport.Break(); exit(HasEntries); end; local procedure PrintDetail(Level: Integer): Boolean var AnalysisViewEntryToGLEntries: Codeunit AnalysisViewEntryToGLEntries; begin if FindFirstGLEntry[Level] then begin FindFirstGLEntry[Level] := false; TempGLEntry.Reset(); TempGLEntry.DeleteAll(); if AnalysisViewEntry.Find('-') then repeat AnalysisViewEntryToGLEntries.GetGLEntries(AnalysisViewEntry, TempGLEntry); until AnalysisViewEntry.Next() = 0; TempGLEntry.SetCurrentKey("G/L Account No.", "Posting Date"); TempGLEntry.SetFilter("Posting Date", DateFilter); OnPrintDetailOnAfterTempGLEntrySetFilters(TempGLEntry); if not TempGLEntry.Find('-') then exit(false); end else if TempGLEntry.Next() = 0 then exit(false); if Level > 1 then CalcTotalAmounts(Level - 1); exit(true); end; local procedure CalcTotalAmounts(Level: Integer) var i: Integer; begin for i := 1 to Level do begin if UseAmtsInAddCurr then begin TempGLEntry."Debit Amount" := TempGLEntry."Add.-Currency Debit Amount"; TempGLEntry."Credit Amount" := TempGLEntry."Add.-Currency Credit Amount"; end; DebitTotal[i] := DebitTotal[i] + TempGLEntry."Debit Amount"; CreditTotal[i] := CreditTotal[i] + TempGLEntry."Credit Amount"; end; end; local procedure UpdateColumnDim() var SelectedDim: Record "Selected Dimension"; TempDimSelectionBuf: Record "Dimension Selection Buffer" temporary; AnalysisView: Record "Analysis View"; begin AnalysisView.CopyAnalysisViewFilters(3, REPORT::"Dimensions - Detail", AnalysisViewCode); ColumnDim := ''; SelectedDim.SetRange("User ID", UserId); SelectedDim.SetRange("Object Type", 3); SelectedDim.SetRange("Object ID", REPORT::"Dimensions - Detail"); SelectedDim.SetRange("Analysis View Code", AnalysisViewCode); if SelectedDim.Find('-') then begin repeat TempDimSelectionBuf.Init(); TempDimSelectionBuf.Code := SelectedDim."Dimension Code"; TempDimSelectionBuf.Selected := true; TempDimSelectionBuf."Dimension Value Filter" := SelectedDim."Dimension Value Filter"; TempDimSelectionBuf.Level := SelectedDim.Level; TempDimSelectionBuf.Insert(); until SelectedDim.Next() = 0; TempDimSelectionBuf.SetDimSelection( 3, REPORT::"Dimensions - Detail", AnalysisViewCode, ColumnDim, TempDimSelectionBuf); 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 TempGLAcc.TableCaption: begin TempGLAcc.Reset(); TempGLAcc.SetFilter("No.", IterationFilter); if FindFirstRec then SearchResult := TempGLAcc.Find('-') else if TempGLAcc.Get(IterationDimValCode) then SearchResult := (TempGLAcc.Next() <> 0); if SearchResult then begin IterationDimValCode := TempGLAcc."No."; IterationDimValName := TempGLAcc.Name; end; end; TempBusUnit.TableCaption: begin TempBusUnit.Reset(); TempBusUnit.SetFilter(Code, IterationFilter); if FindFirstRec then SearchResult := TempBusUnit.Find('-') else if TempBusUnit.Get(IterationDimValCode) then SearchResult := (TempBusUnit.Next() <> 0); if SearchResult then begin IterationDimValCode := TempBusUnit.Code; if TempBusUnit.Code <> '' then IterationDimValName := TempBusUnit.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 SetAnaViewEntryFilter(AnalysisViewDimCode: Text[30]; AnalysisViewFilter: Text[250]) begin if AnalysisViewFilter = '' then AnalysisViewFilter := ''''''; case AnalysisViewDimCode of TempGLAcc.TableCaption: if AnalysisViewFilter = '*' then AnalysisViewEntry.SetRange("Account No.") else AnalysisViewEntry.SetFilter("Account No.", AnalysisViewFilter); TempBusUnit.TableCaption: if AnalysisViewFilter = '*' then AnalysisViewEntry.SetRange("Business Unit Code") else AnalysisViewEntry.SetFilter("Business Unit Code", AnalysisViewFilter); "Analysis View"."Dimension 1 Code": if AnalysisViewFilter = '*' then AnalysisViewEntry.SetRange("Dimension 1 Value Code") else AnalysisViewEntry.SetFilter("Dimension 1 Value Code", AnalysisViewFilter); "Analysis View"."Dimension 2 Code": if AnalysisViewFilter = '*' then AnalysisViewEntry.SetRange("Dimension 2 Value Code") else AnalysisViewEntry.SetFilter("Dimension 2 Value Code", AnalysisViewFilter); "Analysis View"."Dimension 3 Code": if AnalysisViewFilter = '*' then AnalysisViewEntry.SetRange("Dimension 3 Value Code") else AnalysisViewEntry.SetFilter("Dimension 3 Value Code", AnalysisViewFilter); "Analysis View"."Dimension 4 Code": if AnalysisViewFilter = '*' then AnalysisViewEntry.SetRange("Dimension 4 Value Code") else AnalysisViewEntry.SetFilter("Dimension 4 Value Code", AnalysisViewFilter); end; end; /// <summary> /// Integration event raised after analysis view record processing and before setting entry filter groups. /// Enables custom filtering and processing of analysis view entries during report generation. /// </summary> /// <param name="AnalysisViewEntry">Analysis view entry record being processed</param> /// <param name="AnalysisView">Analysis view configuration record</param> [IntegrationEvent(false, false)] local procedure OnAfterGetRecordAnalysisViewOnBeforeSetEntryFilterGroup(var AnalysisViewEntry: Record "Analysis View Entry"; AnalysisView: Record "Analysis View") begin end; /// <summary> /// Integration event raised after setting filters on temporary G/L entries during detail printing. /// Enables custom filter modification for detailed G/L entry reporting. /// </summary> /// <param name="TempGLEntry">Temporary G/L entry record with applied filters</param> [IntegrationEvent(false, false)] local procedure OnPrintDetailOnAfterTempGLEntrySetFilters(var TempGLEntry: Record "G/L Entry" temporary) begin end; /// <summary> /// Integration event raised after setting filters on dimension values during report preprocessing. /// Enables custom dimension value filtering for report data preparation. /// </summary> /// <param name="DimensionValue">Dimension value record with applied filters</param> [IntegrationEvent(false, false)] local procedure OnPreReportOnAfterDimValSetFilters(var DimensionValue: Record "Dimension Value") begin end;}