historical currency rate support

Bug #591961 reported by Samuel I. (Toradex)
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Fix Released
Medium
OpenERP R&D Addons Team 3

Bug Description

It looks like OpenERP can not manage to choose the correct historical currency exchange rate. If we create a booking entry por a past date, the system will always use the latest exchange rate for this currency instead of using the currency rate for this period.
This is not acceptable.

Background:
We have a multi-currency setup of OpenERP with two foreign currencies. We are updating the exchange rate every month so we have a clean currency history. There are cases when we have to enter bookings for a past date/period using the historical exchange rates in the system. This simply does not work.

Please confirm this bug.

Tags: 5.0

Related branches

Revision history for this message
Fabien (Open ERP) (fp-tinyerp) wrote :

to be fixed in trunk.

Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 3 (openerp-dev-addons3)
status: New → Confirmed
qdp (OpenERP) (qdp)
Changed in openobject-addons:
milestone: none → 6.0-rc2
importance: Undecided → High
importance: High → Medium
Changed in openobject-addons:
status: Confirmed → In Progress
Revision history for this message
rvo(Open ERP) (rvo-openerp) wrote :

Hello Samuel I. (Toradex),
          I have gone through the issue but could not face the error. I describe the steps followed by me:
             I have company currency set with EUR.
              1) I setup foreign currency Rs (INR) with 2 different dates and rates:
                 a) 2010/11/24 - 50.0000
                 b) 2010/01/01 - 59.9739
              2) I create an invoice with date 2010/11/24 and with currency Rs and confirm it.
              3) I check in the Journal Entries menu, and the entries show the debit and credit amount calculated as 2 EUR which is on the basis of the latest exchange rate for this currency. It seems to work in a normal way.
              4) Then, I create an invoice with date 2010/01/05 with currency Rs and confirm it.
              5) Now, the journal entries show the debit and credit amount calculated as 1.67 EUR which is on the basis of the exchange rate as on 2010/01/01. This also seems to work in a normal way.

Thanks

Changed in openobject-addons:
status: In Progress → Invalid
Changed in openobject-addons:
status: Invalid → In Progress
Revision history for this message
Samuel I. (Toradex) (samsimg) wrote :

Thanks for looking into this.

We experience the problem when creating manual financial booking entries in the journals (i.e. General Ledger).

If we create a booking entry using the Amount Currency Field and a foreign Currency, the system calculates Debit/Credit bookings automatically. For this particular calculation OpenERP always uses the latest Exchange Rate no matter in what the booking date is.

Revision history for this message
Mustufa Rangwala (Open ERP) (mra-tinyerp) wrote :

Hello Samuel,

We have fixed the problem in Addons3 branch. Its merged with trunk addons soon.

revision-id: mra@mra-laptop-20101125115838-nsx04bclby615iaw
revno: 4699

Thank you,
mra

Changed in openobject-addons:
status: In Progress → Fix Released
Revision history for this message
TeMPO (info-tempo-consulting) wrote :

Bug still exists on 6.0 rc2

Revision history for this message
TeMPO (info-tempo-consulting) wrote :

The original problem related by Samuel I Toradex (when creating manual financial booking entries in the journals (i.e. General Ledger) is still present in 6.0 rc2 when you create a manual invoice and specify a foreign currency

Revision history for this message
Raphaël Valyi - http://www.akretion.com (rvalyi) wrote : Re: [Bug 591961] Re: historical currency rate support

Guys, I advise you take a look at:
https://bugs.launchpad.net/openobject-addons/+bug/645263
<https://bugs.launchpad.net/openobject-addons/+bug/645263>specially
comment:
https://bugs.launchpad.net/openobject-addons/+bug/645263/comments/17
<https://bugs.launchpad.net/openobject-addons/+bug/645263/comments/17>there
is probably some synergy to be found here.
(sorry if I'm wrong, I've read though quickly about this one).

On Wed, Jan 5, 2011 at 3:11 PM, TeMPO <email address hidden> wrote:

> The original problem related by Samuel I Toradex (when creating manual
> financial booking entries in the journals (i.e. General Ledger) is still
> present in 6.0 rc2 when you create a manual invoice and specify a
> foreign currency
>
> --
> You received this bug notification because you are subscribed to
> OpenObject Addons.
> https://bugs.launchpad.net/bugs/591961
>
> Title:
> historical currency rate support
>
> Status in OpenObject Addons Modules:
> Fix Released
>
> Bug description:
> It looks like OpenERP can not manage to choose the correct historical
> currency exchange rate. If we create a booking entry por a past date, the
> system will always use the latest exchange rate for this currency instead of
> using the currency rate for this period.
> This is not acceptable.
>
> Background:
> We have a multi-currency setup of OpenERP with two foreign currencies. We
> are updating the exchange rate every month so we have a clean currency
> history. There are cases when we have to enter bookings for a past
> date/period using the historical exchange rates in the system. This simply
> does not work.
>
> Please confirm this bug.
>
>
>

Revision history for this message
TeMPO (info-tempo-consulting) wrote :

Raphaël

maybe I was not clear enouh in my mind when I wrote entries 5 and 6
my problem is not related to the update of the exchange rate but to the handling of those rates
Now after some more tests it is more clear

If you have a currency with two different rates at different dates the entries in the journal are correct
which means they are taking in account the good rate according to the date

The problem is that when you create a manual invoice the system is evaluating the prices with the last
exchange rate and not the one corresponding to the invoice date

If you do the same tests starting from a Sale Order it works, meaning that the price is computed with the exchange
rate of the date of the sale Order

So i WIll fill a new bug for the manual invoice

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.