web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Help with Multi curren...
Microsoft Dynamics NAV (Archived)

Help with Multi currency consolidation

(0) ShareShare
ReportReport
Posted on by David Askwith 50

Hello  - I need some help with my company's Multi-currency consolidation.  We consolidate 2 companies, 1 USD based and 1 GBP.  Each month, I specify the closing rate to use as I consolidate, however the balance sheet accounts are not converted to that exact closing rate (it's close, however).  The consolidation translation method on the balance sheet account cards are selected as "Closing Rate".  I run the "adjust exchange rates" everyone as well.  

I'm pretty confused, especially when I drill into the detail from the chart of accounts I can see that the entries for the GBP amounts say "converted at XXX", which is the rate I specified.  However, if you do the calculation in excel it's not using the specified closing rate.  Any ideas?  Looking back, I see that the GBP company consolidated at the expected rate for many months, and then 12 months ago stopped.  I haven't changed my process and I don't see anything strange in the month the consolidation rate stopped working as expected.  Does anyone have any ideas?

*This post is locked for comments

I have the same question (0)
  • Alex Chow Profile Picture
    Alex Chow 4,481 on at

    With multi-currency consolidation, there are many moving parts. A couple of things off of the top of my head:

    1. Make sure you have the fiscal year created

    2. Make sure you specify the exchange rate on the business unit

    3. Make sure the currency code is properly defined on the business unit

    4. If all else fails, you may need to contact your NAV partner to check your setup.

  • David Askwith Profile Picture
    David Askwith 50 on at

    Thanks Alex - I have tried those things already, unfortunately.  I may need to contact a partner.

    Regards,

    David

  • Alex Chow Profile Picture
    Alex Chow 4,481 on at

    For reference, you can check out this MSDN article and make sure you have everything setup:

    msdn.microsoft.com/.../hh169407(v=nav.71).aspx

    If everything is setup properly, you may want to ask your NAV partner to see if they've made any custom changes on this area.

    Good luck!

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans