Zen Cart Logo
Forums / Templates, Stylesheets, Page Layout / Price rounding problems with VAT

Price rounding problems with VAT

Locked

Views: 1,299

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
28 Jan 2008, 10:40 AM
#1
nicedreams avatar

nicedreams

New Zenner

Join Date:
Dec 2006
Location:
UK
Posts:
32
Plugin Contributions:
0

Price rounding problems with VAT

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.

28 Jan 2008, 3:25 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Price rounding problems with VAT

Try this...

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

29 Jan 2008, 9:01 AM
#3
nicedreams avatar

nicedreams

New Zenner

Join Date:
Dec 2006
Location:
UK
Posts:
32
Plugin Contributions:
0

Re: Price rounding problems with VAT

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

Any other ideas?

29 Jan 2008, 6:47 PM
#4
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Price rounding problems with VAT

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

30 Jan 2008, 8:58 AM
#5
nicedreams avatar

nicedreams

New Zenner

Join Date:
Dec 2006
Location:
UK
Posts:
32
Plugin Contributions:
0

Re: Price rounding problems with VAT

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