Report 852 Cash Flow Dimensions - Detail
src/Layers/W1/BaseApp/CashFlow/Reports/CashFlowDimensionsDetail.Report.al867 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.CashFlow.Reports;using Microsoft.CashFlow.Account;using Microsoft.CashFlow.Forecast;using Microsoft.Finance.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Period;using System.Text;using System.Utilities;report 852 "Cash Flow Dimensions - Detail"{ DefaultLayout = RDLC; RDLCLayout = './CashFlow/Reports/CashFlowDimensionsDetail.rdlc'; ApplicationArea = Dimensions; Caption = 'Cash Flow Dimensions - Detail'; ToolTip = 'Run the Cash Flow Dimensions - Detail report.'; UsageCategory = ReportsAndAnalysis; dataset { dataitem("Analysis View"; "Analysis View") { DataItemTableView = sorting(Code); column(ViewLastUpdatedText; ViewLastUpdatedText) { } column(CashFlowAnalysisViewName; Name) { } column(CashFlowAnalysisViewCode; Code) { } column(DateFilter; DateFilter) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(HeaderText; HeaderText) { } column(DimFilterText; DimFilterText) { } column(PeriodCaption; PeriodCaptionLbl) { } column(AnalysisViewCaption; AnalysisViewCaptionLbl) { } column(LastUpdatedCaption; LastUpdatedCaptionLbl) { } column(PageCaption; PageCaptionLbl) { } column(CashFlowDimensionsDetailCaption; CashFlowDimensionsDetailCaptionLbl) { } column(FiltersCaption; FiltersCaptionLbl) { } column(AmountCaption; AmountCaptionLbl) { } column(DescriptionCaption; DescriptionCaptionLbl) { } column(DocumentNoCaption; DocumentNoCaptionLbl) { } column(CashFlowDateCaption; CashFlowDateCaptionLbl) { } column(CashFlowAccountNoCaption; CashFlowAccountNoCaptionLbl) { } column(EntryNoCaption; EntryNoCaptionLbl) { } 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(TempCFLedgEntryCashFlowAccNo; TempCFForecastEntry."Cash Flow Account No.") { } column(TempCFLedgEntryCashFlowDate; TempCFForecastEntry."Cash Flow Date") { } column(TempCFLedgEntryDocNo; TempCFForecastEntry."Document No.") { } column(TempCFLedgEntryDesc; TempCFForecastEntry.Description) { } column(TempCFLedgEntryAmt; TempCFForecastEntry."Amount (LCY)") { } column(TempCFLedgEntryEntryNo; TempCFForecastEntry."Entry No.") { } dataitem(Level3; "Integer") { DataItemTableView = sorting(Number); column(DimValCode3; DimValCode[3]) { } column(DimCode3; DimCode[3]) { } column(DimValName3; DimValName[3]) { } column(TempCFLedgEntryCashFlowDt_Level3; TempCFForecastEntry."Cash Flow Date") { } column(TempCFLedgEntryDocNo_Level3; TempCFForecastEntry."Document No.") { } column(TempCFLedgEntryDesc_Level3; TempCFForecastEntry.Description) { } column(TempCFLedgEntryAmt_Level3; TempCFForecastEntry."Amount (LCY)") { } column(TempCFLedgEntryEntryNo_Level3; TempCFForecastEntry."Entry No.") { } dataitem(Level4; "Integer") { DataItemTableView = sorting(Number); column(DimValCode4; DimValCode[4]) { } column(DimCode4; DimCode[4]) { } column(DimValName4; DimValName[4]) { } column(TempCFLedgEntryCashFlowDt_Level4; TempCFForecastEntry."Cash Flow Date") { } column(TempCFLedgEntryDocNo_Level4; TempCFForecastEntry."Document No.") { } column(TempCFLedgEntryDesc_Level4; TempCFForecastEntry.Description) { } column(TempCFLedgEntryAmt_Level4; TempCFForecastEntry."Amount (LCY)") { } column(TempCFLedgEntryEntryNo_Level4; TempCFForecastEntry."Entry No.") { } dataitem(Level5; "Integer") { DataItemTableView = sorting(Number); column(TempCFLedgEntryEntryNo_Level5; TempCFForecastEntry."Entry No.") { } trigger OnAfterGetRecord() begin if not PrintDetail(5) then CurrReport.Break(); end; trigger OnPreDataItem() begin if DimCode[4] = '' then CurrReport.Break(); FindFirstCFLedgEntry[5] := true; end; } dataitem(Level4e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(Total4; Total[4]) { AutoFormatType = 1; } trigger OnPostDataItem() begin Total[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; FindFirstCFLedgEntry[4] := true; end; } dataitem(Level3e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(Total3; Total[3]) { AutoFormatType = 1; } trigger OnPostDataItem() begin Total[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; FindFirstCFLedgEntry[3] := true; end; } dataitem(Level2e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(Total2; Total[2]) { AutoFormatType = 1; } trigger OnPostDataItem() begin Total[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; FindFirstCFLedgEntry[2] := true; end; } dataitem(Level1e; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(Total1; Total[1]) { AutoFormatType = 1; } trigger OnPostDataItem() begin Total[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; FindFirstCFLedgEntry[1] := true; end; } trigger OnAfterGetRecord() var AccountingPeriod: Record "Accounting Period"; i: Integer; StartDate: Date; EndDate: Date; 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("Cash Flow Forecast No.", CFFilter); 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); 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 CompileFilterCaptionString(TempSelectedDim."Dimension Code", TempSelectedDim."Dimension Value Filter"); SetAnaViewEntryFilter( TempSelectedDim."Dimension Code", TempSelectedDim."Dimension Value Filter"); until TempSelectedDim.Next() = 0; if CFFilter <> '' then CompileFilterCaptionString(Text007, CFFilter); 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); if GLSetup."LCY Code" <> '' then HeaderText := StrSubstNo(Text005, GLSetup."LCY Code") else HeaderText := ''; end; trigger OnPreDataItem() begin SetRange(Code, AnalysisViewCode); end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(AnalysisViewCodes; AnalysisViewCode) { ApplicationArea = Suite; Caption = 'Analysis View Code'; Lookup = true; TableRelation = "Analysis View".Code; ToolTip = 'Specifies the code for the cash flow analysis view you want the report to be based on.'; 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(ColumnDim; 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 that are included in the cash flow analysis view that you select in the Analysis View Code field.'; trigger OnAssistEdit() begin DimSelectionBuf.SetDimSelectionLevelCFAcc(3, REPORT::"Cash Flow Dimensions - Detail", AnalysisViewCode, ColumnDim); end; } field(ForecastFilter; CFFilter) { ApplicationArea = Suite; Caption = 'Cash Flow Forecast Filter'; ToolTip = 'Specifies the cash flow forecast(s) that are included.'; trigger OnLookup(var Text: Text): Boolean var CashFlowForecastList: Page "Cash Flow Forecast List"; begin CashFlowForecastList.LookupMode(true); if CashFlowForecastList.RunModal() = ACTION::LookupOK then begin Text := CashFlowForecastList.GetSelectionFilter(); exit(true); end; exit(false) end; } field(DateFilters; DateFilter) { ApplicationArea = Suite; Caption = 'Date Filter'; ToolTip = 'Specifies a date filter to 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); TempCFAccount.SetFilter("Date Filter", DateFilter); DateFilter := TempCFAccount.GetFilter("Date Filter"); end; } field(PrintEmptyLine; 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 of zero. Choose the Print button to print the report or choose the Preview button to view it on the screen.'; } } } } actions { } trigger OnOpenPage() begin GLSetup.Get(); UpdateColumnDim(); end; } labels { } trigger OnPreReport() var SelectedDim: Record "Selected Dimension"; begin if AnalysisViewCode = '' then Error(Text000); if DateFilter = '' then Error(Text001); DimSelectionBuf.CompareDimText( 3, REPORT::"Cash Flow Dimensions - Detail", AnalysisViewCode, ColumnDim, Text002); TempSelectedDim.Reset(); TempSelectedDim.SetFilter("Dimension Value Filter", '<>%1', ''); TempSelectedDim.SetFilter("Dimension Code", TempCFAccount.TableCaption()); if TempSelectedDim.Find('-') then CFAccount.SetFilter("No.", TempSelectedDim."Dimension Value Filter"); CFAccount.SetRange("Account Type", CFAccount."Account Type"::Entry); if CFAccount.Find('-') then repeat TempCFAccount.Init(); TempCFAccount := CFAccount; TempCFAccount.Insert(); until CFAccount.Next() = 0; TempCashFlowForecast.Init(); TempCashFlowForecast.Insert(); TempSelectedDim.SetFilter("Dimension Code", CashFlowForecast.TableCaption()); if TempSelectedDim.Find('-') then CashFlowForecast.SetFilter("No.", TempSelectedDim."Dimension Value Filter"); if CashFlowForecast.Find('-') then repeat TempCashFlowForecast.Init(); TempCashFlowForecast := CashFlowForecast; TempCashFlowForecast.Insert(); until CashFlowForecast.Next() = 0; SelectedDim.GetSelectedDim(UserId, 3, REPORT::"Cash Flow 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.SetRange("Dimension Value Type", DimVal."Dimension Value Type"::Standard); if TempSelectedDim.Find('-') then repeat if StrLen(TempSelectedDim."Dimension Code") <= MaxStrLen(DimVal."Dimension Code") then begin TempDimVal.Init(); TempDimVal.Code := ''; TempDimVal."Dimension Code" := CopyStr(TempSelectedDim."Dimension Code", 1, 20); 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); if DimVal.Find('-') then repeat TempDimVal.Init(); TempDimVal := DimVal; TempDimVal.Insert(); until DimVal.Next() = 0; end; until TempSelectedDim.Next() = 0; end; var AnalysisViewEntry: Record "Analysis View Entry"; TempSelectedDim: Record "Selected Dimension" temporary; CFAccount: Record "Cash Flow Account"; CashFlowForecast: Record "Cash Flow Forecast"; DimVal: Record "Dimension Value"; TempCFForecastEntry: Record "Cash Flow Forecast Entry" temporary; TempCFAccount: Record "Cash Flow Account" temporary; TempCashFlowForecast: Record "Cash Flow Forecast" temporary; TempDimVal: Record "Dimension Value" temporary; DimSelectionBuf: Record "Dimension Selection Buffer"; GLSetup: Record "General Ledger Setup"; PrintEmptyLines: Boolean; ViewLastUpdatedText: Text[30]; ColumnDim: Text[250]; AnalysisViewCode: Code[10]; DateFilter: Text[250]; FindFirstDim: array[4] of Boolean; FindFirstCFLedgEntry: 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]; HeaderText: Text[100]; Total: array[4] of Decimal; DimFilterText: Text[250]; CFFilter: 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';#pragma warning disable AA0470 Text005: Label 'All amounts are in %1.';#pragma warning restore AA0470 Text006: Label '(no business unit)'; Text007: Label 'Cash Flow Forecast Filter';#pragma warning restore AA0074 PeriodCaptionLbl: Label 'Period'; AnalysisViewCaptionLbl: Label 'Analysis View'; LastUpdatedCaptionLbl: Label 'Last Date Updated'; PageCaptionLbl: Label 'Page'; CashFlowDimensionsDetailCaptionLbl: Label 'Cash Flow Dimensions - Detail'; FiltersCaptionLbl: Label 'Filters'; AmountCaptionLbl: Label 'Amount'; DescriptionCaptionLbl: Label 'Description'; DocumentNoCaptionLbl: Label 'Document No.'; CashFlowDateCaptionLbl: Label 'Cash Flow Date'; CashFlowAccountNoCaptionLbl: Label 'Cash Flow Account No.'; EntryNoCaptionLbl: Label 'Entry No.'; 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(); OnAfterCalcLine(DimCode[Level], DimValCode[Level], DimValName[Level], Level); exit(HasEntries); end; local procedure PrintDetail(Level: Integer): Boolean var AnalysisViewEntryToGLEntries: Codeunit AnalysisViewEntryToGLEntries; begin if FindFirstCFLedgEntry[Level] then begin FindFirstCFLedgEntry[Level] := false; TempCFForecastEntry.Reset(); TempCFForecastEntry.DeleteAll(); if AnalysisViewEntry.Find('-') then repeat AnalysisViewEntryToGLEntries.GetCFLedgEntries(AnalysisViewEntry, TempCFForecastEntry); until AnalysisViewEntry.Next() = 0; TempCFForecastEntry.SetCurrentKey("Cash Flow Forecast No.", "Cash Flow Account No.", "Source Type", "Cash Flow Date"); TempCFForecastEntry.SetFilter("Cash Flow Date", DateFilter); OnBeforeTempCFForecastEntryfind(TempCFForecastEntry, Level); if not TempCFForecastEntry.Find('-') then exit(false); end else begin OnBeforeTempCFForecastEntrynext(TempCFForecastEntry, Level); if TempCFForecastEntry.Next() = 0 then exit(false); end; 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 Total[i] := Total[i] + TempCFForecastEntry."Amount (LCY)"; end; local procedure UpdateColumnDim() var SelectedDim: Record "Selected Dimension"; TempDimSelectionBuf: Record "Dimension Selection Buffer" temporary; AnalysisView: Record "Analysis View"; begin AnalysisView.CopyAnalysisViewFilters(3, REPORT::"Cash Flow Dimensions - Detail", AnalysisViewCode); ColumnDim := ''; SelectedDim.SetRange("User ID", UserId); SelectedDim.SetRange("Object Type", 3); SelectedDim.SetRange("Object ID", REPORT::"Cash Flow 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::"Cash Flow 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 TempCFAccount.TableCaption: begin TempCFAccount.Reset(); TempCFAccount.SetFilter("No.", IterationFilter); if FindFirstRec then SearchResult := TempCFAccount.Find('-') else if TempCFAccount.Get(IterationDimValCode) then SearchResult := (TempCFAccount.Next() <> 0); if SearchResult then begin IterationDimValCode := TempCFAccount."No."; IterationDimValName := TempCFAccount.Name; end; end; TempCashFlowForecast.TableCaption: begin TempCashFlowForecast.Reset(); TempCashFlowForecast.SetFilter("No.", IterationFilter); if FindFirstRec then SearchResult := TempCashFlowForecast.Find('-') else if TempCashFlowForecast.Get(IterationDimValCode) then SearchResult := (TempCashFlowForecast.Next() <> 0); if SearchResult then begin IterationDimValCode := TempCashFlowForecast."No."; if TempCashFlowForecast."No." <> '' then IterationDimValName := TempCashFlowForecast.Description else IterationDimValName := Text006; 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 TempCFAccount.TableCaption: if AnalysisViewFilter = '*' then AnalysisViewEntry.SetRange("Account No.") else begin AnalysisViewEntry.SetFilter("Account No.", AnalysisViewFilter); AnalysisViewEntry.SetRange("Account Source", AnalysisViewEntry."Account Source"::"Cash Flow Account"); end; TempCashFlowForecast.TableCaption: if AnalysisViewFilter = '*' then AnalysisViewEntry.SetRange("Cash Flow Forecast No.") else AnalysisViewEntry.SetFilter("Cash Flow Forecast No.", 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; local procedure CompileFilterCaptionString(NewFilterCode: Text[250]; NewFilterValue: Text[250]) var Prefix: Text[2]; begin if DimFilterText <> '' then Prefix := ', '; DimFilterText := CopyStr(DimFilterText + Prefix + NewFilterCode + ': ' + NewFilterValue, 1, MaxStrLen(DimFilterText)); end; procedure InitializeRequest(NewAnalysisViewCode: Code[10]; NewCashFlowFilter: Text[100]; NewDateFilter: Text[100]; NewPrintEmptyLines: Boolean) begin AnalysisViewCode := NewAnalysisViewCode; CFFilter := NewCashFlowFilter; UpdateColumnDim(); DateFilter := NewDateFilter; PrintEmptyLines := NewPrintEmptyLines; OnAfterInitializeRequest(AnalysisViewCode, CFFilter, DateFilter, PrintEmptyLines); end; [IntegrationEvent(true, false)] local procedure OnAfterInitializeRequest(var AnalysisViewCode: Code[10]; var CFFilter: Text[100]; var DateFilterv: Text[100]; var PrintEmptyLines: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeTempCFForecastEntryfind(TempCFForecastEntry: Record "Cash Flow Forecast Entry"; Level: Integer) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeTempCFForecastEntrynext(TempCFForecastEntry: Record "Cash Flow Forecast Entry"; Level: Integer) begin end; [IntegrationEvent(true, false)] local procedure OnAfterCalcLine(DimCode: Text[30]; DimValCode: Code[20]; DimValName: Text[100]; Level: Integer) begin end;}