Multiple Chart of Accounts (COA) for one company in AX R3

(1) Share

Report

Posted on by Community Member Microsoft Employee

Business user here. My company is in the process of implementing a global chart of accounts. We currently have one company in Belgium that has a chart of account that is consistent with local statutory requirements (the number sequencing). For global consistency and consolidating, we would like to get this company on a global chart of accounts. Is it possible to have one company with two chart of accounts? For example, is there a way to view the trial balance by more than one chart of account- the local COA for regulatory requirements in Belgium, but the global COA for global reporting? Ideally, it would be nice to do some behind the scene mapping to the global chart of account, and click a button to see the TB in either COA.

My experience is mainly in SAP and I know the chart of account flexibility is used often by companies- specifically for global and local chart of accounts. Is this possible? What are other users doing for their global chart of accounts- would like to hear best practices by other companies and would love to receive suggestions by business users and developers.

Thanks in advance for any help!

Steven

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Multiple Chart of Accounts (COA) for one company in AX R3

Hi Andre, how default consolidation account and additional consolidation account works for reporting in management reporter. I have similar requirement and I need to do consolidation in management reporter for companies in different currencies.

I am using shared COA in all companies and I need to use

historical rates - for share capital and reserves

Closing rates - for other balance sheet items

average rate - for p&l items

I am facing issue in defining historical rates for opening balance transactions migrated from legacy system on particular date. as I can define only single rate on a date where as historical rates are different in different companies and I can define only single exchange rate type for one GL account across company. When ever I am making it company specific management reporter becomes inactive.
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: Multiple Chart of Accounts (COA) for one company in AX R3

Hi Steven,

Above I mentioned some standard options. If you want to export or create a kind of data mart yourself, you can link what ever you need.

Standard reports in AX does not provide an option to report on the consolidation accounts. Management reporter can deal with this.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Multiple Chart of Accounts (COA) for one company in AX R3

Hi Andre,

With these potential solutions, will it allow a user to export a trial balance in either of the chart of accounts for a given company (local chart of account and global chart of account)? I'm just curious as to how a user would be able to see the TB in either chart of accounts- is this viewed in the trial balance section of the general ledger module?

Regards,

Steven
Verified answer

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (3)

Report

RE: Multiple Chart of Accounts (COA) for one company in AX R3

Hi Steven,

In AX2012 there is a field on the Main accounts called 'Default consolidation account'. This is used when you do an online consolidation in AX, but it can also be used as the mapping to your Global chart of accounts.

A second option is 'Additional consolidation accounts'. This is accessible from the main accounts (details) form on the fast tab 'General'.

You have not mentioned if you have already chosen a tool for your reporting. The use of one of the above mentioned options needs to be implemented in the reporting then.

If you use Management Reporter, you can create the global CoA in this tool and map the main accounts.

Note that every solution requires additional attention when creating new main accounts or a new account in the global CoA. You have to map them consistently.