sledp0rn Posted January 24, 2006 Posted January 24, 2006 Although a small thing, this is driving me crazy! I have tried everything I can think of. The store only does it once in a while, it seems the price needs to be just right for it to round the wrong way. An example from an order today: Sub-Total: $29.95 Canada Post (1 x 0.3kgs) (Xpresspost, 2006-01-30): $12.69 GST# (7%): $2.99 Total: $45.63 Store prices are in CAD. Some database info on applicable cells: PRODUCTS products_price: 0.0000 products_tax: 0.0000 TAX RATES tax_rate: 7.00 CURRENCY decimal_places: 2 value: 1.000000 It would seem the error occurs or is presented in the orders_total table. For each order it will list as per the attached image from the data base... Database picture It would appear that the tax has been rounded from 2.9848 to 2.99. It would also appear that the total was not calculated with the rounded tax but rather the raw tax (which is the proper way), as the total was $45.62, prior to the 'text' colum showing $42.63. So where do I find the coding for the rounding process or is there such a thing I can edit. Please shed some light on this annoying problem for me!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.