Page 408 "G/L Balance by Dimension"

Base Application · Microsoft.Finance.Analysis · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	G/L Balance by Dimension
SourceTable	Analysis by Dim. Parameters
PageType	Card

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	Show as Lines	`LineDimCode`	Specifies which values you want to show as lines in the window. This allows you to see the same matrix window from various perspectives, especially when you use both the Show as Lines field and the Show as Columns field.
	Show as Columns	`ColumnDimCode`	Specifies which values you want to show as columns in the window. This allows you to see the same matrix window from various perspectives, especially when you use both the Show as Lines field and the Show as Columns field.
Filters	Date Filter	Date Filter	Specifies the dates that will be used to filter the amounts in the window. from the table field
	G/L Account Filter	Account Filter	Specifies the G/L accounts for which you will see information in the window.
	Budget Filter	Budget Filter	Specifies the budget that information in the matrix is shown for. from the table field
	BusUnitFilter	Bus. Unit Filter	—
	Dim1Filter	Dimension 1 Filter	Specifies a filter for the Dimension 1 for which entries will be shown in the matrix window. from the table field
	Dim2Filter	Dimension 2 Filter	Specifies a filter for the Dimension 2 for which entries will be shown in the matrix window. from the table field
Options	ShowActualBudg	Show Actual/Budgets	Specifies if the selected value is shown in the window. from the table field
	AmountField	Show Amount Field	Specifies the type of entries that will be included in the matrix window. The Amount options means that amounts that are the sum of debit and credit amounts are shown. from the table field
	Closing Entries	Closing Entries	Specifies whether the balance shown will include closing entries. If you want to see the amounts on income statement accounts in closed years, you must exclude closing entries. from the table field
	Rounding Factor	Rounding Factor	Specifies the factor that is used to round the amounts. from the table field
	Show Amounts in Add. Reporting Currency	Show In Add. Currency	Specifies whether to show the reported amounts in the additional reporting currency. from the table field
	Show Column Name	Show Column Name	Specifies that the names of columns are shown in the matrix window. from the table field
Matrix Options	PeriodType	Period Type	Specifies by which period amounts are displayed. from the table field
	View as	Amount Type	Specifies how amounts are displayed. Net Change: The net change in the balance for the selected period. Balance at Date: The balance as of the last day in the selected period. from the table field
	MATRIX_ColumnSet	Column Set	Specifies the range of values that are displayed in the matrix window, for example, the total period. To change the contents of the field, choose Next Set or Previous Set. from the table field

Actions

Group	Action	ToolTip
Actions	Reverse Lines and Columns	Change the display of the matrix by inverting the values in the Show as Lines and Show as Columns fields.
Processing	Show Matrix	View the data overview according to the selected filters and options.
	Previous Set	Go to the previous set of data.
	Next Set	Go to the next set of data.

Events published

OnAfterOnInit() (integration): Integration event raised after page initialization for custom setup logic. Enables additional initialization steps for G/L Balance by Dimension analysis.
OnAfterDimCodeToOption(DimCode: Text[30]; GeneralLedgerSetup: Record "General Ledger Setup"; var Result: Integer) (integration): Integration event raised after dimension code to option conversion for custom dimension handling. Enables extension of dimension code conversion logic beyond standard dimensions.
OnAfterIsNotValidDefinition(GeneralLedgerSetup: Record "General Ledger Setup"; var DimCode: Text[30]; var Result: Boolean) (integration): Integration event raised after dimension definition validation for custom validation logic. Enables custom validation of dimension definitions beyond standard checks.
OnBeforeGLAccFilter(var GLAccount: Record "G/L Account"; var GLAccFilter: Text; LineDimOption: Option "G/L Account",Period,"Business Unit","Dimension 1","Dimension 2","Dimension 3","Dimension 4"; ColumnDimOption: Option "G/L Account",Period,"Business Unit","Dimension 1","Dimension 2","Dimension 3","Dimension 4") (integration): Integration event raised before G/L Account filtering for custom filter logic. Enables modification of G/L Account filters based on dimension options.
OnBeforeFindRec(DimOption: Option; var DimensionValue: Record "Dimension Value"; var GLAccount: Record "G/L Account") + BC24 − BC24 (integration): Integration event raised before finding records for custom record finding logic. Enables custom record navigation behavior in dimensional analysis.
OnBeforeNextRec(DimOption: Option; var DimensionValue: Record "Dimension Value"; var GLAccount: Record "G/L Account") + BC24 − BC24 (integration): Integration event raised before record navigation for custom navigation logic. Enables custom record stepping behavior in dimensional analysis.
OnFindRecCaseElse(AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; DimOption: Integer; GeneralLedgerSetup: Record "General Ledger Setup"; var Found: Boolean; var DimensionCodeBuffer: Record "Dimension Code Buffer"; Which: Text[250]) (integration): Integration event raised for custom dimension handling in find record operations. Enables extension of record finding logic beyond standard dimensions.
OnGetDimSelectionOnBeforeDimSelectionLookup(GeneralLedgerSetup: Record "General Ledger Setup"; var DimensionSelection: Page "Dimension Selection") (integration): Integration event raised before dimension selection lookup for custom selection behavior. Enables modification of dimension selection page before display.
OnNextRecCaseElse(AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; DimOption: Integer; GeneralLedgerSetup: Record "General Ledger Setup"; var ResultSteps: Integer; var DimensionCodeBuffer: Record "Dimension Code Buffer"; Steps: Integer) (integration): Integration event raised for custom dimension handling in next record operations. Enables extension of record navigation logic beyond standard dimensions.
OnShowMatrixActionOnBeforeRunModal(var GLBalancebyDimMatrix: Page "G/L Balance by Dim. Matrix") (integration): Integration event raised before running the G/L Balance by Dimension Matrix page. Enables customization of matrix page before display.
OnOnOpenPageOnBeforeFindPeriod(GeneralLedgerSetup: Record "General Ledger Setup"; var GLAccount: Record "G/L Account") (integration): Integration event raised on page open before finding period for custom initialization logic. Enables custom setup behavior during page opening.

Procedures

GenerateColumnCaptions(StepType: Enum "Matrix Page Step Type") (protected)

Plus 22 local procedures.

Triggers

OnInit, OnOpenPage, OnQueryClosePage

Relations

source table Table 361 “Analysis by Dim. Parameters”

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 362 “PeriodPageManagement” (3 calls: FindPeriod → FindDate, FindRec → FindDate, NextRec → NextDate)
Codeunit 41 “Filter Tokens” (1 call: SetDateFilter → MakeDateFilter)

Documented on Microsoft Learn

Work with dimensions to track and analyze data

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: "G/L Balance by Dimension"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.