Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Currency Revaluation

(0) ShareShare
ReportReport
Posted on by 34

Hi All, 

As the year is about to end, I'm just wondering if there is a feature in the business central dynamics that automatically perform a currency revaluation each quarter? We have multiple currency bank accounts in which 3 are in foreign bank accounts. I'm just wondering if a currency revaluation through the system is possible. 

Thank you in advance!

Regards,

Lawrence

  • Gavin Profile Picture
    Gavin 2,339 on at
    RE: Currency Revaluation

    Hi,

    That's great news. Thanks for the kind words :). Glad you've managed to get to the bottom of the issue.

    Thanks

    Gavin

  • Dv Acuma Profile Picture
    Dv Acuma 34 on at
    RE: Currency Revaluation

    Hi Gavin,

    So, I've been putting the wrong information in the wrong column, that's why I'm getting the incorrect revaluation value, but I've finally got the gist of it, thanks to you! I appreciate you taking the time to explain this to me; our support has been pretty much useless after taking our money! We should be paying you instead! Lol. Anyway, thank you very much for thoroughly explaining this matter to me. I appreciate it!

    Have a great week ahead!

    Regards,

    Lawrence

  • Verified answer
    Gavin Profile Picture
    Gavin 2,339 on at
    RE: Currency Revaluation

    Hi,

    Its difficult to comment without seeing your exact figures so below is a worked example from my demo system.

    I created a new EURO Bank Account (my LCY currency is GBP)

    I then posted these 3 transactions:

    pastedimage1669374555087v1.png

    Therefore, my bank account balance is €600 with a GBP equivalent of £516, (GBP is my LCY currency) 

    I then added the exchange rate for 30/11/22 of 1.5 to the currencies table ready for the revaluation.

    pastedimage1669374705077v2.png

    I then ran the Adjust Exchange Rate using the options below

    pastedimage1669374779409v3.png

    This produced the following adjustment:

    pastedimage1669375051024v4.png

    The GL Entries are:

    pastedimage1669375104392v5.png

    As you can see the system has posted an adjustment of £116.00 which is correct. (the GBP balance at a rate of 1.5 should be £400 so the system posts an adjustment of £116)

    Therefore, check the running balance LCY in the bank account ledger entries after you have ran the revaluation.

    pastedimage1669375190265v6.png

    Please note its only the bank account ledger entries that the system uses to calculate the adjustment. It doesnt look at the GL entries as this doesnt hold any foreign currency amounts. (other than reporting currency which is something different)

    Hope this helps you figure out what's happening on your system.

    Thanks

    Gavin

  • Dv Acuma Profile Picture
    Dv Acuma 34 on at
    RE: Currency Revaluation

    Hi,

    Thank you very much for answering my questions!

    However, I am now a bit more confused. So tried doing this to a practice company and I filed out the relevant currencies needed for the revaluation. I was able to run the revaluation (I only did it to the GBP bank account) and the value that the system generated is different to the balance sheet rate that I computed ahead of this. Oddly enough, it was off by about 6-7k. That's why I am a bit confused with how the system actually computes the revaluation.

    My way of computing the balance sheet rate is:

    End of the month rate (as per our central bank)

    Multiply by: Ending Foreign Currency Running Balance as per the bank statement

    Thanks

    Lawrence

  • Verified answer
    Gavin Profile Picture
    Gavin 2,339 on at
    RE: Currency Revaluation

    Hi,

    When you post via "Adjust Exchange Rates" I dont think you can reverse the G/L Register but you could try this by going to the "G/L Register" page and selecting the G/L register that was created and testng this. However if not, you can just rerun the "Adjust Exchange Rate" batch job again with the correct rate and adjustments will be posted automatically.

    With regards the rate, the system will use the rate entered in the exchange rate pages and adjust based on the filters in the "Adjust Exchange Rate" batch job. Its worth noting only the Customer, Vendor or Bank ledger entries are adjusted as these entry tables hold both the LCY and multi-currency values for the transaction. As only LCY values are stored in the General Ledger Entries table you can't revalue GL codes. (you can have one additional reporting currency but that is slightly different)

    I always find its best to test this particular routine in a practice company to ensure you're happy with how its all working.

    Hope this helps.

    Thanks

    Gavin

    P.S Allowing a GL revaluation is posted on the MS ideas site here experience.dynamics.com/.../

  • Dv Acuma Profile Picture
    Dv Acuma 34 on at
    RE: Currency Revaluation

    Thanks! It is such a helpful website, just a last one; if ever the need arises, is there a way I can reverse the revaluation entry? How does the system compute what value it will put as a currency revaluation? Does it get the balance sheet rate and adjust the current amount accordingly?

  • Gavin Profile Picture
    Gavin 2,339 on at
    RE: Currency Revaluation

    Hi,

    I wrote this blog on the various fields which hopefully explains about the difference between relational and exchange rate amount fields.

    thedynamicsexplorer.com/.../

    Hope this helps.

    Thanks

    Gavin

  • Dv Acuma Profile Picture
    Dv Acuma 34 on at
    RE: Currency Revaluation

    Hi,

    First of all, thank you so much for responding to this so quickly.

    I have one question though, what is the difference between, Exchange rate amount, relational exchange rate amount, and adjustment exchange rate amount. I'm a bit confused by this.

    Thanks!,

    Lawrence

  • Gavin Profile Picture
    Gavin 2,339 on at
    RE: Currency Revaluation

    Hi,

    Yes. You need to run the "Adjust Exchange Rates" batch job and select "Bank Accounts"

    pastedimage1669288376969v2.png

    Just ensure you have the correct adjustment rates entered for each of the "Currencies".

    pastedimage1669288463616v3.png

    Hope this helps.

    Thanks

    Gavin

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!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans