Group Discounts affecting tax calculations

[Richard.Tung]

Here is a sample:

Sub-Total: $125.00

Group Discount: -$37.50 (30%)

Shipping to ON & QC (1 x 1.50lbs) (Standard Courier Delivery): $13.00

13% HST (ON): $13.06

Total: $113.57

When you turn off the ot_group_pricing the total is correct....

I've created table pricing for taxes so if that could affect the total then let me know and I have to provide more details on what you guys might need to help me figure this out...

[Brent]

Did you install any add-ons?

In my case I installed a fresh copy of V1.3.9h. I then imported my database and run the install again but this time in database upgrade mode.

All calculations were now correct. I then started installing my add-ons one of which was the European VAT Mod which happened to contain old code and I was back to square one. When I ported the changes across all was well again.

[Richard.Tung]

Did you install any add-ons?

In my case I installed a fresh copy of V1.3.9h. I then imported my database and run the install again but this time in database upgrade mode.

All calculations were now correct. I then started installing my add-ons one of which was the European VAT Mod which happened to contain old code and I was back to square one. When I ported the changes across all was well again.

I've installed a clean version of 1.3.9h and then imported and updated the sql datebase to 1.3.9h.

I copied my tax and shipping tables over and activated them but I didn't try turning them all off and seeing if the group discounts with the total order was correct.. I will do that next...
Keep you informed...

Thanks for the input...

Cheers