--- id: object/table/85 type: object title: Table 85 "Acc. Schedule Line" summary: Table 85 "Acc. Schedule Line" in Base Application (Microsoft.Finance.FinancialReports). 39 fields, 8 public procedures, 6 events. Present since at least BC23, still in BC30, changed in BC24, BC28-29. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "29" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 9ed710cd3d42a7a357a47c143850fe556dd6e72c3bf86805e99e85d4b8519d86 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/AccScheduleLine.Table.al title: src/Layers/W1/BaseApp/Finance/FinancialReports/AccScheduleLine.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/bi-account-categories - https://learn.microsoft.com/dynamics365/business-central/bi-design-financial-reports - https://learn.microsoft.com/dynamics365/business-central/bi-examples-custom-financial-reports - https://learn.microsoft.com/dynamics365/business-central/bi-how-work-account-schedule - https://learn.microsoft.com/dynamics365/business-central/bi-row-definitions - https://learn.microsoft.com/dynamics365/business-central/bi-troubleshoot-financial-reports - https://learn.microsoft.com/dynamics365/business-central/bi - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-capabilities - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-faq - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-integrate-financial-reports-with-excel - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-view-a-report - https://learn.microsoft.com/dynamics365/business-central/sustainability-fin-reporting - https://learn.microsoft.com/dynamics365/business-central/bi-column-definitions - https://learn.microsoft.com/dynamics365/business-central/bi-how-to-set-up-and-publish-kpi-web-services-based-on-account-schedules - https://learn.microsoft.com/dynamics365/business-central/walkthrough-making-cash-flow-forecasts-by-using-account-schedules objects: [] features: [] topics: - topic/business-central/analytics-business-intelligence-and-repo/built-in-reports/finance - topic/business-central/analytics-business-intelligence-and-repo/kpis-dashboards-and-financial-reports - topic/business-central/business-functionality/finance/financial-analytics - topic/business-central/business-functionality/finance/financial-analytics/financial-reporting - topic/business-central/business-functionality/finance/manage-cash-flow - topic/business-central/business-functionality/set-up-business-central/set-up-finance - topic/business-central/business-functionality/sustainability-management/sustainability-analytics - topic/business-central/get-started/learn/business-process-walkthroughs localizations: - localization/ch - localization/es - localization/ru videos: [] posts: [] guidelines: [] object_type: table object_id: 85 name: Acc. Schedule Line namespace: Microsoft.Finance.FinancialReports app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "24" - "28" - "29" source_major: "29" obsolete: null countries: - ch - es - ru ms_search_form_ids: [] counts: fields: 39 procedures: 15 events: 6 subscribers: 0 relations: out: 10 referenced_by: 1 pages: 2 extended_by: 1 event_subscribers: 6 calls: 0 called_by: 0 implements: 0 --- # Table 85 "Acc. Schedule Line" > Table 85 "Acc. Schedule Line" in Base Application (Microsoft.Finance.FinancialReports). 39 fields, 8 public procedures, 6 events. Present since at least BC23, still in BC30, changed in BC24, BC28-29. Base Application · Microsoft.Finance.FinancialReports · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/AccScheduleLine.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 490 "Acc. Schedule Overview"](../page/490.md) (12 Learn pages), [Page 104 "Account Schedule"](../page/104.md) (8). ## Properties | Property | Value | |---|---| | Caption | Acc. Schedule Line | | DataClassification | CustomerContent | ## Fields Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name. | No. | Name | Type | Explanation | Notes | |---|---|---|---|---| | 1 | Schedule Name | Code[10] | Specifies the unique name (code) of the financial report row definition. You can use up to 10 characters. | TableRelation [Table 84 "Acc. Schedule Name"](../table/84.md) (Acc. Schedule Name) | | 2 | Line No. | Integer | — | | | 3 | Row No. | Code[10] | Specifies a number that identifies the line. | | | 4 | Description | Text[100] | Specifies text that will appear on the financial report line. | | | 5 | Totaling | Text[250] | — | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 570 "G/L Account Category"](../table/570.md), [Table 841 "Cash Flow Account"](../table/841.md) (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 ("To...) | | 6 | Totaling Type | Enum "Acc. Schedule Line Totaling Type" | 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. | enum [Enum 85 "Acc. Schedule Line Totaling Type"](../enum/85.md) | | 7 | New Page | Boolean | Specifies whether there will be a page break after the current line when the financial report is exported to PDF or printed. | | | 8 | Indentation | Integer | — | | | 11 | Date Filter | Date | — | FlowFilter | | 12 | Dimension 1 Filter | Code[20] | — | FlowFilter | | 13 | Dimension 2 Filter | Code[20] | — | FlowFilter | | 14 | G/L Budget Filter | Code[10] | — | TableRelation [Table 95 "G/L Budget Name"](../table/95.md) (G/L Budget Name); FlowFilter | | 15 | Business Unit Filter | Code[20] | — | TableRelation [Table 220 "Business Unit"](../table/220.md) (Business Unit); FlowFilter | | 16 | Show | Enum "Acc. Schedule Line Show" | Specifies whether the line will be printed on the report. | enum [Enum 851 "Acc. Schedule Line Show"](../enum/851.md) | | 17 | Dimension 3 Filter | Code[20] | — | FlowFilter | | 18 | Dimension 4 Filter | Code[20] | — | FlowFilter | | 19 | Dimension 1 Totaling | Text[250] | Specifies which dimension value amounts will be totaled on this line. | | | 20 | Dimension 2 Totaling | Text[250] | Specifies which dimension value amounts will be totaled on this line. | | | 21 | Dimension 3 Totaling | Text[250] | Specifies which dimension value amounts will be totaled on this line. | | | 22 | Dimension 4 Totaling | Text[250] | Specifies which dimension value amounts will be totaled on this line. | | | 23 | Bold | Boolean | Specifies whether to print the amounts in this row in bold. | | | 24 | Italic | Boolean | Specifies whether to print the amounts in this row in italics. | | | 25 | Underline | Boolean | Specifies whether to underline the amounts in this row. | | | 26 | Show Opposite Sign | Boolean | Specifies whether to show debits in reports as negative amounts with a minus sign and credits as positive amounts. | | | 27 | Row Type | Option | 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 | | 28 | Amount Type | Enum "Account Schedule Amount Type" | Specifies the type of entries that will be included in the amounts in the row definition. | enum [Enum 333 "Account Schedule Amount Type"](../enum/333.md) | | 30 | Double Underline | Boolean | Specifies whether to double underline the amounts in this row. | | | 40 | Hide Currency Symbol | Boolean | Specifies whether to hide currency symbols when a calculated result is not a currency. | | | 41 | Dimension 5 Filter | Text[250] | — | FlowFilter | | 42 | Dimension 6 Filter | Text[250] | — | FlowFilter | | 43 | Dimension 7 Filter | Text[250] | — | FlowFilter | | 45 | Dimension 8 Filter | Text[250] | — | FlowFilter | | 46 | Internal Description | Text[500] | Specifies the internal description for the row definition line that highlights complex logic or areas needing review for the next report designer. | | | 840 | Cash Flow Forecast Filter | Code[20] | — | TableRelation [Table 840 "Cash Flow Forecast"](../table/840.md) (Cash Flow Forecast); FlowFilter | | 1100 | Cost Center Filter | Code[20] | — | TableRelation [Table 1112 "Cost Center"](../table/1112.md) (Cost Center); FlowFilter | | 1101 | Cost Object Filter | Code[20] | — | TableRelation [Table 1113 "Cost Object"](../table/1113.md) (Cost Object); FlowFilter | | 1102 | Cost Center Totaling | Text[80] | — | | | 1103 | Cost Object Totaling | Text[80] | — | | | 1104 | Cost Budget Filter | Code[10] | — | TableRelation [Table 1110 "Cost Budget Name"](../table/1110.md) (Cost Budget Name); FlowFilter | ## Keys - Key1: Schedule Name, Line No. (clustered) ## Events published - `OnAfterCheckFormula(var Formula: Code[250])` (integration): 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. - `OnAfterLookupTotaling(var AccScheduleLine: Record "Acc. Schedule Line")` (integration): 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. - subscribers: [Codeunit 6238 "Acc. Schedule Line Subscribers"](../codeunit/6238.md) OnAfterLookupTotaling - `OnAfterGetAccSchedSetup(var AnalysisView: Record "Analysis View"; AccScheduleName: Record "Acc. Schedule Name")` (integration): 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. - `OnBeforeGetCaptionClass(var AccScheduleLine: Record "Acc. Schedule Line"; AccSchedName: Record "Acc. Schedule Name"; AnalysisViewDimType: Integer; var Result: Text[250]; var IsHandled: Boolean)` (integration): Integration event raised before caption class generation to enable custom dimension caption handling. Allows extensions to provide custom caption class formatting for dimension fields. - `OnBeforeLookupTotaling(var AccScheduleLine: Record "Acc. Schedule Line"; var IsHandled: Boolean)` (integration): Integration event raised before totaling lookup to enable custom totaling selection logic. Allows extensions to provide alternative totaling lookup mechanisms or skip standard lookup. - subscribers: [Codeunit 2622 "Stat. Acc. Fin Reporting Mgt"](../codeunit/2622.md) OnBeforeLookupTotaling - `OnBeforeLookUpDimFilter(var AccScheduleLine: Record "Acc. Schedule Line"; DimNo: Integer; var Text: Text; AccSchedName: Record "Acc. Schedule Name"; var Result: Boolean; var IsHandled: Boolean)` (integration): 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. ## Trigger event subscribers - OnAfterDeleteEvent: [Codeunit 198 "Acc. Sched. KPI Event Handler"](../codeunit/198.md) OnDeleteAccSchedLine - OnAfterInsertEvent: [Codeunit 198 "Acc. Sched. KPI Event Handler"](../codeunit/198.md) OnInsertAccSchedLine - OnAfterModifyEvent: [Codeunit 198 "Acc. Sched. KPI Event Handler"](../codeunit/198.md) OnModifyAccSchedLine - OnAfterValidateEvent(Totaling): [Codeunit 6238 "Acc. Schedule Line Subscribers"](../codeunit/6238.md) OnAfterValidateTotalingEvent ## Procedures - `LookUpDimFilter(DimNo: Integer; var Text: Text): Boolean`: 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. - `CheckFormula(Formula: Code[250])`: Validates formula syntax for proper parentheses matching and operator placement in account schedule formulas. Ensures formulas are syntactically correct before use in financial calculations. - `GetCaptionClass(AnalysisViewDimType: Integer): Text[250]`: 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. - `LookupTotaling()`: 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. - `LookupGLBudgetFilter(var Text: Text): Boolean`: 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. - `LookupCostBudgetFilter(var Text: Text): Boolean`: 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. - `Indent()`: Increases indentation level for hierarchical display of account schedule line. Maximum indentation level is 10. - `Outdent()`: Decreases indentation level for hierarchical display of account schedule line. Minimum indentation level is 0. Plus 1 local procedures. ## Triggers OnInsert ## Relations - Cost Budget Filter: TableRelation [Table 1110 "Cost Budget Name"](../table/1110.md) - Cost Center Filter: TableRelation [Table 1112 "Cost Center"](../table/1112.md) - Cost Object Filter: TableRelation [Table 1113 "Cost Object"](../table/1113.md) - Totaling: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional) - Business Unit Filter: TableRelation [Table 220 "Business Unit"](../table/220.md) - Totaling: TableRelation [Table 570 "G/L Account Category"](../table/570.md) (conditional) - Schedule Name: TableRelation [Table 84 "Acc. Schedule Name"](../table/84.md) - Cash Flow Forecast Filter: TableRelation [Table 840 "Cash Flow Forecast"](../table/840.md) - Totaling: TableRelation [Table 841 "Cash Flow Account"](../table/841.md) (conditional) - G/L Budget Filter: TableRelation [Table 95 "G/L Budget Name"](../table/95.md) ## Referenced by 1 fields in 1 objects relate to this table (TableRelation or CalcFormula). - [Table 763 "Acc. Sched. Chart Setup Line"](../table/763.md): Account Schedule Line No. ## Pages and codeunits on this table - [Page 104 "Account Schedule"](../page/104.md) (source table) - [Page 490 "Acc. Schedule Overview"](../page/490.md) (source table) - [Codeunit 8 "AccSchedManagement"](../codeunit/8.md) (codeunit runs on it) - [Codeunit 9 "Acc. Sched. KPI Dimensions"](../codeunit/9.md) (codeunit runs on it) ## Extended by - [Table extension 6221 "Sust. Acc. Schedule Line"](../tableextension/6221.md) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC28-29 ## Countries that replace it [CH](../../localizations/ch.md), [ES](../../localizations/es.md), [RU](../../localizations/ru.md) Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10). ## Ask your agent Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Acc. Schedule Line")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.