Share via

Planning your chart of accounts in AX 2012 (Part 1 of 7)

  • Article

One of the most important things to think about when implementing a new ERP system is the design of the chart of accounts. The
definition of a chart of accounts can be different across applications and can mean different things to different users. An account number may or may not
include the concept of a legal entity segment, depending on whether the system supports a global/shared chart of accounts or whether a separate chart of
accounts must be created for each legal entity.

There are linear charts of accounts and there are relational charts of accounts. A linear chart of accounts requires the setup of every
supported combination of segment values prior to using them in order for an account number to be valid. These account numbers may be created manually or
through an automated function based on some defined rules. A relational chart of accounts is made up of different components, or building blocks, that allow
an account number to be ‘created’ at time of entry. Microsoft Dynamics AX 2012 has a relational chart of accounts.

A new financial dimension framework was introduced into Microsoft Dynamics AX 2012 to provide the building blocks for the chart of
accounts. This blog series is focused on describing these different building blocks and to provide some things to think about when designing the chart of
accounts. This first entry will provide the high level overview and then I’ll break it down over future posts.

The conceptual drawing of the different components that define chart of accounts in Microsoft Dynamics AX 2012 looks like this:

 

Future posts will go into more detail, but at a high level, the conceptual drawing is stating the following for Dynamics AX 2012:

  • Every legal entity (aka AX company) will have one ledger which will determine which chart of accounts and account structures
    will be used by the legal entity. The ledger will also determine the fiscal calendar and currency setup information for the legal entity.
  • A ledger has only one chart of accounts but a specific chart of accounts can be used by multiple ledgers (legal entities).
  • A chart of accounts is a list of main accounts. Some setup for a main account may be overridden for a specific company.
  • Account structures determine what segments are available for an account number as well as the rules for determining the valid
    combinations of main accounts and financial dimension values. A specific ledger can be associated with one or more account structures as of AX 2012 R2. AX 2012
    RTM associated the account structures to the chart of accounts.
  • If two or more segments of an account structure are organization units, such as Business Unit or Department, an organization
    hierarchy can be used to determine the valid combinations and the constraints would not need to be defined directly in the account structure.
  • Additional rules, or advanced rules, can be defined for a specific account structure. You can think of an advanced rule as
    adding additional financial dimensions to an account structure.

The next post for this blog series will focus on the Chart of accounts and its related setup.

Regards,

Kim

Comments

  • Anonymous
    June 12, 2014
    Great overview. I look forward to the rest of the series. Definitely an area of significant discussion during the discovery phase of any implementation. And always something new to learn on how to setup and tweak AX.Have a great day!Michael(btw...congratulations on your promotion too!)
  • Anonymous
    June 14, 2014
    I agree with Michael. Keep these posts coming. :-)
  • Anonymous
    June 15, 2014
    Great stuff - so often missed as a major consideration
  • Anonymous
    June 25, 2014
    thanks kim, keep it coming.
  • Anonymous
    July 07, 2014
    The comment has been removed
  • Anonymous
    September 17, 2014
    Great overview.I look foreward to your post about account structures and advanced rule/structure and recommandations.  I've started to create several account structures for every ledger, deselect "leave blank" on the attached dimensions and include advanced rule/structure.The purpose is to reduce the time spend creating journals, with several dimensions not required to be filled in with a dimension value.  a leave blank
  • Anonymous
    January 07, 2015
    where is your next post. It is really very helpful so please reply and keep updating.
  • Anonymous
    January 08, 2015
    Hello Hemant -The remaining posts in the Chart of Accounts series has already been posted. Here is the link to part 2: blogs.msdn.com/.../planning-your-chart-of-accounts-in-ax-2012-part-2-of-7.aspx.Let me know if you can't find the other posts in the series. Thanks for the feedback!Kim