---
id: object/page/489
type: object
title: Page 489 "Column Layout"
summary: Page 489 "Column Layout" in Base Application (Microsoft.Finance.FinancialReports). 1 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC26-27, BC29.
tier: official
language: en
tags:
  - page
  - 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: c7418092d91c8c2d289e92a9b78c1fb9f982929ad16d56fdc39f6cb8a1df23e8
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/ColumnLayout.Page.al
    title: src/Layers/W1/BaseApp/Finance/FinancialReports/ColumnLayout.Page.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/bi-column-definitions
    title: Column definitions in Financial Reporting
    date: null
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/bi-how-to-set-up-and-publish-kpi-web-services-based-on-account-schedules
    title: Set Up and Publish KPI Web Services Based on Financial Reports
    date: null
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/bi-how-work-account-schedule
    title: Build financial reports using financial data and account categories
    date: null
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/bi-row-definitions
    title: Row definitions in Financial Reporting
    date: null
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/bi-troubleshoot-financial-reports
    title: Troubleshoot Financial Reporting
    date: null
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-faq
    title: Financial Reporting FAQ
    date: null
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/walkthrough-making-cash-flow-forecasts-by-using-account-schedules
    title: Make cash flow forecasts using financial reports
    date: null
    commit: null
    t: null
    quote: null
links:
  learn:
    - 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/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/finance-financial-reporting-faq
    - 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/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/get-started/learn/business-process-walkthroughs
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/12213
object_type: page
object_id: 489
name: Column Layout
caption: (Financial Report) Column Definitions
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"
  - "26"
  - "27"
  - "29"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids:
  - docs/learn-smb-docs/business-central/bi-column-definitions.md
  - docs/learn-smb-docs/business-central/bi-how-to-set-up-and-publish-kpi-web-services-based-on-account-schedules.md
  - docs/learn-smb-docs/business-central/bi-how-work-account-schedule.md
  - docs/learn-smb-docs/business-central/bi-row-definitions.md
  - docs/learn-smb-docs/business-central/bi-troubleshoot-financial-reports.md
  - docs/learn-smb-docs/business-central/finance-financial-reporting-faq.md
  - docs/learn-smb-docs/business-central/walkthrough-making-cash-flow-forecasts-by-using-account-schedules.md
counts:
  fields: 0
  procedures: 3
  events: 0
  subscribers: 0
  controls: 31
  actions: 4
relations:
  out: 1
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
  calls: 2
  called_by: 0
  implements: 0
---

# Page 489 "Column Layout"

> Page 489 "Column Layout" in Base Application (Microsoft.Finance.FinancialReports). 1 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC26-27, BC29.

Base Application · Microsoft.Finance.FinancialReports · captioned "(Financial Report) Column Definitions" · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/ColumnLayout.Page.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | (Financial Report) Column Definitions |
| SourceTable | Column Layout |
| PageType | Worksheet |
| UsageCategory | None |
| ApplicationArea | Basic, Suite |

## Fields on this page

Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control's own, else the bound field's (marked).

