OpenERP

[Probably solved] Uncomprehensible residual amount

Asked by forstera

Hello all,
I received a query from my account departement and I can't answer to them. I passed all the morning tracing the event but .... here's the question.
Our main currency is Swiss Francs. They've a supplier invoice in € with the amount of 2782 dated of februara the 17th. At this time, currency rate (€ - CHF) was 0.673401. So we have, in Swiss Francs, the amount of 4131.27 CHF.

They paid the invoice on march the 3rd. At this time, the currency rate was 0.675083 so they paid, in swiss francs, an amount of 4120.97 CHF.
The difference between the 2 amounts are 4131.27 - 4120.97 = 10.30 CHF. So they made a new invoice line of 10.30 for the difference of rate.

the problem is that now, the invoice is in the state of Done but with a residual amount of 3.92 (I suppose swiss francs) and we don't understand where is this amount comes from...

If anybody has an idea, it's welcome !

For information, we've the l10n_ch module (swiss accounting) installed.

Per advance, thanks a lot for your help

Arnaud

Question information

Language:
English Edit question
Status:
Solved
For:
OpenERP Edit question
Assignee:
No assignee Edit question
Solved by:
Vinay Rana (OpenERP)
Solved:
Last query:
Last reply:
Revision history for this message
forstera (arnaud-forster-deactivatedaccount) said : 		#1

Ok, I've understood the problem, but doesn't know if it's a bug or not. Here it is :

We have the module 'c2c_currency_rate_update' installed. This module automatically retrieves the exchange rates. In our case, this is made every day at 11:00 am !

The invoice I refered to was made on february the 17th at 10:52. At this time, the exchange rate was the one retrieved on february the 16th !! (the exchange rate of february the 17th has been retrieved 8 minutes later).

the problem in this case is that the exchange rate was not the same on february the 16th and ferbruary the 17th, so, when the accounting department paid the invoice, the datas were corrects but the system, to establish the difference of exchange rate took the exchange of the 17th.

So we had the following values :

Exchange rate on february the 16th : 0.673401
Exchange rate on february the 17th : 0.672450

Amount of invoice (in € ) : 2782
Amount of invoice (in Swiss Francs) with the exchange rate of february the 16th : 4131.27

When the invoice was paid on March the 2nd :

Exchange rate : 0.675083
Amount paid in € : 2782
Amount paid in Swiss Francs : 4120.9747

Difference of change : 4131.27 - 4120.9747 = 10.30
Invoice line to correct the exchange rate : 10.30

Now, the systems calculate the amount with the exchange rate of february the 17th which gives : 4137.110 CHF
The difference of value between ffebruary the 17th and ferbruary the 16th is : 4137.110 - 4131.27 = 5.84 CHF

5.84 * 0.675083 = 3.9154 = 3.92 (rounded) which is this residual amount.

To solve that, I changed the time of the retrieve of the exchange rate, but do have I to notice that as a bug ?

Thans

Revision history for this message
Best Vinay Rana (OpenERP) (vra-openerp) said : 		#2

Hello Forstera,

The related following critical bug already exist in LP and we are working on this.
https://bugs.launchpad.net/openobject-addons/+bug/511104

Thanks.

Revision history for this message
forstera (arnaud-forster-deactivatedaccount) said : 		#3

Thanks vra (openerp), that solved my question.