Incorrect value stored in hikashop_order

When a coupon is used, the figure for the total product tax is stored in the column order_discount_tax of table hikashop_order, instead of the value of the tax on the discount amount.

Thanks for the reply Nicolas,

Two different orders created:
Order 1:
Coupon 5.00, with no rules.
2 Products, one for 150.00+30.00Tax, one for 24.00+4.80Tax.
Shipping 8.40
The value in order_discount_tax = 34.80000
I believe it should be 0.83333

Order 1:
Coupon 6.00, with no rules.
1 Product, for 23.33+4.67Tax
Shipping 7.20
The value in order_discount_tax = 4.67000
I believe it should be 1.00000

Tax is as for UK at 20%

The orders show with correct values at the backend, so the column may not be used there. I was looking at the data in MySQL so that I can access it from another source and saw this as a discrepancy. I have got around this by doing calculations, but thought you may need to know about it.

Let me know if you need more information.

The setting for Apply Discounts in configuration is "After taxes".

Hello,

I managed to solve this problem by editing the file "..\components\com_hikashop\controllers\checkout.php", I replaced the line :

$discount_tax = $cart->coupon->total->prices[0]->price_value_with_tax-$cart->coupon->total->prices[0]->price_value;

$discount_tax = (@$cart->coupon->total->prices[0]->price_value_without_discount_with_tax-@$cart->coupon->total->prices[0]->price_value_without_discount)-(@$cart->coupon->total->prices[0]->price_value_with_tax-@$cart->coupon->total->prices[0]->price_value);

Thanks Mohamed.

I tried the change you suggested, and I am afraid it is still incorrect.

Now the value is zero. So it is not calculating and putting the VAT on tax in the column. I tried with a coupon at value of 6.00 with tax at 20%. The value in order_discount_tax is zero and in order_discount_price 6.00000 as expected.

I do not know if this applies, but if the process is similar, have a look at the calculation for shipping tax as that is working out correctly.

I think that it's working properly, because for example you can :

- Add a tax to your coupon
- Go to "Hikashop->System->Configuration->main"
- Set the "Apply discounts" option to Before taxes

Then your order_discount_tax field will be corectly set.

- Add a tax to your coupon

Done already (if you mean selecting the Tax category)

- Go to "Hikashop->System->Configuration->main"
- Set the "Apply discounts" option to Before taxes

Why? That does nor make sense to me. You want the calculation after tax is applied to the products, but you want to see what was taken off the product price and what was reduced on the VAT.