You’re offline. This is a read only version of the page.
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
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
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.
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.
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.
Hi, maybe check the last Post at www.dynamicsax-fico.com
Hope it helps,
Ludwig
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
Zain Mehmood
6
Moderator
Share
Report
All responses (
Answers (
