Financial Dimensions in D365 Finance: Setup and Reporting

Financial dimensions are how Dynamics 365 Finance lets a single chart of accounts produce reporting at the level of department, cost centre, project, or any other classification the business cares about. They are segments stored alongside the main account on every general ledger transaction.

From version 10.0.32, Microsoft also introduced financial tags as an alternative to dimensions for non-reusable values like document numbers or invoice references.

What are the financial dimensions in Dynamics 365 Finance, and how are they used?

Department, CostCenter, Business Unit, and Project are the classic examples of financial dimensions. When a vendor invoice posts to an expense account, the main account and any dimensions configured for that account structure are recorded together as a single ledger account string.

D365 Finance ships with two types of dimensions. Custom dimensions are user-defined values shared across all legal entities, maintained directly on the Financial dimension values page. Entity-backed dimensions take their values from another system table, such as Customers or Projects, and those values can only be edited at the source.

A custom dimension can be constrained with an account mask. Setting CC-### as the mask forces every cost centre value to be three digits prefixed with "CC-". This is useful for organisations standardising naming after the fact.

A dimension can also be made legal-entity-specific. The Legal entity overrides section on the Financial dimension values page suspends a dimension value for a specific company or date range. A particular department value can exist for some legal entities and be suspended for others: the same shared dimension, different entitlement per entity.

Creating financial dimensions, dimension values, and dimension sets

Defining a dimension happens on the Financial dimensions page (General ledger > Chart of accounts > Dimensions > Financial dimensions). Allowable values are entered on the Financial dimension values page for custom dimensions, or surfaced from the source for entity-backed ones. Once dimensions exist, the Financial dimension sets page groups them into ordered combinations used to summarise General ledger data, typically to drive the trial balance.

After creating a dimension and entering values, you activate it. Activation requires the system to be in maintenance mode and updates the dimension table with the new name. A dimension can't be added to an account structure until it is activated.

Dimension sets need balances calculated to be useful in reports. From version 10.0.38, the Performance enhancement for the general ledger dimension set balance calculation feature replaces the older balance data model with a background process that updates every five minutes by default. Earlier versions required Update balances or Rebuild balances to be run manually before generating the trial balance, and rebuilds were a frequent source of slow-trial-balance tickets.

Each balance update cycle processes every active dimension set, so unused sets waste resources. If you want to retire a set but keep the option to bring it back, clear its balances rather than deleting it.

Account structures and advanced rules: controlling which dimensions are required

An account structure determines which dimensions are valid in combination with which main accounts. Every legal entity needs at least one structure assigned to its ledger. A structure can hold the main account plus up to ten financial dimensions. Advanced rules extend that to a maximum of sixteen segments.

A typical setup uses two structures per ledger. One covers balance sheet accounts and requires only the Business Unit. The other covers P&L accounts and requires Business Unit, Department, and Cost Centre, with Customer applied through an advanced rule that triggers only on sales accounts. The split keeps data entry clean and the chart of accounts manageable.

Each row in the structure is a path from the main account to a particular dimension combination. Allowed values for a segment can be a single value, a range, a wildcard (*), or blank, with up to seven criteria per segment before you need a duplicated row. Account structures are stored internally as a tree, and the flat grid in the UI is its flattened view, which explains some of the less obvious behaviour around blank segments.

Budgeting only reads dimensions defined directly in the account structure, not those added by advanced rules, so any dimension you plan to use in budgets must sit in the structure itself.

How financial dimensions flow into financial reports

The display order of dimensions on reports is set on the Financial reporting setup page (General ledger > Ledger setup > Financial reporting setup). Different companies in the same group can use different account structures, so the report-level order is a separate decision from the data-entry order.

In Financial reporting, dimensions appear in row definitions and column definitions. The Insert row from dimensions option pulls every value of a dimension into rows automatically, and dimension filters in Report Options let viewers personalise a report without modifying the underlying definition.

Dimensions only appear on reports if you have selected them on the Dimensions tab of Financial reporting setup, and the Data Mart needs a reset after changes for them to show. Balance updates run on a five-minute cadence with the performance feature enabled, which is fine for management reporting but not zero-latency.

Training a finance team on dimensions only works if the materials use the team's own dimension list and posting scenarios, not generic Microsoft demo examples.

If you are scoping training for a Dynamics 365 Finance go-live, the employee training plan template gives you a structure for training on dimensions, and the rest of the finance configuration users will touch.

Sources

• Microsoft Learn: Financial dimensions and tags

• Microsoft Learn: Financial dimension sets

• Microsoft Learn: Account structures overview

• Microsoft Learn: Financial dimensions and posting

• Microsoft Learn: Financial dimension configuration

• Gaurangkumar Jani, Dynamics 365 Community: Heart of Dynamics 365 Finance: Financial Dimensions