Currency Convertion Wrong Calcuation
We use EGP currency as base currency and USD, EUR for foreign currency and we need to set the open bank balances for each USD, EUR bank account.
1 USD = 17.79 EGP
In Odoo's currency terms Set to : EGP=1.00 , USD= 0.05621135 and Odoo only accepts 6 decimals so we enter the exchange rate as EGP=1.00 , USD=0.056211 only , a result of that :
- When are entering in opening balance for bank account in Journal 170.94 USD , Odoo suppose to convert to 3041.02 EGP which what we need .
- Odoo Calculate the conversion 170.94 USD = 3041.04 EGP , so there is a difference of 0.2 which can not resolve and as a result the opening balance of the company is not balanced.
So please me us know how we can get the right result or if not if there is a work around.