openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #15900
[Bug 865387] Re: wrong currency rounding
like the original example:
- Configure a bank journal for USD currency
- Create a new rate for USD currency, company base is AUD
- Create a new invoice, selecting USD currency and inserting one line of 2086.4
- Invoice created has name: SAJUSD0065(for example)
-Make sure invoice is posted in Journal Entries
- Pay the invoice using Customer Payments
-Throws exception saying SAJUSD0065
the exception is in account_move_line.py (803)
from what we found the exception is raised because the currency adjustment entry didn't get posted and stayed in draft state due to the fact that the amounts didn't match.
The amounts didn't match due to the above rounding errors
hope this makes sense
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/865387
Title:
wrong currency rounding
Status in OpenERP Addons (modules):
Fix Released
Bug description:
openobject-addons/6.0 revno 4863
Steps:
- Configure 'account' module using EUR currency
- Configure a bank journal for USD currency
- Create a new rate for USD currency, with date 2011-10-01
- Create a new invoice, with date 2011-09-01, selecting USD currency and inserting one line of 3638.97 amount
- Pay the invoice selecting 'Reconcile with Write-Off' (with today's date)
The write.off entry is not created (it should be produced by the different currency rates).
This is because of line 88 of base/res/res_currency.py :
round(amount / currency.rounding) * currency.rounding
3638.9700000000003
and this makes false the line 719 of account_voucher.py (line.amount
== line.amount_unreconciled)
I think the line
return round(amount / currency.rounding) * currency.rounding
should be replaced by something like
float(Decimal(str(amount)).quantize(Decimal(str(currency.rounding)),
rounding=ROUND_HALF_UP))
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/865387/+subscriptions