Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Reverse Foreign Currency Revaluation

(0) ShareShare
ReportReport
Posted on by 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

  • 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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans