Skip to content

Financial Structure Series Part 3 – Account Structures

As we proceed with understanding the financial structure in Dynamics AX, as we have already covered both; chart of accounts and financial dimensions, this post will shed a light on the account structure concept in Dynamics AX.

The account structure is basically the valid combination of main accounts and associated financial dimensions. What distinguishes Dynamics AX from other legacy ERP systems is that the chart of accounts are determined based on the “Account Structure”, which represents the predefined rules of valid combinations.

Lets take an example on the below main accounts and associated financial dimensions in order to elaborate further on the chart of accounts concept in Dynamics AX

 

FD

As commonly known, the main accounts which starts with 6XXXX are expense accounts, lets assume that we have three financial dimensions which are:

  • Business Line
  • Department
  • Project
  • Service Line

The account structure simply states that any account which starts with 6XXXX should have the above financial dimensions required.

In order to define this structure, go to General Ledger > Setup > Chart of Accounts > Configure Account Structure

When creating a new account structure, you will be asked to specify the “Main Account” range initially:

Main Account

Account Structure.png

The idea is to add as many financial dimensions as required, click on “Add Segment”, and you will be able to add as many segments.

Add Segm.png

 

For each of the segment added to the account structure, you can basically filter or limit the values to be entered under that dimensions. Most importantly, there is an option with each segment which allows you either to “Allow Nulls” or “Not Allow nulls” for each of the financial dimensions.

The allow nulls is illustrated below:

Segm.png

 

Activate Account Structure

When the account structure is finalized, you need to validate and then activate it in order to be able to choose it on the ledger form as illustrated in previous posts of the financial structure series.

Menu Bar

Ledger Form

The final step is to link the account structure or multiple account structures with the ledger form on the legal entity level in order to be applied. Go to General Ledger > Setup > Ledger

Ledger.png

The end result is that, during account entry, when a specific “main account” is chosen, the system will predict the required financial dimensions on real time bases, in order for the end user to enter.

Financial Segments

As illustrated in the screen shot above, when the end users entered an account which starts with 6XXX, the system directly retrieved the required financial dimensions from the account structure which is specified on the ledger form

 

Best Regards,
Mahmoud M. AlSaadi

Mahmoud M. AlSaadi - MVP originally posted this article on 27 August 2018 at 3:55 PM.

Leave a Reply