Problem with VAT after using discount coupon VAT is not changing...

[mrplants]

Hi everyone,

Im using Zencart 1.3.5 and just added the use of discount coupons.
VAT rate is set to 17,5%.

Everything was working OK until I added the use of a discount coupon. This is before using the discount coupon:

Sub-Total: £19.95
Flat Rate (Best Way):£9.95


Total: £29.90
VAT: £4.45

Until here everything is fine.
Now let see if I set up a discount coupon for 10%.

Sub-Total: £19.95
Flat Rate (Best Way):£9.95

Discount Coupon: LL0107 :-£1.99

Total: £27.91
VAT: £4.45

VAT should be calculated over £27.91 and should be £4.15 but calculates it over £29.90 but is still £4.45

Could anyone point me in the right direction!

Thanks upfront for your time and effort!!

Mr. Plants

[DrByte]

What are your settings in Admin->Modules->Order Total - Discount Coupons ?

[mrplants]

These are settings which doesnt look to good is it?

Order Total ModulesModules Sort OrderAction
Warning: main(/home/worldofp/public_html/shop/includes/languages/english/modules/order_total/old_ot_coupon.php) [function.main]: failed to open stream: No such file or directory in /home/worldofp/public_html/shop/shop_admin/modules.php on line 174

Warning: main(/home/worldofp/public_html/shop/includes/languages/english/modules/order_total/old_ot_coupon.php) [function.main]: failed to open stream: No such file or directory in /home/worldofp/public_html/shop/shop_admin/modules.php on line 174

Warning: main() [function.include]: Failed opening '/home/worldofp/public_html/shop/includes/languages/english/modules/order_total/old_ot_coupon.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/worldofp/public_html/shop/shop_admin/modules.php on line 174
COD Feeot_cod_fee
Fatal error: Cannot redeclare class ot_coupon in /home/worldofp/public_html/shop/includes/modules/order_total/ot_coupon.php on line 19

[mrplants]

[FONT=Arial]Hi Dr Byte. We had attempted a code tweak to fix this as in:
http://www.zen-cart.com/forum/showthread.php?t=45213&highlight=tax+calculation (post 9)
The errors were due to renamimg original ot_coupon.php to old.ot_coupon.php. Oops. The tweak has been removed so we can sort this out.[/FONT]

[FONT=Arial]The settings are:[/FONT]

[FONT=Arial]Order Total Modules > Discount Coupon >
This module is installed : true
Sort Order : 280
Include Shipping : false
Include Tax : true
Re-calculate Tax : None
Tax Class : VAT (which is 17.5%)[/FONT]

[FONT=Arial]The Sort order for all the order total modules has been tweaked to:
Discount Coupon : 280
Low Order Fee : 400
Shipping : 200
Sub-Total : 100
Tax : 999
Total : 888
See: http://www.zen-cart.com/forum/showthread.php?t=46241 (post 7)
I don't think this is part of the problem though.[/FONT]

[FONT=Arial]The coupon is set up like this:
Coupon Name : test01
Coupon Amount : 10.0000%
Start Date : 12/18/2006
End Date : 12/19/2007
Uses per Coupon : Unlimited
Uses per Customer : 3
Valid Product List : NONE
Valid Categories List : NONE
Date Created : 12/18/2006
Date Modified : 12/18/2006[/FONT]

[FONT=Arial]All this give the following information in the Order Confirmation page:
Sub-Total : £59.90
Flat Rate (Best Way) : £9.95
Discount Coupon: LL0107 : -£5.99
Total : £63.86
VAT : £10.40[/FONT]

[FONT=Arial]As you can see the VAT is not correct. If I tweak the coupon module to have 'Re-Calculate tax: Standard' it gives:
Sub-Total : £59.90
Flat Rate (Best Way) : £9.95
Discount Coupon: LL0107 : -£5.99
Total : £62.06
VAT : £8.60[/FONT]

[FONT=Arial]With 'Re-Calculate tax: None' and 'Include Tax : False' it gives
Sub-Total : £59.90
Flat Rate (Best Way) : £9.95
Discount Coupon: LL0107 : -£5.10
Total : £64.75
VAT : £10.40[/FONT]

[FONT=Arial]And with 'Re-Calculate tax: Standard' and 'Include Tax : False' it gives
Sub-Total : £59.90
Flat Rate (Best Way) : £9.95
Discount Coupon: LL0107 : -£5.10
Total : £62.95
VAT : £8.60[/FONT]

[FONT=Arial]As you can see it works out the total differently every time but the tax can stay the same.[/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]Thanks...[/FONT]

[mrplants]

Hi DrByte,

First of all best wishes to everyone!

During the holidays I have been trying to figure this VAT problem out but came out with nothing...did you maybe found an answer to what is causing this VAT error?

[mrplants]

We have just tried an upgrade of our site to 1.3.7 (we were on 1.3.5) it all seems to have gone swimmingly (mostly) but I'm afraid it has not resolved this issue.

I should point out that the VAT (Value Added Tax) is 17.5% for those who don't know and we are displaying products with tax included.

The figures we have shown have been for a basket with two items but the same issues can be seen with any amount of items. The experiments as before are below.

Sub-Total: £59.90
Flat Rate (Best Way): £9.95
Discount Coupon: LL0107 : -£5.99
Total: £63.86
VAT: £10.40

With 'Recalculate Tax' set to 'Standard':
Sub-Total: £59.90
Flat Rate (Best Way): £9.95
Discount Coupon: LL0107 : -£6.04
Total: £62.97
VAT: £9.51

With 'Re-Calculate tax: None' and 'Include Tax : False' it gives
Sub-Total: £59.90
Flat Rate (Best Way): £9.95
Discount Coupon: LL0107 : -£5.10
Total: £64.75
VAT: £10.4

And with 'Re-Calculate tax: Standard' and 'Include Tax : False' it gives
Sub-Total: £59.90
Flat Rate (Best Way): £9.95
Discount Coupon: LL0107 : -£5.15
Total: £63.86
VAT: £9.51

As you can see they are NEARLY the same. Obviously something has been done in this area. Are we missing something? We're finding it hard to believe we are the only suffering from this issue!

Cheers.

[paulm]

We're finding it hard to believe we are the only suffering from this issue!

You are surely not the only one. ot_coupon has several bugs (surely for including tax stores).

Here's a discussion about coupon issues: http://www.zen-cart.com/forum/showthread.php?t=54847

JeffD has uploaded an improved version in the above thread which fixes most issues (in my case, I am also using including tax prices).

[mrplants]

Yes! .....Thanks Paul, everything is finally working!

Cheers,

Mr. Plants