Foreign currency revaluation for Bank accounts in AX2012

(1) Share

Report

Posted on by Community Member

Hi,

How can we do foreign currency revaluation for Bank Accounts? I can see the options in Accounts Payable & Receivable modules but not in Cash and Bank Management module. Instead there is an option in General Ledger and there I have run the revaluation by selecting the options "Foreign currency revaluation" & "Monetary" in GL account setup. After running the ledger account I can see the balaces are going to the Realized/Unrealized Gain/Loss accounts but in Bank accounts those transactions are not reflecting. It means there will be different balances in bank account and corresponding ledger.

Anybody has any idea on the same?

Thanks in advance,

Dhanoop R.Warrier

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi, maybe check the last Post at www.dynamicsax-fico.com

Hope it helps,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (1)

Report

Hi Dhanoop,

At a customer we did a similar customization. There are two countries where the bank revaluation is available. It is created for Russia and Poland. The post provided by Lidwig helps you to enable the Russian version. I think this blog is missing a small part. I believe there are some fields on the BankAccountTrans table which also has a countryregion property filled with RU which needs to be removed then.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

I have followed the link you have provided. It is working very well. Superb. Thank you very much.

It is really helpful for me.

Thanks once again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

Actually I have exactly followed the link and it worked really well for me. I haven't removed fields for RU. I am working in Zambia so I have added the country code ZM and it has accepted quite well.

Thanks for the help.

Have a nice day.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I have done foreign currency revaluation for banks just now. But I made a mistake. I haven't selected particular USD banks. I did it for all. But what happened was that it has done revaluation even for local currency and posted the figures in Unrealized Loss. The issue here is when I opened that local currency bank transactions some figures are showing in local currency with revaluation voucher number but if I drill down to the voucher I can see it has posted as USD and USD figure has gone to Unrealized Loss account. Is there any method to reverse that revaluation and then I can do it correctly? Otherwise is there any method to correct those wrong entry. I tried to make manual JV but then currency issue is coming.

Your help is very much appreciated.

Thanks,

Dhanoop R.Warrier

Was this reply helpful? Yes No