Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

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

(1) ShareShare
ReportReport
Posted on by 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans