News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Consolidation Companie...

Microsoft Dynamics NAV (Archived)

Consolidation Companies - Different Currencies - random exchange rate

(0) Share

Report

Report

Posted on by S2k_85

69

Hi Guys,

a bit of help needed.

I am testing our consolidation process for a company in EUR (business Unit) to be consolidated into a company in GBP.

I have gone through the full setup multiple times, set up the currency exchange rates in both the consolidated company and the business unit.

I have tested a few months of roll up, the roll up works as expected however when i look into the General ledger entries the exchange rate being used from the subsidiary to the parent company it is different to the one specified.

I cant understand why this is. am i missing something?

Please help

S2k

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

gert@lynge.org on at

Like (0)

Report

RE: Consolidation Companies - Different Currencies - random exchange rate

If I recall this functionality correctly you setup which current exchange rate method you want to use on each of the G/L Accounts in the subsidiary.

The settings is in the consolidation group on the G/L Account card page. Here you can also select with parent G/L Account to consolidate to (if you need this to do automatic eliminations).

You can choose between multiple approaches regarding exchange rate and you should probably consider using one for result- and another one for balance accounts. Refer to the help for explanation on the different approaches.

Best Regards

Gert Lynge

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,492 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans