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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Reverse Foreign Curren...
Microsoft Dynamics AX (Archived)

Reverse Foreign Currency Revaluation

(0) ShareShare
ReportReport
Posted on by nyt963 270

Hi,

I performed a foreign currency revaluation using the form in the General Ledger and re-valuated all balance sheet accounts for the month of January 2014.

The revaluation was performed and my vendor and customer control accounts have been re-valuated, but not the corresponding customer and vendor subledger accounts.

I now realised that I should've used the foreign currency revaluation form in the Accounts payable and receivable modules.

Is there any way of reversing the foreign currency revaluation that was performed on the GL accounts so that I can rerun the revaluation through Accounts Payable and Receivable?

Thank You

Sean

*This post is locked for comments

I have the same question (0)
  • CHELHA Profile Picture
    CHELHA 5 on at
    RE: Reverse Foreign Currency Revaluation

    Hi Rajinikanth,

    can you please share the code required for such activity

  • MKS81 Profile Picture
    MKS81 54 on at
    RE: Reverse Foreign Currency Revaluation

    Hi Rajinikanth,

    can you please share the code required for such activity

  • Community Member Profile Picture
    Community Member on at
    RE: Reverse Foreign Currency Revaluation

    Hello RJay,

    I have a question regarding the code modification for AX 2012.

    Does it make GL foreign currency revaluation work like AP/AR revaulataion, which the system is automatically reversed all the previous unsettled unrealized transactions and record the new ones with new rate at the current month.  

    Or you need to reverse it next month manually?

    Thank you.

    Asagi

  • Community Member Profile Picture
    Community Member on at
    RE: Reverse Foreign Currency Revaluation

    Hi All,

    Finally, i have figured out the code part that need to be modified to reverse these foreign currency transactions. Please reach out if you need any specifics on this.

    Thanks,

    RJay

  • nyt963 Profile Picture
    nyt963 270 on at
    RE: Reverse Foreign Currency Revaluation

    Hi RJay,

    This was a long time ago and unfortunately I cannot recall exactly how we did it. I know that a developer wrote a job for me that created the reversal journal, but I am not sure exactly how he did it.

    Sorry that I cannot be of more assistance.

    Sean

  • Community Member Profile Picture
    Community Member on at
    RE: Reverse Foreign Currency Revaluation

    Sachin,

    can you elaborate a little more on how to do it?  I do have access to master exchange rate.

  • Community Member Profile Picture
    Community Member on at
    RE: Reverse Foreign Currency Revaluation

    Hi Sean,

    Can you advice me on how did you reverse the revaluation?

    Thanks,

    RJay

  • Community Member Profile Picture
    Community Member on at
    RE: Reverse Foreign Currency Revaluation

    HI

    I just wanted to know what happen to the unrealized gain/loss account balance if we run the financial year closing, because when we close the year all P/L account becomes zero and balance is transferred to retain earning. how would system cancel the previous revalued unrealized transaction of previous closed year at the time of invoice settlement/payment in the next financial year.

  • psidoun Profile Picture
    psidoun 20 on at
    RE: Reverse Foreign Currency Revaluation

    Just to clarify

    if I re-run a exchange rate revaluation on Account receivable on same perimeter like period and transactions, it will reverse previous entries with previous exchange rate and re-generates new ones with new exchange rate, is this statement OK?

    Second point is regarding transactions made prior to second revaluation process that might impact GL.

    As an example if I posted a payment in foreign currency before the second treatement, realized and unrealized won't be accurate, will they? only next revaluation will adjust with proper value.

    Thanks in advance for your input

    Best regards

  • Verified answer
    Sachin Ahuja Profile Picture
    Sachin Ahuja 360 on at
    RE: Reverse Foreign Currency Revaluation

    IF possible,

    You can change the exchange rate on master and then run the Exchange adjustment from GL.

    It will nullify the effect of previous exchange adjustment.

    Now update the correct rate on which you want to perform the exchange adjustment on AR, AP & GL as required.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans