openerp-expert-accounting team mailing list archive

[nicolas moreau <nicolas@xxxxxxxxxx>]

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
Accounting Experts, which is subscribed to the bug report.
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