Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Mapping of Local Chart...
Finance | Project Operations, Human Resources, ...
Answered

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

(1) ShareShare
ReportReport
Posted on by RG-23070655-0 6
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 665 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
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,282 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.
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,904 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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans