Table 85 Acc. Schedule Line
src/Layers/W1/BaseApp/Finance/FinancialReports/AccScheduleLine.Table.al892 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.FinancialReports;using Microsoft.CashFlow.Account;using Microsoft.CashFlow.Forecast;using Microsoft.CostAccounting.Account;using Microsoft.CostAccounting.Budget;using Microsoft.Finance.Analysis;using Microsoft.Finance.Consolidation;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.Finance.GeneralLedger.Setup;/// <summary>/// Defines individual line items within account schedules for detailed financial report row configuration./// Contains row-specific settings including totaling formulas, formatting, dimensions, and filter criteria for financial analysis./// </summary>/// <remarks>/// Core table for account schedule line definitions with support for G/L accounts, cost accounting, cash flow forecasting, and multi-dimensional analysis./// Integrates with Analysis Views, G/L Budget entries, and dimension filtering for comprehensive financial reporting capabilities./// Extensibility: OnBeforeLookupTotaling, OnAfterLookupTotaling, OnBeforeLookUpDimFilter events for custom totaling and filtering logic./// </remarks>table 85 "Acc. Schedule Line"{ Caption = 'Acc. Schedule Line'; DataClassification = CustomerContent; fields { /// <summary> /// Account schedule name linking this line to the parent account schedule definition. /// </summary> field(1; "Schedule Name"; Code[10]) { Caption = 'Schedule Name'; TableRelation = "Acc. Schedule Name"; ToolTip = 'Specifies the unique name (code) of the financial report row definition. You can use up to 10 characters.'; } /// <summary> /// Sequential line number for ordering and referencing account schedule lines within the schedule. /// </summary> field(2; "Line No."; Integer) { Caption = 'Line No.'; } /// <summary> /// Display row number for user identification and reference in financial reports. /// </summary> field(3; "Row No."; Code[10]) { Caption = 'Row No.'; ToolTip = 'Specifies a number that identifies the line.'; } /// <summary> /// Descriptive text explaining the purpose and content of the account schedule line. /// </summary> field(4; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies text that will appear on the financial report line.'; } /// <summary> /// Account numbers, formulas, or expressions used to calculate line values from G/L accounts or other sources. /// </summary> field(5; Totaling; Text[250]) { Caption = 'Totaling'; TableRelation = if ("Totaling Type" = const("Posting Accounts")) "G/L Account" else if ("Totaling Type" = const("Total Accounts")) "G/L Account" else if ("Totaling Type" = const("Account Category")) "G/L Account Category" else if ("Totaling Type" = const("Cash Flow Entry Accounts")) "Cash Flow Account" else if ("Totaling Type" = const("Cash Flow Total Accounts")) "Cash Flow Account" else if ("Totaling Type" = const("Cost Type")) "Cost Type" else if ("Totaling Type" = const("Cost Type Total")) "Cost Type"; ValidateTableRelation = false; trigger OnLookup() begin LookupTotaling(); end; trigger OnValidate() var GLAccCategory: Record "G/L Account Category"; begin case "Totaling Type" of "Totaling Type"::"Posting Accounts", "Totaling Type"::"Total Accounts": begin GLAcc.SetFilter("No.", Totaling); GLAcc.CalcFields(Balance); if GLAcc.Count() = 1 then begin GLAcc.FindFirst(); "Row No." := "Row No." = '' ? CopyStr(GLAcc."No.", 1, MaxStrLen("Row No.")) : "Row No."; Description := Description = '' ? GLAcc.Name : Description; end; end; "Totaling Type"::"Account Category": begin GLAccCategory.SetFilter("Entry No.", Totaling); if GLAccCategory.Count() = 1 then begin GLAccCategory.FindFirst(); "Row No." := "Row No." = '' ? CopyStr(Format(GLAccCategory."Entry No."), 1, MaxStrLen("Row No.")) : "Row No."; Description := Description = '' ? GLAccCategory.Description : Description; end; end; "Totaling Type"::Formula, "Totaling Type"::"Set Base For Percent": begin Totaling := UpperCase(Totaling); CheckFormula(Totaling); end; "Totaling Type"::"Cost Type", "Totaling Type"::"Cost Type Total": begin CostType.SetFilter("No.", Totaling); CostType.CalcFields(Balance); if CostType.Count() = 1 then begin CostType.FindFirst(); "Row No." := "Row No." = '' ? CopyStr(CostType."No.", 1, MaxStrLen("Row No.")) : "Row No."; Description := Description = '' ? CostType.Name : Description; end; end; "Totaling Type"::"Cash Flow Entry Accounts", "Totaling Type"::"Cash Flow Total Accounts": begin CFAccount.SetFilter("No.", Totaling); CFAccount.CalcFields(Amount); if CFAccount.Count() = 1 then begin CFAccount.FindFirst(); "Row No." := "Row No." = '' ? CopyStr(CFAccount."No.", 1, MaxStrLen("Row No.")) : "Row No."; Description := Description = '' ? CFAccount.Name : Description; end; end; end; end; } /// <summary> /// Type of calculation method for the totaling field (G/L accounts, formulas, cost types, cash flow accounts). /// </summary> field(6; "Totaling Type"; Enum "Acc. Schedule Line Totaling Type") { Caption = 'Totaling Type'; ToolTip = 'Specifies the totaling type for the financial report line. The type determines which accounts within the totaling interval you specify in the Totaling field will be totaled.'; trigger OnValidate() begin Validate(Totaling); end; } /// <summary> /// Forces page break before this line in printed reports. /// </summary> field(7; "New Page"; Boolean) { Caption = 'New Page'; ToolTip = 'Specifies whether there will be a page break after the current line when the financial report is exported to PDF or printed.'; } /// <summary> /// Visual indentation level for hierarchical display of account schedule lines. /// </summary> field(8; Indentation; Integer) { Caption = 'Indentation'; } /// <summary> /// Date filter for limiting G/L entries and budget entries used in calculations. /// </summary> field(11; "Date Filter"; Date) { Caption = 'Date Filter'; FieldClass = FlowFilter; } /// <summary> /// Dimension 1 filter for multi-dimensional analysis and reporting. /// </summary> field(12; "Dimension 1 Filter"; Code[20]) { CaptionClass = GetCaptionClass(1); Caption = 'Dimension 1 Filter'; FieldClass = FlowFilter; } /// <summary> /// Dimension 2 filter for multi-dimensional analysis and reporting. /// </summary> field(13; "Dimension 2 Filter"; Code[20]) { CaptionClass = GetCaptionClass(2); Caption = 'Dimension 2 Filter'; FieldClass = FlowFilter; } /// <summary> /// G/L budget name filter for budget comparison and analysis. /// </summary> field(14; "G/L Budget Filter"; Code[10]) { Caption = 'G/L Budget Filter'; FieldClass = FlowFilter; TableRelation = "G/L Budget Name"; } /// <summary> /// Business unit filter for consolidation and multi-company analysis. /// </summary> field(15; "Business Unit Filter"; Code[20]) { Caption = 'Business Unit Filter'; FieldClass = FlowFilter; TableRelation = "Business Unit"; } /// <summary> /// Controls visibility of the line in reports (Yes, No, If Any Column Not Zero, When Positive Balance, When Negative Balance). /// </summary> field(16; Show; Enum "Acc. Schedule Line Show") { Caption = 'Show'; ToolTip = 'Specifies whether the line will be printed on the report.'; } /// <summary> /// Dimension 3 filter for extended multi-dimensional analysis and reporting. /// </summary> field(17; "Dimension 3 Filter"; Code[20]) { CaptionClass = GetCaptionClass(3); Caption = 'Dimension 3 Filter'; FieldClass = FlowFilter; } /// <summary> /// Dimension 4 filter for extended multi-dimensional analysis and reporting. /// </summary> field(18; "Dimension 4 Filter"; Code[20]) { CaptionClass = GetCaptionClass(4); Caption = 'Dimension 4 Filter'; FieldClass = FlowFilter; } /// <summary> /// Dimension 1 value filter for totaling specific dimension values in calculations. /// </summary> field(19; "Dimension 1 Totaling"; Text[250]) { AccessByPermission = TableData Dimension = R; CaptionClass = GetCaptionClass(5); Caption = 'Dimension 1 Totaling'; ToolTip = 'Specifies which dimension value amounts will be totaled on this line.'; //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set //ValidateTableRelation = false; } /// <summary> /// Dimension 2 value filter for totaling specific dimension values in calculations. /// </summary> field(20; "Dimension 2 Totaling"; Text[250]) { AccessByPermission = TableData Dimension = R; CaptionClass = GetCaptionClass(6); Caption = 'Dimension 2 Totaling'; ToolTip = 'Specifies which dimension value amounts will be totaled on this line.'; //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set //ValidateTableRelation = false; } /// <summary> /// Dimension 3 value filter for totaling specific dimension values in calculations. /// </summary> field(21; "Dimension 3 Totaling"; Text[250]) { AccessByPermission = TableData "Dimension Combination" = R; CaptionClass = GetCaptionClass(7); Caption = 'Dimension 3 Totaling'; ToolTip = 'Specifies which dimension value amounts will be totaled on this line.'; //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set //ValidateTableRelation = false; } /// <summary> /// Dimension 4 value filter for totaling specific dimension values in calculations. /// </summary> field(22; "Dimension 4 Totaling"; Text[250]) { AccessByPermission = TableData "Dimension Combination" = R; CaptionClass = GetCaptionClass(8); Caption = 'Dimension 4 Totaling'; ToolTip = 'Specifies which dimension value amounts will be totaled on this line.'; //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set //ValidateTableRelation = false; } /// <summary> /// Applies bold formatting to this line in report output. /// </summary> field(23; Bold; Boolean) { Caption = 'Bold'; ToolTip = 'Specifies whether to print the amounts in this row in bold.'; } /// <summary> /// Applies italic formatting to this line in report output. /// </summary> field(24; Italic; Boolean) { Caption = 'Italic'; ToolTip = 'Specifies whether to print the amounts in this row in italics.'; } /// <summary> /// Applies underline formatting to this line in report output. /// </summary> field(25; Underline; Boolean) { Caption = 'Underline'; ToolTip = 'Specifies whether to underline the amounts in this row.'; trigger OnValidate() begin if "Double Underline" and Underline then begin "Double Underline" := false; Message(ForceUnderLineMsg, FieldCaption("Double Underline")); end; end; } /// <summary> /// Displays values with opposite sign (positive as negative, negative as positive). /// </summary> field(26; "Show Opposite Sign"; Boolean) { Caption = 'Show Opposite Sign'; ToolTip = 'Specifies whether to show debits in reports as negative amounts with a minus sign and credits as positive amounts.'; } /// <summary> /// Type of balance calculation (Net Change, Balance at Date, Beginning Balance). /// </summary> field(27; "Row Type"; Option) { Caption = 'Row Type'; ToolTip = 'Specifies the row type for the row definition. The type determines how the amounts in the row are calculated.'; OptionCaption = 'Net Change,Balance at Date,Beginning Balance'; OptionMembers = "Net Change","Balance at Date","Beginning Balance"; } /// <summary> /// Amount type for calculations (Net Amount, Debit Amount, Credit Amount). /// </summary> field(28; "Amount Type"; Enum "Account Schedule Amount Type") { Caption = 'Amount Type'; ToolTip = 'Specifies the type of entries that will be included in the amounts in the row definition.'; } /// <summary> /// Applies double underline formatting to this line in report output. /// </summary> field(30; "Double Underline"; Boolean) { Caption = 'Double Underline'; ToolTip = 'Specifies whether to double underline the amounts in this row.'; trigger OnValidate() begin if "Double Underline" and Underline then begin Underline := false; Message(ForceUnderLineMsg, FieldCaption(Underline)); end; end; } /// <summary> /// Hides currency symbol in amount display for formula-based calculations. /// </summary> field(40; "Hide Currency Symbol"; Boolean) { Caption = 'Hide Currency Symbol'; ToolTip = 'Specifies whether to hide currency symbols when a calculated result is not a currency.'; trigger OnValidate() begin if "Hide Currency Symbol" then TestField("Totaling Type", "Acc. Schedule Line Totaling Type"::Formula); end; } field(41; "Dimension 5 Filter"; Text[250]) { Caption = 'Dimension 5 Filter'; FieldClass = FlowFilter; } field(42; "Dimension 6 Filter"; Text[250]) { Caption = 'Dimension 6 Filter'; FieldClass = FlowFilter; } field(43; "Dimension 7 Filter"; Text[250]) { Caption = 'Dimension 7 Filter'; FieldClass = FlowFilter; } field(45; "Dimension 8 Filter"; Text[250]) { Caption = 'Dimension 8 Filter'; FieldClass = FlowFilter; } /// <summary> /// Extended internal description for detailed documentation of the account schedule line definition purpose and usage. /// </summary>#if not CLEAN28#pragma warning disable AS0086#endif field(46; "Internal Description"; Text[500])#if not CLEAN28#pragma warning restore AS0086#endif { Caption = 'Internal Description'; ToolTip = 'Specifies the internal description for the row definition line that highlights complex logic or areas needing review for the next report designer.'; } /// <summary> /// Cash flow forecast filter for cash flow-based calculations and analysis. /// </summary> field(840; "Cash Flow Forecast Filter"; Code[20]) { Caption = 'Cash Flow Forecast Filter'; FieldClass = FlowFilter; TableRelation = "Cash Flow Forecast"; } /// <summary> /// Cost center filter for cost accounting calculations and analysis. /// </summary> field(1100; "Cost Center Filter"; Code[20]) { Caption = 'Cost Center Filter'; FieldClass = FlowFilter; TableRelation = "Cost Center"; } /// <summary> /// Cost object filter for cost accounting calculations and analysis. /// </summary> field(1101; "Cost Object Filter"; Code[20]) { Caption = 'Cost Object Filter'; FieldClass = FlowFilter; TableRelation = "Cost Object"; } /// <summary> /// Cost center totaling filter for aggregating specific cost centers in calculations. /// </summary> field(1102; "Cost Center Totaling"; Text[80]) { Caption = 'Cost Center Totaling'; //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set //ValidateTableRelation = false; } /// <summary> /// Cost object totaling filter for aggregating specific cost objects in calculations. /// </summary> field(1103; "Cost Object Totaling"; Text[80]) { Caption = 'Cost Object Totaling'; //The property 'ValidateTableRelation' can only be set if the property 'TableRelation' is set //ValidateTableRelation = false; } /// <summary> /// Cost budget filter for cost accounting budget analysis and comparison. /// </summary> field(1104; "Cost Budget Filter"; Code[10]) { Caption = 'Cost Budget Filter'; FieldClass = FlowFilter; TableRelation = "Cost Budget Name"; } } keys { key(Key1; "Schedule Name", "Line No.") { Clustered = true; } } fieldgroups { } trigger OnInsert() begin if xRec."Line No." = 0 then if not AccSchedName.Get("Schedule Name") then begin AccSchedName.Init(); AccSchedName.Name := "Schedule Name"; if AccSchedName.Name = '' then AccSchedName.Description := Text000; AccSchedName.Insert(); end; end; var AccSchedName: Record "Acc. Schedule Name"; GLAcc: Record "G/L Account"; CFAccount: Record "Cash Flow Account"; AnalysisView: Record "Analysis View"; GLSetup: Record "General Ledger Setup"; CostType: Record "Cost Type"; HasGLSetup: Boolean; ForceUnderLineMsg: Label '%1 will be set to false.', Comment = '%1= Field underline ';#pragma warning disable AA0074 Text000: Label 'Default Schedule';#pragma warning disable AA0470 Text001: Label 'The parenthesis at position %1 is misplaced.'; Text002: Label 'You cannot have two consecutive operators. The error occurred at position %1.'; Text003: Label 'There is an operand missing after position %1.';#pragma warning restore AA0470 Text004: Label 'There are more left parentheses than right parentheses.'; Text005: Label 'There are more right parentheses than left parentheses.'; Text006: Label '1,6,,Dimension 1 Filter'; Text007: Label '1,6,,Dimension 2 Filter'; Text008: Label '1,6,,Dimension 3 Filter'; Text009: Label '1,6,,Dimension 4 Filter'; Text010: Label ',, Totaling'; Text011: Label '1,5,,Dimension 1 Totaling'; Text012: Label '1,5,,Dimension 2 Totaling'; Text013: Label '1,5,,Dimension 3 Totaling'; Text014: Label '1,5,,Dimension 4 Totaling';#pragma warning disable AA0470 Text015: Label 'The %1 refers to %2 %3, which does not exist. The field %4 on table %5 has now been deleted.';#pragma warning restore AA0470#pragma warning restore AA0074 /// <summary> /// Opens dimension value lookup dialog for the specified dimension number and returns selected filter values. /// Enables interactive dimension value selection for dimension-based filtering in account schedule calculations. /// </summary> /// <param name="DimNo">Dimension number (1-4) to look up values for</param> /// <param name="Text">Filter text containing selected dimension values</param> /// <returns>True if user selected dimension values, false if cancelled</returns> procedure LookUpDimFilter(DimNo: Integer; var Text: Text) Result: Boolean var DimVal: Record "Dimension Value"; DimValList: Page "Dimension Value List"; IsHandled: Boolean; begin GetAccSchedSetup(); IsHandled := false; OnBeforeLookUpDimFilter(Rec, DimNo, Text, AccSchedName, Result, IsHandled); if IsHandled then exit(Result); case DimNo of 1: DimVal.SetRange("Dimension Code", AnalysisView."Dimension 1 Code"); 2: DimVal.SetRange("Dimension Code", AnalysisView."Dimension 2 Code"); 3: DimVal.SetRange("Dimension Code", AnalysisView."Dimension 3 Code"); 4: DimVal.SetRange("Dimension Code", AnalysisView."Dimension 4 Code"); end; DimValList.LookupMode(true); DimValList.SetTableView(DimVal); if DimValList.RunModal() = ACTION::LookupOK then begin DimValList.GetRecord(DimVal); Text := DimValList.GetSelectionFilter(); exit(true); end; exit(false) end; /// <summary> /// Validates formula syntax for proper parentheses matching and operator placement in account schedule formulas. /// Ensures formulas are syntactically correct before use in financial calculations. /// </summary> /// <param name="Formula">Formula expression to validate for syntax correctness</param> procedure CheckFormula(Formula: Code[250]) var i: Integer; ParenthesesLevel: Integer; HasOperator: Boolean; begin ParenthesesLevel := 0; for i := 1 to StrLen(Formula) do begin if Formula[i] = '(' then ParenthesesLevel := ParenthesesLevel + 1 else if Formula[i] = ')' then ParenthesesLevel := ParenthesesLevel - 1; if ParenthesesLevel < 0 then Error(Text001, i); if Formula[i] in ['+', '-', '*', '/', '^'] then begin if HasOperator then Error(Text002, i); HasOperator := true; if i = StrLen(Formula) then Error(Text003, i); if Formula[i + 1] = ')' then Error(Text003, i); end else HasOperator := false; end; if ParenthesesLevel > 0 then Error(Text004); if ParenthesesLevel < 0 then Error(Text005); OnAfterCheckFormula(Formula); end; /// <summary> /// Generates caption class text for dimension fields based on analysis view configuration. /// Provides dynamic field captions that reflect the actual dimension codes configured in the analysis view. /// </summary> /// <param name="AnalysisViewDimType">Dimension type number (1-8) for caption class generation</param> /// <returns>Caption class text for dimension field display</returns> procedure GetCaptionClass(AnalysisViewDimType: Integer) Result: Text[250] var IsHandled: Boolean; begin GetAccSchedSetup(); IsHandled := false; OnBeforeGetCaptionClass(Rec, AccSchedName, AnalysisViewDimType, Result, IsHandled); if IsHandled then exit(Result); case AnalysisViewDimType of 1: begin if AnalysisView."Dimension 1 Code" <> '' then exit('1,6,' + AnalysisView."Dimension 1 Code"); exit(Text006); end; 2: begin if AnalysisView."Dimension 2 Code" <> '' then exit('1,6,' + AnalysisView."Dimension 2 Code"); exit(Text007); end; 3: begin if AnalysisView."Dimension 3 Code" <> '' then exit('1,6,' + AnalysisView."Dimension 3 Code"); exit(Text008); end; 4: begin if AnalysisView."Dimension 4 Code" <> '' then exit('1,6,' + AnalysisView."Dimension 4 Code"); exit(Text009); end; 5: begin if AnalysisView."Dimension 1 Code" <> '' then exit('1,5,' + AnalysisView."Dimension 1 Code" + Text010); exit(Text011); end; 6: begin if AnalysisView."Dimension 2 Code" <> '' then exit('1,5,' + AnalysisView."Dimension 2 Code" + Text010); exit(Text012); end; 7: begin if AnalysisView."Dimension 3 Code" <> '' then exit('1,5,' + AnalysisView."Dimension 3 Code" + Text010); exit(Text013); end; 8: begin if AnalysisView."Dimension 4 Code" <> '' then exit('1,5,' + AnalysisView."Dimension 4 Code" + Text010); exit(Text014); end; end; end; local procedure GetAccSchedSetup() begin if "Schedule Name" <> AccSchedName.Name then AccSchedName.Get("Schedule Name"); if AccSchedName."Analysis View Name" <> '' then if AccSchedName."Analysis View Name" <> AnalysisView.Code then if not AnalysisView.Get(AccSchedName."Analysis View Name") then begin Message( Text015, AccSchedName.TableCaption(), AnalysisView.TableCaption(), AccSchedName."Analysis View Name", AccSchedName.FieldCaption("Analysis View Name"), AccSchedName.TableCaption()); AccSchedName."Analysis View Name" := ''; AccSchedName.Modify(); end; if AccSchedName."Analysis View Name" = '' then begin if not HasGLSetup then begin GLSetup.Get(); HasGLSetup := true; end; Clear(AnalysisView); AnalysisView."Dimension 1 Code" := GLSetup."Global Dimension 1 Code"; AnalysisView."Dimension 2 Code" := GLSetup."Global Dimension 2 Code"; end; OnAfterGetAccSchedSetup(AnalysisView, AccSchedName); end; /// <summary> /// Opens appropriate lookup dialog based on totaling type for selecting accounts, cost types, or cash flow accounts. /// Provides user-friendly selection interface for building totaling expressions in account schedule lines. /// </summary> procedure LookupTotaling() var GLAccList: Page "G/L Account List"; CostTypeList: Page "Cost Type List"; CFAccList: Page "Cash Flow Account List"; GLAccCatList: Page "G/L Account Categories"; IsHandled: Boolean; begin IsHandled := false; OnBeforeLookupTotaling(Rec, IsHandled); if IsHandled then exit; case "Totaling Type" of "Totaling Type"::"Posting Accounts", "Totaling Type"::"Total Accounts": begin GLAccList.LookupMode(true); if GLAccList.RunModal() = ACTION::LookupOK then Validate(Totaling, GLAccList.GetSelectionFilter()); end; "Totaling Type"::"Cost Type", "Totaling Type"::"Cost Type Total": begin CostTypeList.LookupMode(true); if CostTypeList.RunModal() = ACTION::LookupOK then Validate(Totaling, CostTypeList.GetSelectionFilter()); end; "Totaling Type"::"Cash Flow Entry Accounts", "Totaling Type"::"Cash Flow Total Accounts": begin CFAccList.LookupMode(true); if CFAccList.RunModal() = ACTION::LookupOK then Validate(Totaling, CFAccList.GetSelectionFilter()); end; "Totaling Type"::"Account Category": begin GLAccCatList.LookupMode(true); if GLAccCatList.RunModal() = ACTION::LookupOK then Validate(Totaling, GLAccCatList.GetSelectionFilter()); end; end; OnAfterLookupTotaling(Rec); end; /// <summary> /// Opens G/L budget name lookup dialog and returns selected budget names as filter text. /// Enables interactive selection of G/L budgets for budget-based financial analysis. /// </summary> /// <param name="Text">Filter text containing selected G/L budget names</param> /// <returns>True if user selected budget names, false if cancelled</returns> procedure LookupGLBudgetFilter(var Text: Text): Boolean var GLBudgetNames: Page "G/L Budget Names"; begin GLBudgetNames.LookupMode(true); if GLBudgetNames.RunModal() = ACTION::LookupOK then begin Text := GLBudgetNames.GetSelectionFilter(); exit(true); end; exit(false) end; /// <summary> /// Opens cost budget name lookup dialog and returns selected budget names as filter text. /// Enables interactive selection of cost budgets for cost accounting-based financial analysis. /// </summary> /// <param name="Text">Filter text containing selected cost budget names</param> /// <returns>True if user selected budget names, false if cancelled</returns> procedure LookupCostBudgetFilter(var Text: Text): Boolean var CostBudgetNames: Page "Cost Budget Names"; begin CostBudgetNames.LookupMode(true); if CostBudgetNames.RunModal() = ACTION::LookupOK then begin Text := CostBudgetNames.GetSelectionFilter(); exit(true); end; exit(false) end; /// <summary> /// Increases indentation level for hierarchical display of account schedule line. /// Maximum indentation level is 10. /// </summary> procedure Indent() begin if Indentation < 10 then Indentation += 1; end; /// <summary> /// Decreases indentation level for hierarchical display of account schedule line. /// Minimum indentation level is 0. /// </summary> procedure Outdent() begin if Indentation > 0 then Indentation -= 1; end; /// <summary> /// Integration event raised after formula validation to enable custom formula processing and validation logic. /// Allows extensions to modify or validate formulas beyond standard syntax checking. /// </summary> /// <param name="Formula">Formula expression that has been validated and may be modified</param> [IntegrationEvent(false, false)] local procedure OnAfterCheckFormula(var Formula: Code[250]) begin end; /// <summary> /// Integration event raised after totaling lookup to enable custom post-processing of selected totaling values. /// Allows extensions to modify totaling expressions or perform additional validation after user selection. /// </summary> /// <param name="AccScheduleLine">Account schedule line record that was updated with totaling information</param> [IntegrationEvent(false, false)] local procedure OnAfterLookupTotaling(var AccScheduleLine: Record "Acc. Schedule Line") begin end; /// <summary> /// Integration event raised after account schedule setup retrieval to enable custom analysis view configuration. /// Allows extensions to modify analysis view settings or dimension codes for custom reporting requirements. /// </summary> /// <param name="AnalysisView">Analysis view record that may be modified for custom configuration</param> /// <param name="AccScheduleName">Account schedule name record providing context for analysis view setup</param> [IntegrationEvent(false, false)] local procedure OnAfterGetAccSchedSetup(var AnalysisView: Record "Analysis View"; AccScheduleName: Record "Acc. Schedule Name") begin end; /// <summary> /// Integration event raised before caption class generation to enable custom dimension caption handling. /// Allows extensions to provide custom caption class formatting for dimension fields. /// </summary> /// <param name="AccScheduleLine">Account schedule line record for context</param> /// <param name="AccSchedName">Account schedule name record providing analysis view context</param> /// <param name="AnalysisViewDimType">Dimension type number (1-4) for caption class generation</param> /// <param name="Result">Caption class result text that may be modified</param> /// <param name="IsHandled">Set to true to skip standard caption class generation</param> [IntegrationEvent(false, false)] local procedure OnBeforeGetCaptionClass(var AccScheduleLine: Record "Acc. Schedule Line"; AccSchedName: Record "Acc. Schedule Name"; AnalysisViewDimType: Integer; var Result: Text[250]; var IsHandled: Boolean) begin end; /// <summary> /// Integration event raised before totaling lookup to enable custom totaling selection logic. /// Allows extensions to provide alternative totaling lookup mechanisms or skip standard lookup. /// </summary> /// <param name="AccScheduleLine">Account schedule line record for context</param> /// <param name="IsHandled">Set to true to skip standard totaling lookup processing</param> [IntegrationEvent(false, false)] local procedure OnBeforeLookupTotaling(var AccScheduleLine: Record "Acc. Schedule Line"; var IsHandled: Boolean) begin end; /// <summary> /// Integration event raised before dimension filter lookup to enable custom dimension filtering logic. /// Allows extensions to provide alternative dimension value selection mechanisms or skip standard lookup. /// </summary> /// <param name="AccScheduleLine">Account schedule line record for context</param> /// <param name="DimNo">Dimension number (1-4) being looked up</param> /// <param name="Text">Dimension filter text that may be modified</param> /// <param name="AccSchedName">Account schedule name record providing analysis view context</param> /// <param name="Result">Lookup result that may be set by extension</param> /// <param name="IsHandled">Set to true to skip standard dimension filter lookup processing</param> [IntegrationEvent(false, false)] local procedure OnBeforeLookUpDimFilter(var AccScheduleLine: Record "Acc. Schedule Line"; DimNo: Integer; var Text: Text; AccSchedName: Record "Acc. Schedule Name"; var Result: Boolean; var IsHandled: Boolean) begin end;}