News:

Looking for documentation? Take a look on our wiki

Main Menu

vat after discount

Started by mblokdijk, November 13, 2014, 17:19:52 PM

Previous topic - Next topic

mblokdijk

seems simple, i want VAT to be calculated on the price after using an awo coupon. but the price vm calculates vat on is the price before the discount is applied. resulting in to high vat ammounts. how do i fix this?

vm 2.6.xx
Passionate Joomla webdeveloper from the Netherlands, please checkout jmodules.com

jenkinhill

Have you got "Calculate the discount before tax" turned on in Awo configuration?
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

mblokdijk

#2
it should calculate tax after discount... and not discount before tax.

turned off it does this

Subtotal                              299,00 DKK
Forsendelsesomkostninger      39,00 DKK
Moms udgør                          59,80 DKK
Rabat (0gYzJC)-                    89,70 DKK
Total                                  248,30 DKK

turned on it does this:

Subtotal                              299,00 DKK
Forsendelsesomkostninger      39,00 DKK
Moms udgør                          23,92 DKK
Rabat (0gYzJC)                    -89,70 DKK
Total                                  248,30 DKK

tax=25%

it should do this

Subtotal                              299,00 DKK
Forsendelsesomkostninger      39,00 DKK
Moms udgør                          41,86 DKK
Rabat (0gYzJC)                    -89,70 DKK
Total                                   248,30 DKK

41.86 is the correct tax amount (25%) for the 299 mines the rabat (discount)

299-89.70*(25/125)=41.86

but i cannot get this to work...

Passionate Joomla webdeveloper from the Netherlands, please checkout jmodules.com

jenkinhill

Discount must be applied before tax is calculated - which is then based on the final product price (discount applied).  Thats what the switch in AwoCoupon Pro configuration enables. If it is not working then I suggest you ask Seyi for help in http://awodev.com/forum
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

mblokdijk

#4
this is where it keeps going wrong...

rules:
product with default rule 25% vat, and greenland 0% so minus 20% dataxbill

the correct total should be 684,79, and not 646.44. difference (38.35, showing in the cart) is in the fact that tax is calculated before discount, and not after discount

chaning awodev settings does not solve it. this does nothing... we have already set the 30% discount  to 24 % (exl vat) it shows the correct tax amount now, but it does not calculate right.

why cannot we solve this. its not rocket science, but turning into almost!!!

[attachment cleanup by admin]
Passionate Joomla webdeveloper from the Netherlands, please checkout jmodules.com