SOLVED Tax on order is different from tax rates

-- HikaShop version -- : 3.2.0

Hi,

Please see the screenshots:


How come?

Kind regards René

Hi,

Maybe you have another order with a tax of 1.35-1.18.
Or it could be that the tax amount coming from the coupon reduction is not taken into account correctly there and the line:
$tax_amount = $taxes_info->tax_amount + @$taxes_info->tax_amount_for_shipping + @$taxes_info->tax_amount_for_payment - @$taxes_info->tax_amount_for_coupon;
should be:
$tax_amount = $taxes_info->tax_amount + @$taxes_info->tax_amount_for_shipping + @$taxes_info->tax_amount_for_payment + @$taxes_info->tax_amount_for_coupon;
in the file administrator/components/com_hikashop/views/tax/view.html.php

Hi NIcolas,

On that moment there was just one order.
As you can see in the field tax amount there is a datum selection just for that day.

There are no coupons active:


Regards René

So could you try the modification I talked about in my previous message and report on the result ?

Hi Nicolas,

Sure, i've modified the file but no change at all.
It has something to do with the shipping costs , because virtual products don't have this tax problem.

Kind regards René

Hi,

Then can you provide all the information of the order so that we can better understand the situation ?
If you edit the additional information of the order, what do you see in the popup ?
Could you provide also a screenshot of all the order details (you can blur/remove private information) ?
Could you provide a screenshot of the settings of the coupon (and not from the listing, but from when you edit it), as well as a screenshot of the settings of the product used in the order ?

Hi Nicolas,

At first we don't use coupons for now,

In the Netherlands every month we have to indicate taxes. Therefore, it is important that we have a good overview of it. With the tax rates in HS you have a nice overview of the different rates. In this case 6% and 21%. The weird thing is that the values match the orders, but not at the rates themselves. Something goes wrong with the calculation.

In the first screen: Selection of the order on that day 4-10-2017



(Below) Detail of the order with 6% tax


Popup of the order details



Tax overview of 4-10-2017 see the difference in price values



I hope is't more clear to you Nicolas, it's a really important issue.

Kind regards

Hi,

It would have been great if you had also provided the details of the products in the order details page and a screenshot of the product edition page like I requested...
Because I have only parcelar information, so I can't be sure of what's going on.
However, I think I understand.
Try changing the line:
$tax_amount = $taxes_info->tax_amount + @$taxes_info->tax_amount_for_shipping + @$taxes_info->tax_amount_for_payment - @$taxes_info->tax_amount_for_coupon;
to:
$tax_amount = $taxes_info->tax_amount;
in the file administrator/components/com_hikashop/views/tax/view.html.php and that should help.
From what I understand, tax_amount already contains the total of the different tax amounts for the current tax rate and thus there is no need to add the shipping/payment/coupon amounts to it.
That seems to coroborate with your screenshots where 1.35 is equal to 1.18 + 0.17, meaning that the shipping taxes are added twice instead of only once.
Please let us know how that goes so that we can apply the fix for the next version.

Hi Nicolas,

Yes now the tax is displaying correct!

Thanks as always great support, Regards René