Page 489 "Column Layout"
Base Application · Microsoft.Finance.FinancialReports
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC261 procedures added
- BC272 procedures removed, 1 procedures added
- BC28unchanged
- BC291 procedures added
- BC30unchanged
Neighbourhood 10 connected objects and pages
Base Application · Microsoft.Finance.FinancialReports · captioned “(Financial Report) Column Definitions” · BC23-30 · source at ea08af5e · 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. | Specifies the line number for the financial report column. from the table field |
| Column No. | Column No. | Specifies a number for the column in the analysis view. from the table field | |
| Column Header | Column Header | Specifies a header for the column. from the table field | |
| IncludeDateInHeader | Include Date In Header | Specifies how the ending date of the Date Filter applied to the column is displayed on the Column Header. from the table field | |
| Column Type | Column Type | Specifies the analysis column type, which determines how the amounts in the column are calculated. from the table field | |
| Ledger Entry Type | Ledger Entry Type | Specifies the type of ledger entries that will be included in the amounts in the financial report column. from the table field | |
| Amount Type | Amount Type | Specifies the type of entries that will be included in the amounts in the financial report column. from the table field | |
| Budget Name | Budget Name | Specifies which budget amounts will be totaled in this column. from the table field | |
| Formula | Formula | Specifies a formula. The result of the formula will appear in the column when the financial report is printed. from the table field | |
| Show Opposite Sign | Show Opposite Sign | Specifies whether to show debits in reports as negative amounts (that is, with a minus sign) and credits as positive amounts. from the table field | |
| Comparison Date Formula | Comparison Date Formula | Specifies a date formula that specifies which dates should be used to calculate the amount in this column. from the table field | |
| Comparison Period Formula | Comparison Period Formula | Specifies a period formula that specifies the accounting periods you want to use to calculate the amount in this column. from the table field | |
| Show number | Show | Specifies when you want the amounts in the column to be shown in reports. from the table field | |
| Show Indented Lines | Show Indented Lines | Specifies that indented lines are shown. from the table field | |
| Rounding Factor | Rounding Factor | Specifies a rounding factor for amounts in the column. from the table field | |
| Business Unit Totaling | Business Unit Totaling | Specifies which business unit amounts will be totaled in this column. from the table field | |
| Dimension 1 Totaling | Dimension 1 Totaling | 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. from the table field | |
| Dimension 2 Totaling | Dimension 2 Totaling | 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. from the table field | |
| Dimension 3 Totaling | Dimension 3 Totaling | 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. from the table field | |
| Dimension 4 Totaling | Dimension 4 Totaling | 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. from the table field | |
| Cost Center Totaling | Cost Center Totaling | Specifies which cost center amounts will be totaled in this column. from the table field | |
| Cost Object Totaling | Cost Object Totaling | Specifies which cost object amounts will be totaled in this column. from the table field | |
| GLAccountTotaling | G/L Account Totaling | 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. from the table field | |
| HideCurrencySymbol | Hide Currency Symbol | Specifies whether to hide currency symbols when a calculated result is not a currency. from the table field | |
| Show in ACY | Show in ACY | Specifies whether amounts are shown in the Additional Reporting Currency. from the table field | |
| Internal Description | Internal Description | Specifies the internal description for the column definition line that highlights complex logic or areas needing review for the next report designer. from the table field | |
| FactBoxes | G/L Accounts | part Page 8396 “Totaling Accounts Factbox” | — |
Actions
| Group | Action | ToolTip | Runs |
|---|---|---|---|
| Processing | Copy Column Layout obsolete Pending 28.0; #if not CLEAN28 | 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”
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.” (2 calls:
GetDescriptions → CheckStatus,OnOpenPage → LaunchEditColumnsWarningNotification) - Codeunit 8 “AccSchedManagement” (2 calls:
OnOpenPage → GetColumnLayoutCaption,OnOpenPage → OpenColumns)
Recent changes
- 2026-10-05 #12213 [Financial Reports] Add row and column definition preview (main, BC30, feature)
Documented on Microsoft Learn
- Column definitions in Financial Reporting
- Set Up and Publish KPI Web Services Based on Financial Reports
- Build financial reports using financial data and account categories
- Row definitions in Financial Reporting
- Troubleshoot Financial Reporting
- Financial Reporting FAQ
- Make cash flow forecasts using financial reports
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.
Evidence 8 sources
- codesrc/Layers/W1/BaseApp/Finance/FinancialReports/ColumnLayout.Page.alreleases/29.x @ ea08af5e
- learnColumn definitions in Financial Reporting
- learnSet Up and Publish KPI Web Services Based on Financial Reports
- learnBuild financial reports using financial data and account categories
- learnRow definitions in Financial Reporting
- learnTroubleshoot Financial Reporting
- learnFinancial Reporting FAQ
- learnMake cash flow forecasts using financial reports