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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Foreign currency reval...
Finance | Project Operations, Human Resources, ...
Answered

Foreign currency revaluation

(0) ShareShare
ReportReport
Posted on by NSSriram 118

In AX 2012 R3, i have run foreign currency revaluation. Transactions/vouchers have got generated - both AP revaluation as well as AR revaluation.

But in AX, is there any easy way to find, the source invoice for which the foreign currency revaluation has been created?

pastedimage1604675990203v2.png

(Above screen shot) --> Foreign currency  revaluation voucher - IN2EXAJ000139201 has been created by AX as a result of revaluation run. The currency is EUR (that is shown by AX).

What is the invoice for which this transaction has been created? 

What is the source transaction in AX with reference to which this foreign currency revaluation is created?

For some rows, the invoice lines have the invoice reference, but for other lines the invoice field is blank (as in the screen shot).

In such cases, where the invoice field is blank, how to identify the source invoice or any other such source transaction for which the foreign currency revaluation has been created?

Especially when there are thousands of such lines (with no invoice reference) is created by AX.

Many thanks for your advice and guidance in advance.

Regards

Sriram 

I have the same question (0)
  • Ding Li Profile Picture
    Ding Li 480 on at

    Hi,

    the following docs for your reference (GL/AP/AR FCR):

    docs.microsoft.com/.../foreign-currency-revaluation-general-ledger

    docs.microsoft.com/.../foreign-currency-revaluation-accounts-payable-accounts-receivable

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees on at

    Hi Sriram18588,

    After you run the AR and AP currency revaluation, Goto Vendor and customer transaction. You will see vouchers with transaction type "Foreign currency revaluation", Select any voucher and click on view settlement button. It will show you there all the corresponding details.

    As standard process subledgers are updated to reflect the unrealized gain or loss and an accounting entry will be posted to General ledger.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Sriram,

    There is not much available in AX and that can help answering all of your questions.

    To a large extend the foreign currency revaluation process is a 'black box'.

    You can check the voucher and print a special report that gives you some insights.

    1072.fx.png

    Yet, in general, it is almost impossible to trace the individual amounts that have been revalued using standard tools.

    If you need more insights, I would recommend talking to a developer to see what can be done. 

    Best regards, 

    Ludwig

  • NSSriram Profile Picture
    NSSriram 118 on at

    Hi Junaid Idrees,

    Thanks for the response. It does help.

    Regards

    Sriram

  • NSSriram Profile Picture
    NSSriram 118 on at

    Hi all,

    The issue is client ran a revaluation. But then, they wanted to reverse the entire revaluation.

    This was done by changing the method from "standard" to "invoice date" - with the considered date  and date of rate being the same as the original revaluation run.

    The revaluation got reversed successfully.

    But the balance for the unrealised gain/loss account the trail balance level - before running the revaluation and after cancelling the revaluation (using "invoice date" method) are not the same.

    Is there any possibility to find what is causing this difference?

    Ideally, if the full revaluation is reversed, the balance on the forex account is expected to get back to the same balance as it was before running the revaluation.

    Or is the method used for reversing the revaluation not proper?

    Thank you for the guidance and support.  

    Regards

    Sriram

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Sriram,

    How was the revaluation reversed?

    Can you explain what was done to reverse it so that we can try replicating it?

    Also, can you let us know for which country/region this environment is configured?

    Many thanks,

    Ludwig

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 625 Super User 2025 Season 2

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 439 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 373 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans