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

(1) Share

Report

Posted on by RG-23070655-0

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

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

André Arnaud de Cal... 303,679 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Giorgio Bonacorsi 2,044 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No