Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Mapping of Local Chart...
Finance forum
Suggested answer

Mapping of Local Chart of Accounts to Global Chart of Accounts by using Local Account AND Dimension

Posted on by 4
Hi all,
 
we are planning to introduce Dynamics 365 Finance & Operations globally in our group. We intend to use different Local Chart of Accounts in each entity and one Global Chart of Accounts globally for consolidation...
 
Is there a way to use both, Local Account Number PLUS Local Dimension (here a cost center = department), to define the corresponding Global Account?
 
Example: In Germany we use only one (1) Local Account for travel expenses but we use different Local Dimensions (departments) to define, where these costs occurred. We post travel expenses of Selling on this single Local Account and Local Dimension = Selling, Travel expenses of Admin are posted on the same single Local Account but on Local Dimension = Admin. Travel expenses of Selling then should flow into Global Account A ("Selling - travel expenses"), while travel expenses of Admin should flow into Global Account B ("Admin - travel expenses").
 
How can this be realized?
 
Thanks - Rainer
  • Suggested answer
    Giorgio Bonacorsi Profile Picture
    Giorgio Bonacorsi 346 on at
    Mapping of Local Chart of Accounts to Global Chart of Accounts by using Local Account AND Dimension
    Hello, 
     
    There are two alternative ways to handle the consolidation process:
     
    - Manage report: we can set the global main account in a financial dimension. Then, for each local main account, we have to do the mapping with the global financial dimension value. This is the case where we want to manage the consolidation throughout the financial report. The mapping should be done before the transaction posting:
     
     
    Keep in mind that we can also calculate a third financial dimension by combining the main account + financial dimension (department). It's a derived value. For more information, you can see this article: https://daxmsdynamics365.wordpress.com/2023/09/25/whats-the-derived-financial-dimension/

    -consolidation process: we can use the consolidation module present in D365FO. For that, we should map the global main account here:
    The mapping can be done after the transaction posting.
     
     
     
     
    Thank you, we are available to provide any feedback.
     
    Kind regards,
    Giorgio
  • Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 11,153 Super User 2024 Season 2 on at
    Mapping of Local Chart of Accounts to Global Chart of Accounts by using Local Account AND Dimension
    Hi ,
    Like Andre mentioned it, you need to consider customization for this e.g. with a mapping table to map local COT to Global COT.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,353 Super User 2024 Season 2 on at
    Mapping of Local Chart of Accounts to Global Chart of Accounts by using Local Account AND Dimension
    Hi Rainer,
     
    There is no support for moving different transactions to two different main accounts depending on a dimension using the consolidation feature. You can consider a customization.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans