Decomposing the chart of accounts and analytical dimensions into main accounts, account structures and financial dimensions
How Sage X3's chart of accounts, analytical dimensions, dimension types, allocation keys and fiscal calendars are translated into D365 main accounts, financial dimensions, account structures, advanced rules and ledger allocation rules — including the design method for decomposition and the practical constraints on both platforms.
What you will be able to do
Decompose the X3 chart of accounts and account core model into a D365 shared chart of accounts with main account categories and types
Translate up to 9 analytical axes and up to 20 dimension types into a D365 financial dimension set governed by account structures and advanced rules
Build account structures and advanced rules that reproduce the validation intent of X3 dimension-type constraints
Re-express X3 allocation keys as D365 ledger allocation rules or dimension defaulting
Design a fiscal calendar that matches the X3 fiscal period structure, and configure period control per legal entity
Introduction
Sage X3 organises its chart of accounts and analytical accounting as a layered model: a plan comptable (chart of accounts) defines the natural accounts, analytical dimensions provide up to nine management-accounting axes per ledger drawn from a broader pool of up to twenty dimension types, and allocation keys distribute costs across…
The X3 chart of accounts and account core model
Sage X3's chart of accounts (plan comptable) is a flat or hierarchically grouped list of general ledger accounts used for statutory and management reporting. Each account carries a type (balance sheet, profit and loss, off-balance-sheet), a currency restriction, a description, and membership in one or more account categories used for…
Analytical dimensions, dimension types and analytical axes
Dimension Types — up to 20 definable per accounting model. A dimension type classifies what an analytical axis represents (cost centre, profit centre, project, region, product line, and so on) and defines the source table for valid values, validation rules, and behaviour attributes.
Account structures and advanced rules
An account structure in D365 defines which financial dimension combinations are valid for a given range of main accounts. When a user or process posts a journal line, the system validates the combination against the active account structure. If the combination is not permitted, the posting is rejected.
Allocation keys and distribution logic
Sage X3 allocation keys distribute amounts across analytical dimensions using percentage-based, statistical-unit-based or formula-based rules. They are configured as named objects and invoked either:
Fiscal calendars and period control
Sage X3 defines fiscal periods per ledger: a fiscal year with a configurable number of periods (typically 12 monthly, but 4-4-5, 13-period and special-period configurations are supported). Each period carries an open or closed status that controls whether posting is permitted.
The dimension rationalisation method
The decomposition from X3 analytical dimensions to D365 financial dimensions is not a mechanical exercise — it requires a structured design workshop. The recommended method:
Knowledge check
Summary
The chart of accounts and analytical dimension model is the financial skeleton of the D365 system. It must be designed from intent — what each X3 dimension, category and allocation key achieves for the business — not translated mechanically from the X3 configuration export.