Order Total wrong when discount applied

[Mobox1 0]

OK - either I need to do back to school or there is something fishy going on when I try and enable a discount to be taken on a product order.

 

As an example:

 

I have an Order Total of ?495 which I need to apply a 10% discount. Having created a voucher to do this, I tested it out and using a tax rate (VAT) of 17.5%, I got the following result.

 

Sub-Total: ?495.00

Discount Voucher:10DIS: -?49.50

Royal Mail (First Class Recorded Post): ?3.45

The VAT in your order is:: ?74.23

Total: ?448.95

 

Although these calculations are right (there is 0.51p of tax in the shipping), the tax was being calculated on the pre discount amount (?495.00) not the post discount total of ?445.50

 

The options in the discount voucher function allow you to have the rec-calculate tax setting on None, Standard and Credit Note. Changing it to standard, I then got:

 

 

Sub-Total: ?495.00

Discount Voucher:10DIS: -?49.50

Royal Mail (First Class Recorded Post): ?3.45

The VAT in your order is:: ?66.86

Total: ?441.57

 

All figures correct apart from the total that has gone from ?448.95 to ?441.57 <_<

 

Can anyone explain why??!! It is rather important as all the order details sent out to customers are showing the wrong VAT amount.

[Mobox1 0]

OK - either I need to do back to school or there is something fishy going on when I try and enable a discount to be taken on a product order.

 

As an example:

 

I have an Order Total of ?495 which I need to apply a 10% discount. Having created a voucher to do this, I tested it out and using a tax rate (VAT) of 17.5%, I got the following result.

 

Sub-Total: ?495.00

Discount Voucher:10DIS: -?49.50

Royal Mail (First Class Recorded Post): ?3.45

The VAT in your order is:: ?74.23

Total: ?448.95

 

Although these calculations are right (there is 0.51p of tax in the shipping), the tax was being calculated on the pre discount amount (?495.00) not the post discount total of ?445.50

 

The options in the discount voucher function allow you to have the rec-calculate tax setting on None, Standard and Credit Note. Changing it to standard, I then got:

 

Sub-Total: ?495.00

Discount Voucher:10DIS: -?49.50

Royal Mail (First Class Recorded Post): ?3.45

The VAT in your order is:: ?66.86

Total: ?441.57

 

All figures correct apart from the total that has gone from ?448.95 to ?441.57? <_<

 

Can anyone explain why??!! It is rather important as all the order details sent out to customers are showing the wrong VAT amount.

 

I should add that I know the difference in order total is due the difference between the two tax amounts, but it should not affect the total. The tax figure should just be calculated on the post rather than the pre-discounted amount.

Edited August 30, 2005 by Mobox1

[chppll 0]

Check the order in which the taxes are figured. You can set this order in admin and it will change the results.

[Mobox1 0]

Check the order in which the taxes are figured.  You can set this order in admin and it will change the results.

<{POST_SNAPBACK}>

 

 

Many thanks for your reply Gene. Would like to try it out but having trouble finding which area of the admin section alters the order in which the taxes are figured. Can you give me more detail on where I can find this?

[Guest]

I am getting this same problem and I have tried to modify the way that the tax is being applied and it doesn't seem to work for me. This is how I have it setup...

 

Sub-Total - 1

Discount Coupons - 2

Shipping - 3

Tax - 4

Total - 5

 

How I want it to work is that it takes the coupon off the sub-total but not off the shipping. Currently it's charging tax on both Sub-Total and Shipping and then removing the coupon from the Sub-Total so it's charging tax on amount before discount.

 

How can this be fixed?

 

Thank you

[chicane 0]

the problem is that the discounts and tax get applied at every single product and you lose precision. to get the right values what i do is i apply discount the subtotal only and then apply my tax to the total.

[Mobox1 0]

the problem is that the discounts and tax get applied at every single product and you lose precision.  to get the right values what i do is i apply discount the subtotal only and then apply my tax to the total.

<{POST_SNAPBACK}>

 

Seb - I have tried moving the order of the subtotal so that the discount comes first. I thought that this would make the tax calculate on the post discount amount. However,the subtotal appears to remain the same wherever I put it?

[wizardsandwars 1]

I think the problem is in the 'Show price with VAT' contribution. In your configuration, set the 'show poducts with tax' option to false, and see if that fixes the subtotal amount on the confirmation page.

[Mobox1 0]

I think the problem is in the 'Show price with VAT' contribution. In your configuration, set the 'show poducts with tax' option to false, and see if that fixes the subtotal amount on the confirmation page.

<{POST_SNAPBACK}>

 

 

thanks for the suggestion, but that causes all the prices on my site to be displayed without VAT which is something I cannot do.