VAT adding 1p to orders

[ncopeman]

Virtuemart 2.0.6  - Joomla 2.5.6

Hi all, I've searched the forum but can't seem to find a solution. I do apologise if i've missed a thread.

I've set VAT at 20%
The product cost price is £19.17
Final price £23.004

This is OK if you buy one product.

If you purchase more than one product it adds 1p extra in the checkout.

I'm not fantastic at maths but is it because it's reading 3 decimal places instead of two? Can I change that?

The website is live and my client is refunding the penny by sending it back to them in a cute card with their product but I really do need to fix it.

Thanks in advance!!

Neil

[Robert V.]

I've set VAT at 20%
The product cost price is £19.17
Final price £23.004

ncopeman; This is logical.

By default the currency in the shop is configured at 2 decimals. This means
£23.004 * 2 = £46.008 = £46.01

Try this:

Make a VAT rule that says: VAT per product = +%; the number is 20. (+20% for the product)
Add this VAT rule to every category/ article that it should apply to.

In the configuration | shop | prices; check if everything is set to 2 decimals,
Now for that article if the end product including VAT should cost £23.00, devide £23.00 with 1.2 (which is yer cost price) = £19.166 (With 2 decimals this still will be represented as £19.17 without VAT)

Now the end price for the customer should be £19.166 * 1.2 = £22.9992 (=£23.00 with the 2 decimals enabled), which will be taken of the bank account
If you multiply this by 2 it reads: £22.9992 * 2 = 45.9984 (=£46.00 with the 2 decimals enabled)

Hope this helps; good luck with it.

[ncopeman]

Thanks so much rvisschedijk, that all makes sense!

I shall give it a go!!

Neil

[ncopeman]

So i gave it a try and it worked. I'd already set the tax and decimal points as suggested but worked through the prices /1.2 i.e. £19.1666 and not £19.17 (turns out that price was the roundup price of 19.1666 as supplied by the client).

[Robert V.]

Been very busy the last couple of weeks and hadn't much time left to look at this forum.

ncopeman, glad i could help out.