Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Foreign Currency Revaluation Error

Posted on by 5

I have a bank denominated in USD. We ran into some trouble when we ran a foreign currency revaluation using the FCR function in the bank module. The balance in USD (our reporting currency) is correct but the balance in accounting currency (NGN) is way off as a result of the foreign currency revaluation entries. The USD balance is a debit balance while the NGN balance now shows a credit balance. We are out of ideas on how to fix this as we can't reverse the revaluation entries and not sure how to correct the bank balance either.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Foreign Currency Revaluation Error

    Hi Abba-king,

    Can you tell how you enabled the bank foreign currency revaluation? Initially, this was a localization for Russia and Poland only. I don't know in what exact version it was extended for all countries. Before that, usually with a customization it was made available for other countries. Can you tell if you have customizations or are you using the standard?

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Foreign Currency Revaluation Error

    hi

    look this

    community.dynamics.com/.../foreign-currency-revaluation---ap

    DAniele

  • Abba-king Profile Picture
    Abba-king 5 on at
    RE: Foreign Currency Revaluation Error

    Hi Andre, we use Dynamics AX 2012. The foreign currency revaluation entries are typically between our unrealized foreign exchange gain/loss account and the bank ledger.

    pastedimage1672388924058v1.png

    We have the Foreign Currency Revaluation function enabled on the Cash and Bank module and that's where we run the revaluation from, but it seems the revaluation entry amounts posted are really high even when the rate changes within the period are minimal. The outcome is that we now have the accounting currency balance of the bank in a credit position while the reporting currency (USD which is transaction currency we use in posting into the bank) is in a debit position. And we can't really reverse those figures and not sure how to go about fixing it.

    pastedimage1672389187331v2.png

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Foreign Currency Revaluation Error

    Hi Abba-king,

    Can you share what exact revaluation transactions were posted? Are you using Dynamics AX 2012 or Dynamics 365 Finance?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans