VAT Calculation Error on Multiple Items

[biggles]

Hi

 

I've been trying to figure this one out for days. When a customer orders multiple items I get a bizarre error.

 

Essentially OS seems to be calculating things on a VAT included price.

 

For example a ?6-25 item is ?7-34 including 17.5% UK VAT

 

That calculation is right. But if you buy 25 items then OS gives you a total of ?183-50 including VAT.

 

Fine 25 X ?7-34 = ?183-50p BUT :shock:

 

In the UK it is normal to calculate the total nett of VAT then add VAT at the end. This gives a different story;

 

?6-25 x 25 = ?156.25

Add 17.5% ?27-34

Total Including VAT = ?183-59p

 

Nine pence difference. I guess OS is using more than 2 decimal places to calc the inclusive price, but only displaying 2 on screen.

 

6.25 + 17.5% = ?7-34.375

 

0.375 * 25 = 9.375, and theres the 9 pence!

 

I have tried turning off VAT included prices, I have also tried reducing the number of decimal places VAT is padded to. I simply can't get rid of the imbalance.

 

We sell things in kilo lots, up to 2000 kilos in a lot, all looking like individual items. The difference can get really big and I'm bound to annoy the UK VAT Man or my profit margin :?

 

Can anyone shed any light on where I might find the calculation or if there is a fix.

 

I have spent quite some time trawling the forum (and I'm not just saying that!) with no joy.

 

Any help greatly appreciated. :D

 

Nick

[biggles]

The only fix I can work out for this is to use "display prices without tax" in admin panel. I had tried this option before to no avail, but it was showing the tax included price the same as exclusive. Maybe its one of the contri's I installed.

 

Since we deal mainly business to business I have no need to display VAT prices before checkout. So I have deleted a line from products_info.php in /catalog and thats deleted the incorrect figure.

 

However when this option is selected OS then calculates on nett item prices then adds the VAT at the end.

 

Gonna have to look at what contri's I've installed in case its a bug.