V5-V6 - Error in col. amount currency in opening entry for accounts in currency

Bug #736890 reported by Frederic Clementi - Camptocamp
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Fix Released
Medium
OpenERP Publisher's Warranty Team

Bug Description

Hi,

We have a huge accounting error here...

The opening entry do not generate correctly initial balance in currency (it is correct in company currency).

Ex :
- My company currency is EUR
- I have a USD bank account.
- My company fiscal year is from 01-Jan-2010 to 31-Dec-2010
- During the year, I have updated several times my exchange rate

If, on the 31/12/2010, the balance of my account USD bank account is 120000 EUR and 100000 USD

And I generate opening entry on the 01/01/2011

Then my balance on this account becomes something like 120000 EUR (Ok) and 95000 USD (Wrong) because the amount in currency is computed based on the new exchange rate !

The currency balance must be equal to the currency balance on the 31/12/2010 ; it is just a balance brought forward.

Thanks

Tags: maintenance

Related branches

Amit Parik (amit-parik)
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 3 (openerp-dev-addons3)
importance: Undecided → Wishlist
status: New → Confirmed
Revision history for this message
Joël Grand-Guillaume @ camptocamp (jgrandguillaume-c2c) wrote :

Dear Amit Parik,

I just set this bug report as a medium importance. I know I shouldn't, but honestly, I ask you to consider once again this bug. We cannot accept this in financial accounting.

This is just a matter of using the right exchange rate, which is honestly a bug, no ?

Thank you in advance to have a look closer,

Regards,

Joël

Changed in openobject-addons:
importance: Wishlist → Undecided
importance: Undecided → Medium
Changed in openobject-addons:
assignee: OpenERP R&D Addons Team 3 (openerp-dev-addons3) → OpenERP Publisher's Warranty Team (openerp-opw)
tags: added: maintenance
Revision history for this message
Frederic Clementi - Camptocamp (frederic-clementi) wrote :

we could maybe add a new functionnality by adding the possibility to create an opening period not linked to a date so we could use here a specificly computed ex-rate based on average rate on the 31/12/N-1 for instance...

Revision history for this message
Samuel Bissig (Toradex) (samuel.b) wrote :

I agree with the first post. The entries in the opening balance should not be based on any new currency computation but only on the sum brought forward from the old to the new financial year.

I propose that at least on for the account types "balance" the opening entries just fetches the sum of the ammount_currency of all the bookings in the closing period and use this value instead of computing the ammount_currency based on the balance.

This would require only little changes in account_fiscal_close wizard.

Revision history for this message
qdp (OpenERP) (qdp) wrote :

fix landed on trunk in revision 4810. The opw team will put it in stable very soon, i guess.

Changed in openobject-addons:
milestone: none → 6.0.3
Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) wrote :

It has been fixed by revision 4667 <email address hidden> courtesy to Quentin.

Thank you.

Changed in openobject-addons:
status: Confirmed → Fix Released
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.