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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Multicurrency Revalaut...
Microsoft Dynamics GP (Archived)

Multicurrency Revalaution for Financial

(0) ShareShare
ReportReport
Posted on by Suet Lee 1,351

Hi All,

It is possible that Multicurrecy Revaluation is calculated incorrectly? Please refer to the following links:-

http://img89.imageshack.us/img89/7220/20100419evaluationstep0.png http://img89.imageshack.us/img89/4790/20100419evaluationstep0f.png http://img13.imageshack.us/img13/7220/20100419evaluationstep0.png http://img13.imageshack.us/img13/7220/20100419evaluationstep0.png http://img263.imageshack.us/img263/7220/20100419evaluationstep0.png http://img263.imageshack.us/img263/7148/20100419evaluationstep2.png http://img202.imageshack.us/img202/3789/20100419tb.png

I have no clue how DP came out with the revaluation amount. Now we have to work out the correct revaluation manually.

Appreciate for feedbacks.

Thanks

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi, yes the financial revaluation works fine. It simply takes the transactions that make up a GL balance and revalue them at a certain rate. It gets complicated when more than one currency is posting to the account etc. but it certainly works.

    Unfortunately, you haven't given us enough information to go on in the screen shot. We would need to explore all of the transactions that posted into that account and look at their originating currency, their posting dates, and their original FX rates. We would also need to see what options you choose at the revaluation stage.

    Best regards,

     

     

  • Suet Lee Profile Picture
    Suet Lee 1,351 on at

     Hi,

    Thanks so much for getting back to me. I have tested on revauation and believe it should work fine. But somehow, the result shows otherwise for this issue.

    Please find attached. Basically, revaulation was done on USD Currency. rate for 31/3/10 is 3.305

    http://img339.imageshack.us/img339/8228/usdbanktb.png 

    http://img339.imageshack.us/img339/6364/20100426selecacccurr.png

     

    http://img717.imageshack.us/img717/8312/100426smartlistusdbank.png  Looking forward to hear from you. Thanks 

     

  • Suet Lee Profile Picture
    Suet Lee 1,351 on at

    Hi Ian,

    When troubleshooting, i noticed that the Revaluation journal posted shows Currency ID as USD. But for my client, the Currency ID displays as MYR although they revalued USD. It is not possible to select to revalue MYR as their functional currency ID is MYR.

    Is there anyway to rectify this?

    This could be the thing causing a huge unrealized amount calculated.

    Thanks

    Regards,

    SuetLee

  • Community Member Profile Picture
    Community Member on at

    Hi Suet,

    Apologies, but I haven't had a chance to look at this yet. I've been very busy - my week was thrown out by the flight delays in Europe. I'll get to this probably tomorrow? In the meantime, keep sending any updates etc.

    Talk to you soon.

    Ian.

     

     

  • Suet Lee Profile Picture
    Suet Lee 1,351 on at

    Hi Ian,

    That's really fine. I am sorry to hear bout your flight delays. Yes, will keep you posted on any findings.

    Many Thanks.

    Regards,

    Suet

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans