Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Foreign currency revaluation

Posted on by 110

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 

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Foreign currency revaluation

    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

  • Sriram18588  Profile Picture
    Sriram18588 110 on at
    RE: Foreign currency revaluation

    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

  • Sriram18588  Profile Picture
    Sriram18588 110 on at
    RE: Foreign currency revaluation

    Hi Junaid Idrees,

    Thanks for the response. It does help.

    Regards

    Sriram

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Foreign currency revaluation

    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

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees 12,740 on at
    RE: Foreign currency revaluation

    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.

  • Ding Li Profile Picture
    Ding Li 480 on at

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans