VirtueMart Forum

VirtueMart 2 + 3 + 4 => Plugins: Payment, Shipment and others => Topic started by: ncopeman on June 24, 2012, 21:41:38 PM

Title: VAT adding 1p to orders
Post by: ncopeman on June 24, 2012, 21:41:38 PM
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
Title: Re: VAT adding 1p to orders
Post by: Robert V. on June 25, 2012, 03:34:39 AM
QuoteI'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.
Title: Re: VAT adding 1p to orders
Post by: ncopeman on June 25, 2012, 20:29:45 PM
Thanks so much rvisschedijk, that all makes sense!

I shall give it a go!!

Neil
Title: Re: VAT adding 1p to orders
Post by: ncopeman on June 26, 2012, 00:49:18 AM
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).

Title: Re: VAT adding 1p to orders
Post by: Robert V. on July 11, 2012, 00:12:17 AM
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.