← Back to team overview

openerp-india team mailing list archive

[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