Hi guys,
I'm checking if I am alone here who thinks that currency management is literally non existent in Odoo accounting.
I'm an accountant and I have few customers who operate in many currencies. One company operates in like 6 currencies and does many conversions back and forth with many manual rate adjustments. Another one is a charity that works in two currencies, one of them is very volatile and losses about 50% of value a year. Therefore we are making a lot of currency adjustments to minimise the loss and comply with funding requirements. I was about to transition both companies to Odoo, but have noticed on some other of my clients that changing currency rate doesn't affect BS& PnL. After checking the documentation and tech support, I've learned that Odoo does NOT apply exchange rates retrospectively i.e. You got a an exchange rate for transaction once and live happily with that forever. There's no way to force the rate to be reapplied, no automation for that, except the manual export+update+re upload.
Another issue is that transactions CAN'T have individual rates. There's rates table where rates for given period and that's it. That means if there were two transactions with two different rates on the same day, Odoo can't handle that.
This is very unexpected and frustrating. I can move my customers to Odoo and stopped the transition in mid process. Exporting and reuploading the tables is unacceptable, error prone and not what you would expect from this level of software. Obviously, I'll keep all my customers that operate in currencies, away from Odoo, but I'm quite confused what should I do going further. Is there anyone else considering this as an issue? Maybe there is a simple solution or workaround that I'm not aware off?
Thank you for sharing your thoughts.
Saul