Bank Statement : write-off with secondary currency

Bug #669903 reported by Vincent Renaville@camptocamp
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Status tracked in Trunk
5.0
Fix Released
Medium
Jay Vora (Serpent Consulting Services)
Trunk
Fix Released
Medium
qdp (OpenERP)

Bug Description

Hello,

We have a problem with write-off if you follow this use case :

- You create a new database, with company currency set to EURO
- you create an invoice in CHF
- you specified in third party account linked to the invoice CHF as secondary currency,
- You create the invoice.
- You create an bank statement
- you select an bank journal in CHF in the bank statement
- You import the previously created invoice
- You check in the Reconcile, that the balance is equal to 0.0
- You confirmed it
- You will reach the error :
       You have to provide an account for the write off entry !

The system require an write-off line in the reconcile part of the bank statement even if the balance is already equal to 0.0

Thanks for your precious help,

Vincent

Tags: maintenance
Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) wrote :

Hello Vincent,

Our R&D Teams are currently focused on the latest OpenERP version, and unfortunately this issue does not affect it.
In the case of past stable releases of OpenERP, you may contact our Maintenance team via the OpenERP Publisher's Warranty, and they will quickly help you solve this issue.

Thanks.

tags: added: maintenance
Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) wrote :

Vincent,

This seems a bit critical for us.

if (not currency_obj.is_zero(cr, uid, account.company_id.currency_id, writeoff)) or \
           (account.currency_id and (not currency_obj.is_zero(cr, uid, account.currency_id, currency))):

I have 2 proposed solutions:

1. Improve the mentioned condition in reconcile() method to avoid the check of secondary currency.(I am investigating the use of it elsewhere).
2. Adding a little check in condition if writeoff is zero. ( add another if - if writeoff:)

Please share your views.
Thanks.

Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

Hello Vincent,

This issue happens only when paying foreign invoices via bank statements, if the payable/receivable account has a secondary currency. You can try the attached patch to fix this issue in 5.0... it wil be released soon on the official branches.

We are verifying at the moment if the issue and patch are valid for trunk as well, in which case they will be ported to trunk too.

Many thanks for the excellent and detailed bug report!

Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

Fix landed in 5.0 with rev. 2879 <email address hidden>

Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

The process is a bit different in trunk, and the error does not occur, which is why the issue was initially marked invalid in trunk (and now Low)
Nevertheless we ported the fix in trunk as it can still be beneficial: landed in trunk in rev 3883 <email address hidden>

Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

After further investigation the new account_voucher code shares the same issue with this exact same case in 6.0, so I'm reassigning to the Accounting team leader for double-check and additional fix before rc2.

Revision history for this message
Vincent Renaville@camptocamp (vrenaville-c2c) wrote :

Thanks for your precious help. i will check it today

Vincent

Revision history for this message
Vincent Renaville@camptocamp (vrenaville-c2c) wrote :

hello,

That's work for me, you can close the bug

Vincent

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.