web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Mapping corporate char...
Finance forum

Mapping corporate chart of accounts to statutory account structures in other countries

(0) ShareShare
ReportReport
Posted on by 5

I am setting up a world-wide COA for a global company. I only want to use one COA. However, there are statutory requirements in certain companies (Germany; China; etc.). I do not want to create separate COAs if at all possible. is there a mapping or substitution logic available to allow local users to continue using the local sequence that will map to corporate structure?

Categories:
I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Mapping corporate chart of accounts to statutory account structures in other countries

    Hi Dandy374,

    You have to be a bit careful here because some countries, such as France require a specific local COA. As a result, auditors want to see the local account numbers when you export data for taxation or auditing purposes.

    What companies do often in this situation is that they setup local COA for all of their companies where a local COA is required and then map it to the global COA. The mapping can be made by a standard field in the main account form or by using financial dimensions. Another alternative is the financial report designer where no prior mapping is required but where you can do the mapping in the financial report designer.

    In general there are a lot of standard ways how this mapping can be made.

    What you have to clarify though is whether one of your legal entities has to use a local COA or not.

    If one is needed such as for France and you use a global COA for them instead then a lot of workarounds might have to applied to get out the data in the way government agencies want them.

    So, be careful and clarify beforehand with your local offices.

    Best regards,

    Ludwig

  • VENKAT6452 Profile Picture
    287 on at
    RE: Mapping corporate chart of accounts to statutory account structures in other countries

    Hi Ludwig

    Good Afternoon.  

    Can you explain bit more on " The mapping can be made by a standard field in the main account form" .  Is there any field available to map the local ledger account form with Global ledger account?

    Regards

    Venkat

  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at
    RE: Mapping corporate chart of accounts to statutory account structures in other countries

    Hi,

    Adding to Ludwig response, For local COA you should create main account and if it require to be mapped with global COA for consolidation purpose then you can use consolidation account field on main account form

  • VENKAT6452 Profile Picture
    287 on at
    RE: Mapping corporate chart of accounts to statutory account structures in other countries

    Hi Saurabh, Thanks for your reply.  Still I need some clarification.  In main account form there field called "Standard account" under Standard General Ledger account.

    I want to know use of this field.

    We have one customer where they want local COA (for France legal entity for tax and auditors purpose) instead of Global COA.

    I am assuring to use the above "Standard account" field is used to map to Global COA.

    Please clarifify.

    Thanks

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans