Prestashop Calculates wrong VAT for specific prices in Out of EU region - How to fix it

[lennartoester]

We have found a huge bug in the Prestashop VAT calculation of a product if that product has a spoecific Price set

 

Bug is logged on forge.prestashop.com: http://forge.prestashop.com/browse/PSCFV-12734

 

The error only shows when the region is a country where no VAT rule is Applied.

This is our setup

 

We have a webshop in Denmark. Denmark is a VAT country with in the EU. The VAT is 25%
If I let customers from f.x Greenland buy products from me, they are in the EU Out region and has no VAT.

 

The problem and calculation example

The problem is that the specific Price is including VAT which Means that the product will get even cheaper for customers buying from a VAT free zone/region.

 

If we have a item that cost 12 DKK, and put it on sale for 10 DKK, then customer should pay 10 DKK including VAT.

From Greenland they should pay 8 DKK, but because of the error they are only charged 7,6 DKK

 

Thats because we take the 12 DKK and deduct the VAT. 12*0,8 = 9,6 and then the specific Price as well which is -2 DKK

 

The Fix should be

The error is that the specific Price should also get the VAT deduction because Greenland is OUT of EU

So that should be 2*0,8 = 1,6 DKK

 

Then the result would be 8 DKK and correct.

 

Now this is with items of small value. If you sell expensive items you will Loose the VAT of the specific Price reduction on every order.

 

The error has been present since 1.3.x and never fixed in an official version.

Now this is a problem for every customer in the EU so if any one has fixed it or have a way of doing so I and many others will be very pleased.

 

Please let me know if I can help in any way

 

Cheers

Lennart

[elund]

I am also interested in a solution for this issue

 

The problem in the code for the old versions were that the price could either be with tax or without tax while quantity discount was always with tax.

 

How and where is the quantity discount calculated in the new versions (1.5.6.2 or later)?

 

I have tried to look into ..\classes\product.php, but the code has changed a lot since version 1.3.

 

Can aynone point me in the right direction?

[El Patron]

it ain't a bug if there is no forge report.  sort of like peeing in a blue suit, feels good but nobody notices.  (very American joke)

open a forge report here:

http://forge.prestashop.com/

then please post the forge bug report back here.

[lennartoester]

Hey El Patron

Thanks. I guess that this would never has been found since its only a an EU problem if webshops are in the specific zones. :-)

 

I'll create a bug report, but I would be a very happy man if someone could point me in the right direction on where to fix it myself. This is kind of a pressing matter as I have customers in Greenland and Norway that I have to handle by mail :-)

 

Cheers mate

Edited February 11, 2015 by lennartoester (see edit history)

[djfm]

Hi lennartoester,

 

Thanks for your report. I took the liberty of editing your original post to add the link to your bug report so that people looking on an answer here can follow the status of the bug on forge

[lennartoester]

Great thanks.

Its my first time I tried to post a bug. When its fixed is it possible to get a description of the files edited/changed.

I and many others have a Prestashop that are not upgradeable due to many changes in other core files :-)

[marcofalco]

Hi, I have similar problem, but for f.x. Finland order passed without Tax, but I have set up tax for Finland 20%. However the order processed without tax and payment through PAYPAL.

 

Finland is part of EU, Presta should automaticly add VAT I set on 20% for Finland.

Edited February 11, 2015 by marcofalco (see edit history)