| Group | Control | Shows | ToolTip |
|---|---|---|---|
| General | Name | `CurrentColumnName` | Specifies the unique name (code) of the column definition. |
|  | Description | `CurrentDescription` | Specifies the description of the column definition. The description is not shown on the final report but is used to provide more context when using the definition. |
|  | Status | `DefinitionStatus` | Specifies the status code for the column definition. The status code helps you organize the lifecycle of your column definitions. |
|  | Internal Description | `InternalDescription` | Specifies the internal description of the column definition. The internal description is not shown on the final report but is used to provide more context when using the definition. |
| Control1 | Line No. | [Line No.](../table/334.md#fields) | Specifies the line number for the financial report column. <small>from the table field</small> |
|  | Column No. | [Column No.](../table/334.md#fields) | Specifies a number for the column in the analysis view. <small>from the table field</small> |
|  | Column Header | [Column Header](../table/334.md#fields) | Specifies a header for the column. <small>from the table field</small> |
|  | IncludeDateInHeader | [Include Date In Header](../table/334.md#fields) | Specifies how the ending date of the Date Filter applied to the column is displayed on the Column Header. <small>from the table field</small> |
|  | Column Type | [Column Type](../table/334.md#fields) | Specifies the analysis column type, which determines how the amounts in the column are calculated. <small>from the table field</small> |
|  | Ledger Entry Type | [Ledger Entry Type](../table/334.md#fields) | Specifies the type of ledger entries that will be included in the amounts in the financial report column. <small>from the table field</small> |
|  | Amount Type | [Amount Type](../table/334.md#fields) | Specifies the type of entries that will be included in the amounts in the financial report column. <small>from the table field</small> |
|  | Budget Name | [Budget Name](../table/334.md#fields) | Specifies which budget amounts will be totaled in this column. <small>from the table field</small> |
|  | Formula | [Formula](../table/334.md#fields) | Specifies a formula. The result of the formula will appear in the column when the financial report is printed. <small>from the table field</small> |
|  | Show Opposite Sign | [Show Opposite Sign](../table/334.md#fields) | Specifies whether to show debits in reports as negative amounts (that is, with a minus sign) and credits as positive amounts. <small>from the table field</small> |
|  | Comparison Date Formula | [Comparison Date Formula](../table/334.md#fields) | Specifies a date formula that specifies which dates should be used to calculate the amount in this column. <small>from the table field</small> |
|  | Comparison Period Formula | [Comparison Period Formula](../table/334.md#fields) | Specifies a period formula that specifies the accounting periods you want to use to calculate the amount in this column. <small>from the table field</small> |
|  | Show number | [Show](../table/334.md#fields) | Specifies when you want the amounts in the column to be shown in reports. <small>from the table field</small> |
|  | Show Indented Lines | [Show Indented Lines](../table/334.md#fields) | Specifies that indented lines are shown. <small>from the table field</small> |
|  | Rounding Factor | [Rounding Factor](../table/334.md#fields) | Specifies a rounding factor for amounts in the column. <small>from the table field</small> |
|  | Business Unit Totaling | [Business Unit Totaling](../table/334.md#fields) | Specifies which business unit amounts will be totaled in this column. <small>from the table field</small> |
|  | Dimension 1 Totaling | [Dimension 1 Totaling](../table/334.md#fields) | Specifies which dimension value amounts will be totaled in this column. If the column type of the column is Formula, you must not enter anything in this field. Also, if you do not wish the amounts on the line to be filtered by dimension, you should leave this field blank. <small>from the table field</small> |
|  | Dimension 2 Totaling | [Dimension 2 Totaling](../table/334.md#fields) | Specifies which dimension value amounts will be totaled in this column. If the column type of the column is Formula, you must not enter anything in this field. Also, if you do not wish the amounts on the line to be filtered by dimension, you should leave this field blank. <small>from the table field</small> |
|  | Dimension 3 Totaling | [Dimension 3 Totaling](../table/334.md#fields) | Specifies which dimension value amounts will be totaled in this column. If the column type is Formula, you must not enter anything in this field. Also, if you do not wish the amounts on the line to be filtered by dimension, you should leave this field blank. <small>from the table field</small> |
|  | Dimension 4 Totaling | [Dimension 4 Totaling](../table/334.md#fields) | Specifies which dimension value amounts will be totaled in this column. If the column type is Formula, you must not enter anything in this field. Also, if you do not wish the amounts on the line to be filtered by dimension, you should leave this field blank. <small>from the table field</small> |
|  | Cost Center Totaling | [Cost Center Totaling](../table/334.md#fields) | Specifies which cost center amounts will be totaled in this column. <small>from the table field</small> |
|  | Cost Object Totaling | [Cost Object Totaling](../table/334.md#fields) | Specifies which cost object amounts will be totaled in this column. <small>from the table field</small> |
|  | GLAccountTotaling | [G/L Account Totaling](../table/334.md#fields) | Specifies which G/L accounts will be totalled in this column. Note that this filter will be applied in addition to any G/L account filters from the row definition lines. <small>from the table field</small> |
|  | HideCurrencySymbol | [Hide Currency Symbol](../table/334.md#fields) | Specifies whether to hide currency symbols when a calculated result is not a currency. <small>from the table field</small> |
|  | Show in ACY | [Show in ACY](../table/334.md#fields) | Specifies whether amounts are shown in the Additional Reporting Currency. <small>from the table field</small> |
|  | Internal Description | [Internal Description](../table/334.md#fields) | Specifies the internal description for the column definition line that highlights complex logic or areas needing review for the next report designer. <small>from the table field</small> |
| FactBoxes | G/L Accounts | part [Page 8396 "Totaling Accounts Factbox"](../page/8396.md) | — |

## Actions

| Group | Action | ToolTip | Runs |
|---|---|---|---|
| Processing | Copy Column Layout <small>obsolete Pending 28.0; #if not CLEAN28</small> | Create a copy of the current column layout. |  |
|  | Where-Used | View or edit financial reports in which the column definition is used. |  |
|  | Hide Header | Hide the page header. |  |
|  | Show Header | Show the page header. |  |

## Procedures

- `SetColumnLayoutName(NewColumnName: Code[10])`: Sets the current column layout name for the page to display the associated column definitions.

Plus 2 local procedures.

## Triggers

OnAfterGetRecord, OnAfterGetCurrRecord, OnOpenPage

## Relations

- source table [Table 334 "Column Layout"](../table/334.md)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 18 "Financial Report Mgt."](../codeunit/18.md) (2 calls: `GetDescriptions → CheckStatus`, `OnOpenPage → LaunchEditColumnsWarningNotification`)
- [Codeunit 8 "AccSchedManagement"](../codeunit/8.md) (2 calls: `OnOpenPage → GetColumnLayoutCaption`, `OnOpenPage → OpenColumns`)

## Recent changes

- 2026-10-05 [#12213 [Financial Reports] Add row and column definition preview](../../changes/bcapps/12213.md) (main, BC30, feature)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26-27, BC29

## Documented on Microsoft Learn

- [Column definitions in Financial Reporting](https://learn.microsoft.com/dynamics365/business-central/bi-column-definitions)
- [Set Up and Publish KPI Web Services Based on Financial Reports](https://learn.microsoft.com/dynamics365/business-central/bi-how-to-set-up-and-publish-kpi-web-services-based-on-account-schedules)
- [Build financial reports using financial data and account categories](https://learn.microsoft.com/dynamics365/business-central/bi-how-work-account-schedule)
- [Row definitions in Financial Reporting](https://learn.microsoft.com/dynamics365/business-central/bi-row-definitions)
- [Troubleshoot Financial Reporting](https://learn.microsoft.com/dynamics365/business-central/bi-troubleshoot-financial-reports)
- [Financial Reporting FAQ](https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-faq)
- [Make cash flow forecasts using financial reports](https://learn.microsoft.com/dynamics365/business-central/walkthrough-making-cash-flow-forecasts-by-using-account-schedules)

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). The call sections above are our own, per object, from the BC29 call graph. 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: "page", object_name: "Column Layout")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.