Price rounding problems with VAT

[nicedreams]

If I have a product which I wish to price to the customer as £14.00 because of the addition of 17.5% tax, my input price (rounded to the nearest penny) is either too high or too low.

It's not a big deal but it looks untidy having the odd product priced a penny under (or over) a pound.

i.e.:

11.91 x 1.175 = 13.99
11.92 x 1.175 = 14.01

Is there a solution for this problem?

NB - Most of the prices are to the nearest pound or 50 pence.

[schoolboy]

Try this...

In the EDIT PRODUCT screen, enter the £14 value (14.0000) in the PRODUCTS PRICE GROSS field. It may work.

[nicedreams]

The prices are set as attributes in the Attributes Controller. This doesn't have an option for Gross Price.

Any other ideas?

[schoolboy]

You'll have to take your NETT prices to FOUR decimal places (or more)

[nicedreams]

Thanks - I'll give that a go and report back.