Bug or not? but really weird! Atten: Linda and Ian and ?

[toolcrazy]

First. I am using OSC loaded v4. The only mod I've done is Linda's Login box. ( which I love).

 

I am testing my installation I added an item to the cart and clicked checkout. Everything is working fine. Got to the confirmation screen and checked the total. And found this:

 

Sub-Total: $5.00

Tax: $0.43

FREE SHIPPING! (Free Shipping Only): $0.00

Total: $5.42

 

Uhmm, I think OSC can't add. lol. :D Why would the total be 5.42 when the tax is .43 the tax is correct, but the total isn't. Is it the free shipping contrib? or? I don't even know where to start.

 

Thanks to all, for your help.

 

Steve

[Ian]

Not something I've seen before, but I'll take a look at the code. From your other post you also say that the problem disappears if the item does not attract free shipping, which is very strange.

[toolcrazy]

I tried an experiment. I changed the table rate to:

 

$0.00 same problem arrises

$0.02 the same problem.

$1.00 same problem.

$2.00 same

 

At $3.00 or so it seams to correct itself. My previous post you saw, table rate was at $5.50 (default OSC).

 

One more bit of info. I am using the Check/Money Order module for testing.

 

Thank you very much for the help,

[francis]

I've just come across a similar problem. I have developed an enquiry site as opposed to a selling site, but retained the functionality.

 

For a product/package costing ?99.00 the UK tax rate of 17.5% is shown as ?17.32, whereas the actual basket total is shown as ?116.33.

 

It all boils down to rounding up and down. Using the above figures as an example, the underlying calculations are:

 

Goods value = 99.00

Tax @17.7% = 17.325

Order total = 116.325

 

So that middle of the road "5" is the pain in the backside.

 

Does anyone know if OSC generally calculates up or down in these situations?

 

Cheers

[francis]

Oops forgot to mention. The site I have developed is live and at www.northwestsports.co.uk

[toolcrazy]

In my case OSC is doing the tax calculation then displaying that number rounded up then when it add the number up it rounds down. I don't know, I'm just grabbing at straws. I can't go live until this bug is address. I don't think it looks good when a customer notices that a very sophisticated program appears that it can't add.

 

8.5% of 5.00 is .425

 

In the Washington State USA that would be .43 tax

Mmmmm I hope Ian can figure out a fix.

[tresseh]

Its not a case of OSc rounding up or down in that case - in EVERY case, >= 5 gets rounded up, whilst <= 4 gets rounded down - its not so much a bug as it is an actual mathematical result.

 

Im not sure if a 'fix' is actually required, and therefore cant really suggest anything to help - other than that simple maths uses the above method for rounding up/down.

 

HTH

[toolcrazy]

I realize the reason behind the calculation, but the error is still there. My customer sees $5.00 for the item, $.43 for tax, and $5.42 for a total. It doesn't reflect well on me. I've been in sales for 20 years and customers do notice these things. And they add it to their overall opinion of your store, even though it is in their favor. Don?t get me wrong, I love OSC, and I won?t give it up for another system, no way. I will live with the error if I have to. But, I shouldn?t need to. There are some extremely talented programmers out there, there must be some way to correct this or at least compensate for the ?error?. I might be making a big thing out of nothing, but it needs to be brought to the attention of the OSC team members. And I have done that, even if there is no fix.

 

Thanks for letting me ramble,

[francis]

But in response to tresseh, on that basis the tax value of 17.325 should therefore round up to 17.33, not down to 17.32. Maybe the problem does actually reside in the tax coding somewhere.