SOLVED Tax on order is different from tax rates

  • Posts: 198
  • Thank you received: 7
6 years 6 months ago #279745

-- HikaShop version -- : 3.2.0

Hi,

Please see the screenshots:



How come?

Kind regards René

Attachments:
Last edit: 6 years 6 months ago by renem.

Please Log in or Create an account to join the conversation.

  • Posts: 81515
  • Thank you received: 13069
  • MODERATOR
6 years 6 months ago #279770

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

Please Log in or Create an account to join the conversation.

  • Posts: 198
  • Thank you received: 7
6 years 6 months ago #279856

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é

Attachments:
Last edit: 6 years 6 months ago by renem.

Please Log in or Create an account to join the conversation.

  • Posts: 81515
  • Thank you received: 13069
  • MODERATOR
6 years 6 months ago #279862

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

Please Log in or Create an account to join the conversation.

  • Posts: 198
  • Thank you received: 7
6 years 6 months ago #279934

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é

Please Log in or Create an account to join the conversation.

  • Posts: 81515
  • Thank you received: 13069
  • MODERATOR
6 years 6 months ago #279942

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 ?

Please Log in or Create an account to join the conversation.

  • Posts: 198
  • Thank you received: 7
6 years 6 months ago #279990

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

Attachments:
Last edit: 6 years 6 months ago by renem.

Please Log in or Create an account to join the conversation.

  • Posts: 81515
  • Thank you received: 13069
  • MODERATOR
6 years 6 months ago #280103

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.

Please Log in or Create an account to join the conversation.

  • Posts: 198
  • Thank you received: 7
6 years 6 months ago #280152

Hi Nicolas,

Yes now the tax is displaying correct!

Thanks as always great support, Regards René

Please Log in or Create an account to join the conversation.

Time to create page: 0.179 seconds
Powered by Kunena Forum