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 / Microsoft Dynamics AX (Archived) / Alternative CoA for co...
Microsoft Dynamics AX (Archived)

Alternative CoA for consolidation

(0) ShareShare
ReportReport
Posted on by Pathris 55

hi 

We have currently one CoA used by 3 Legal Enteties. 

What I need is an alternative CoA for consolidation as all 3 legal enteties will send their account balance to a 3rd party consolidation company (company policy) - this consolidation company has its own account numbering to the different main accounts. I thus need a way in AX to copy past all data from one CoA to an alternative CoA with different account numbering setup.

e.g.

CoA X:      Total Assets 199999     -  balance: 50.000 GBP accounting (reporting 35.000 USD)

CoA Y:      Total Assets  399999    -  Balance 35.000 USD 

 

Thanks

Pathris 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Alternative CoA for consolidation

    Hi Pathris, One possiblity to achieve this is setting up a new financial dimension "consolidation COA" where you link your accounts to the consolidation account required. Please note that this works only if there is a 1:1 relationship between the accounts you use for posting and the ones that you use for consolidation purposes. Hope this helps, Ludwig

  • Pathris Profile Picture
    Pathris 55 on at
    RE: Alternative CoA for consolidation

    Hi Ludwig, could you be more specific on how I can achieve the goal by using a new Financial dimension as 'Consolidation CoA'?  :)

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Alternative CoA for consolidation

    Hi Pathris,

    Ok, let's try :-).

    In GL you setup a new financial dimension and call it let's say "CON" for consolidation. The financial dimension CON includes all your consolidation accounts.

    Then you adjust your account structures and make sure that the new financial dimension "CON" is included in all your account structures. That is, whenever you generate a posting on a ledger account the financial dimension "CON" is used.

    The third step would be to open the chart of accounts and go through each main account. If you switch the main account view to a company specific view you can see the financial dimension section and setup a financial dimension. Now, you need to go through all of your accounts and establish a fixed relationship between your main account and the financial dimension "CON". Expressed differently you need to do the mapping between your local main account and your consolidation account.

    That's it basically. Please note that this setup only works if you can establish a 1:1 relationship between your local main accounts and your consolidation accounts.

    Please let me know if this clarifies things.

    Thanks,

    Ludwig

  • Pathris Profile Picture
    Pathris 55 on at
    RE: Alternative CoA for consolidation

    Hi Lüdwig,

    Sorry for the late reply, I been busy with other tasks. 

    I eventually come up with a different solution. In AX7, there is this Consolidation Online feature. In there you can map one of your Financial dimensions as 'Company account', then in the consolidated transactions you can always trace back to which legal entity the transaction came from or even filter on legal entities in the trial balance. 

    I can upload a seperat CoA for my Consolidation Legal Entity (Ledger Setup) and then map the account of my functional Legal Entities to the new CoA through the field 'Default consolidation account' on the main account.

    Thanks! :) 

  • Pathris Profile Picture
    Pathris 55 on at
    RE: Alternative CoA for consolidation

    Hi Ludwig,

    I tried you setup and that works also perfectly find.

    Thanks alot. ;)

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans