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
Hi Rajinikanth,
can you please share the code required for such activity
Hi Rajinikanth,
can you please share the code required for such activity
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
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
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
Sachin,
can you elaborate a little more on how to do it? I do have access to master exchange rate.
Hi Sean,
Can you advice me on how did you reverse the revaluation?
Thanks,
RJay
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.
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
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.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156