Order Total Calculation Error (Group Discount)

[Jace]

(Using v1.3.8a)

I've got some customers set up with a group discount of 5%, but it's taking off 5.529251263943504% instead. Here's the breakdown of a test order I placed:

12 x LM08 = $119.76
5 x SI52 = $2.00
2 x SI13 = $2.40
1 x SI12 = $0.45

Subtotal: $124.61
Prepaid Discount (-5%): -$6.89
Freight: $8.00
Tax (10%): $12.61
Total: $138.33

The prepaid discount (-5%) is supposed to be -$6.23, not -$6.89. Grab a calculator, see for yourself.

And also - the Tax (10%) is supposed to be $12.57, not $12.61. So the order total is wrong, it's showing $138.33 but it's supposed to be $139.02.

Why would it be calculating incorrectly, and how can I fix this?

[Jace]

Come on, surely I'm not the only person who has come across this.

[Jace]

And again, surely people have come across this problem. Any help, please.

[lastron]

(Using v1.3.8a)

I've got some customers set up with a group discount of 5%, but it's taking off 5.529251263943504% instead. Here's the breakdown of a test order I placed:

12 x LM08 = $119.76
5 x SI52 = $2.00
2 x SI13 = $2.40
1 x SI12 = $0.45

Subtotal: $124.61
Prepaid Discount (-5%): -$6.89
Freight: $8.00
Tax (10%): $12.61
Total: $138.33

The prepaid discount (-5%) is supposed to be -$6.23, not -$6.89. Grab a calculator, see for yourself.

And also - the Tax (10%) is supposed to be $12.57, not $12.61. So the order total is wrong, it's showing $138.33 but it's supposed to be $139.02.

Why would it be calculating incorrectly, and how can I fix this?

I'm having exactly the same issue - very embarrassing right in front of the customer....

[swguy]

Create a 1.3.9 test cart with the latest download. Import your database. Retest to see if this issue still exists. If it doesn't, you know you need to upgrade.