openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #08678
[Bug 943129] Re: tax problem in a multi-currency enviroment
Hello Amit,
Thanks for your reply.
i totally agree with that the journal entries must be calculated on the
company currency. The problem is with the way this calculation is done.
let me explain better using the same example:
So we have an invoice in EUR with a total value of 2200 eur, vat is 20
%
Untaxed value is 1833.33 and tax=366.67 and this is correct
The journal entry is created in this way
Currency rate=139.590168
Total value 2200 EUR* Currency rate= 307098.37 All
Untaxed value 1833.33 EUR * Currency rate = 255914.84 ALL
Vat value 366.67 EUR * Currency rate = 51183.53 ALL
Here we have different problems :
1. The untaxed value in company currency is not equal to 20% of Total
value
307098.37 / 1.2 = 255915.31 is different from 255914.84
The same from the tax amount
2 Even the tax amount is not 20% of untax amount
51183.53 is different from 255914.84*0.2=51182.96
This is a small difference, but is not correct if you show it. Also when
you have a lot of invoices this difference become significant
I think that the right way is to calculate this value from the total in
company currency
Total in company currency 307098.37
value without tax = 307098.37 /1.2 = 255915.31
Tax value = 51183.06
Thanks
Salvi
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/943129
Title:
tax problem in a multi-currency enviroment
Status in OpenERP Addons (modules):
Incomplete
Bug description:
The company currency that i used is normally different from the invoice currency. In my case i have this configuration:
Company currency All
invoice currency EUR
currency-rate 139.59
Sale price in EUR and tax included on price
In the first attachment is the invoice created and until here seems
everything ok (Total of invoice 2200 EUR, and taxes = 366.67 that is
exactly 20% of the price without vat)
After the validation of invoice, i was expecting that also the tax
amount in company currency should be equal to 20% of real amount in
company currency but was not true, like you can see in the second
attachment. This is a problem because we also have to show the value
in company currency in the printed invoice. I think that this problem
is connected with the way the taxes are calculated by Openerp.
Thanks in advance
Salvi
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/943129/+subscriptions
References