VAT not calculating correct after using Discount Coupon

[infocom]

HI

I can't seem to find this solution in other threads. On one of my sites, when using a discount coupon "First Order" you get 10% off. But the VAT is calculating wrong when using the coupon. I cannot see where the figure is coming from. I've tried turning tax on and off for shipping and the coupon but this is not the issue. I can't see what values its using to calculate tax.

Wrong Values:-

Sub-Total: £13.98
Discount Coupon: First Order : -£1.40
Shipping Method (Standard): £6.95
VAT 17.5%: £3.17
Total: £22.70

What it should be:-

Sub-Total: £13.98
Discount Coupon: First Order : -£1.40
Shipping Method (Standard): £6.95
VAT 17.5%: £3.42
Total: £22.95

Where is £3.17 for Tax coming from??? Its like it thinks the total to calculate tax on is less than it is. The total to calculate tax on should be £13.98 - £1.40 + £6.95 = £19.53 (17.5% of which = £3.42). BUT £3.17 is 17.5% of £18.11. So where is it getting £18.11 from??

Thanks

Laurie

[jaygee]

Looking purely at the numbers would imply it is deducting the VAT element of the discount again, i.e. ((13.98 -1.4)*.175) - (1.4*.175) + (6.95*.175) which results in 18.13*.175 that equals 3.17.

You need to check the code and see if it's easily fixed.

[schoolboy]

No easy solution to this... It's a bug in the core code:

If the cart contains multiple products, it somehow "compounds" the discount tax calculation. If the cart has just ONE product, the discount coupon will calculate tax correctly.

We got round it by doing the following:-

ADMIN->MODULES->ORDER TOTAL->DISCOUNT COUPON...

Then, EDIT...

Set RECALCULATE TAX as a CREDIT NOTE (RADIO BUTTON), (STANDARD seems to be the default, so CHOOSE CREDIT NOTE)

Set TAX CLASS as your chosen tax class.

I don't know why this fixes things for us. There may be other settings that influence what we've done, but at least we can have a shopper add multiple products, invoke the discount at checkout, and get the correct tax to display.

Try my solution, add some (more than 1) products to a cart and invoke a discount coupon, see if the tax calculation is now correct.

PS: This MAY be influenced by some settings in the Discount Coupon set-up - ie: where you configure what categories and products the discount coupon is applicable to. If your discount coupon is GLOBAL (all categories and products) then you should have no problems doing what we did.

BEAR IN MIND that if you offer GIFT VOUCHERS --- DO NOT apply discounts to these!!! (You could soon go out of business if you do... Think about what I'm saying here!) (See my WIKI article on Discount Coupons)

[Brent]

Laurie,

I can't remember the full details now but I had a similar problem many moons ago.

Ajeh and Jeff helped me out in this old archived thread

It was for the older version but I bet some of the suggestions will still help you.

Regards

Brent

[infocom]

Thanks Schoolboy, tried your method setting the re-calculate tax to Credit Note and now get different values! Also trtied setting it to None and got same as Credit Note.

Sub-Total: £13.98
Discount Coupon: First Order : -£1.40
Shipping Method (Standard): £6.95
VAT 17.5%: £3.67
Total: £23.20

[schoolboy]

Yeh... but in your calcs (above) you're still getting a slightly incorrect VAT. If you CHARGE vat, then you must not set it as <NONE>. Try it again to your default tax setting and see if it shows vat properly...

(It looks like it's not taking tax off the &#163;1.40).

Your tax should come to &#163;3.42...

The "extra" 25p is being added because the &#163;1.40 "discount" is classified as not being "influenced" by your vat settings. (maybe???)

(IT GETS SO COMPLICATED - especially after a few glasses of wine!!!)

EEK... having said that... what are the tax settings on your shipping??? You may need to ensure that everything "sings off the same hymn-sheet".

Grahame

[schoolboy]

Oh.. and by the way....

The SORT ORDER of <ORDER_TOTAL> also influences how the calcs are done...

Make sure the discount coupon total comes AHEAD of tax... (seems like you're doing this though???)

The <ORDER-TOTAL> module has to add everything up... see what must be DEDUCTED (eg: coupons)... ADD the shipping... come up with the SUB TOTAL... and THEN apply your tax... THEN >>> GRAND TOTAL.

Grahame

[infocom]

Yeah am applying VAT (same 17.5%) to shipping too, and order total is at the bottom. Must be a big like others have said. Thanks for helping, I will have to take a look again tomrrow now.
Laurie

[Brent]

The thread I supplied above is worth a read as the order totals are discussed in detail along with the "incl tax" settings. It was following these instructions that fixed the problem for me.

[infocom]

Hi Brent. Sorry the thread is quite long and many solutions are suggested, but I can't seem to pick out the one that fixes this problem. What was the solution you tried?

Thanks