CoA Level of Accounts

(0) Share

Report

Posted on by Community Member

Hi All,

We would like to import a chart of Accounts in AX 2012 R2 and we want to define the levels of accounts in order to specify that some of the accounts are a sublevel of the other.
For example the accounts 30.00.00.0000 and 30.01.00.0000 are both of level 4 and they should be under the account 30.00.00 that is of level 3.
Where can we define the levels of each account and the account of the upper level that each account belongs

BR,

Michalis

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Michalis,

The standard application knows this kind of setup only for some specific countries, such as China as the definition of main and sublevels is bound to a country-specific config key.

If you have a MS Contoso demo machine available you can check how this looks like yourself. Here is an example from my demo machine

If you are operating in a different country environment you have two options in my opinion:

(a) ask a developer for some help to make this country-specific feature generally available in your system or

(b) work with total accounts that summarize the assigned sub-accounts

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

What is shown for China is what exactly we need. The question is if it is possible through std functionality to define the parent account of an account. e.g. the parent of 30.00 account (level2) is 30 account (level 1).

Thanks,

Michalis

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Michalis,

There is not too much code behind this functionality and I would suggest that you take a look at this functionality togehter with a developer to assess whether he/she can make this country-specific feature generally available for you.

Please try to test it throughly in a demo environment first to see if all your requirements are covered.

Would be great if you could Keep us updated here how things are going and if some additional help is required.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

it seems that Chinese structure is very appropriate to my case. As in my country it's not an official localisation (we are located in European Union) could you identify any potential issues that may arise if we do built our localisation on Chinese?

BR,

Michalis

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Michalis,

I cannot see potential issue by making this COA feature available for your country environment. Yet, please double check with a colleague from the development department to have a close look 'behind the scenes' (that is into the code) to ensure that this is correct.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

Create the structure in Excel and load it - make the different level accounts e.g. 30.00.00 should be set up as total accounts consisting of the level below- much like a multi level BOM. total accounts. level 0 Total count will then contain all the level 1 total accounts etc. This way you can see an on line summarised trial balance of the total accounts by level.

Was this reply helpful? Yes No
Kenneth Eduardo 20 on at

Like (0)

Report

Hi Ludwig, I´m having some troubles with total accounts and management report, I need to show "account levels" in a similar way that is explained in this post, for example, account 10000 is a total account of level 1, 11000 is a total account of level 2... and so on until the last level (8 levels!) that is the account with transactions, the other accounts of totals only show in "cascade" mode the summarize of the accounts of the inmediately down level... the problem is that in management report only show the account with transactions and the inmediately up account, and not show the next 6 levels... do you have any idea? I´m afraid that dynamics only allow 2 levels of total accounts... please help me!

ACCOUNT NAME TYPE

100000000000 Asset TOTAL

110000000000 Disponibilities TOTAL

110100000000 Cash TOTAL

110110000000 Cash National currency TOTAL

110110100000 Cash National currency, national banks TOTAL

110110101010 Bank XX asset

In that example, the account 100000000000 show the sum of the accounts 110..., 120... 130..., 140... , the account 110000000000 show the sum of the accounts 1110..., 1120, 1130, 1140... and so until the last account

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Kenneth,

Can't the summary of the accounts you are looking for be achieved by making use of total lines that you include in the row definition?

As an example, you have a list of accounts that are summarized into a total line.

Let's call this total line A.

Then you have a number of other accounts that are summarized in total line B.

Total line A and total line B are then included in another calculated row C.

This does not exactly give you the grouping functionality you might be used to from Excel but wouldn't that be an acceptable reporting format?

Best regards,

Ludwig

Was this reply helpful? Yes No
Kenneth Eduardo 20 on at

Like (0)

Report

I´m using "totaling accounts" in the row definition:

The accounts in the field "formula" also are total accounts. I made the next example, it is like a "matrix/pyramidal" shape, and I need to show the amount of each account of the trial balance (including total accounts) in a single row of the report (Management report):

...Is there a restriction for the number of "total account levels" that can be setup in Dynamics? Why the report dont show amounts in the rest of the account levels?

Thank you!

Was this reply helpful? Yes No