Tax Rates "total amount" without shipping costs?

-- HikaShop version -- : 4.4.2

Hi Support,

I am trying to find out how to read the total VAT overviews per month.
In order not to have to add up all the invoices from April, I have done a simpler test, only the overview of the day 1 May (that appendix).





Line 4: Sales tax 9% is zero, that's right.
Line 6: Selling EU without VAT is also correct.

But now line 1: I have added the invoices and I arrive at turnover € 878.05 including VAT,
which is € 725.66 excluding plus 21% VAT is € 152.39;
The overview (Line 1) shows the correct VAT amount but NOT the correct total amount, but € 711.20.
It's not the price without shipping cost, because tot total shipping cost of all 10 orders is € 2 x 8,75 (and 8 of them are with free shipping)
So the question is: How is the amount of € 711.20 built up? or is this a bug and should it be € 878,05?

In line 3 there is an amount of € 53.47. But why is this the amount without the shipping costs and on line 6 included the smae shipping cost?

Hope you can help us.

Kind regards,
Lumiga

See here all orders from 1-5-2021

Hi,

First, I would like to point out that last year, you contacted us about a similar issue:
www.hikashop.com/forum/taxes/900244-orde...hout-vat.html#321077
At that point, tax rates with a rate of 0 were just displaying 0 on both columns all the time.
After this, I've actually made a big patch to calculate the amount taxed for each price everywhere on the frontend so that it could be stored in the order_tax_info of orders when the orders were created, so that that could then be properly used on the display here.
That's why you have sometimes not 0 in these columns for 0% tax rates. Now it seems that I've missed some things as I can see in the xlsx you've provided here www.hikashop.com/forum/install-update/90...on-4-4-2.html#332320 that the amount value is still missing for that data.
So it would be great if you could provide a backend access as well as a FTP access via our contact form with a link to this thread so that I could check on your website what's going on.
www.hikashop.com/support/contact-us.html
Now, solving the situation for these 0% tax rates on your website will be easy I think.
Just adding the code: after the line: in the file administrator/components/com_hikashop/views/tax/view.html.php shoudl do it since it will automatically take the order full price if the tax rate is 0, the amount is not provided, and there are no other tax rates on the order.
But it won't work for orders with several tax rates (with some of them at 0, so it would still require proper investigation).
Also, regarding the 711.20 amount, I can't say anything as I don't have the tax info data of the orders for that period and thus I can't check the algorithm against your data to stop where the problem is, or if it's just something you're missing in the interpretation of the data being displayed. So the backend and FTP access will be great to check the situation there and understand what's going on.

Hi Nicolas,

I have made a copy from production server to acceptation server and sent you the logindetails.
Hope it helps you to investigate.

Kind regards,
Lumiga

Hi,

Thank you for the access.
I've found that the issue comes from the shipping cost untaxed amount being ignored from the tax calculations when the order is created.

I've made a patch to fix that. Please download the install package of HikaShop on our website and install it on yours and it will add the patch.

However that means that you won't see any changes with the orders you already have as this patch is to fix the creation of the order.
So you'll have to check by creating an order that the shipping of the order is properly taken into account so that you'll know that next time you generate the calculations on the tax rates listing, you'll get correct results.

Hi Nicolas,

It is not entirely clear to me yet.

Question 1:
Do I understand correctly that the amounts circled in red on lines 1 and 3
should be in theory be € 878,05 (for line 1) and € 60.70 (for line 3) in the future?

I know we can't check it now, but that's the idea, if I understand it well?





Question 2:
The code you provide me is to seperate the 0% lines, as I asked you in this issue?
www.hikashop.com/forum/taxes/900244-orde...hout-vat.html#321077

If we do indeed find the amounts behind the namekeys in the future, then we do not need to split it up anymore.
Because that has already been done in the overview and we no longer need to look at the Additional information on line 6.

Do I understand you well in this case?

Hope to hear from you.

Kind regards,
Lumiga

Hi,

1. Yes.

2. The code I gave in www.hikashop.com/forum/install-update/90...ng-costs.html#332412 is to help when the "amount" is missing or wrong in the order_tax_info column when the tax rate is 0% and there is no other tax rate on the order. However, this code change doesn't address the root cause of the issue you report here, which is that the shipping costs is not properly taken into account in the "total amount" column. That's what the patch I've just added should address.
The goal here is that all the numbers in your screenshot get circled in green

Thanks!

I'll let you know in a few weeks if it worked!

Thanks again for all your help.
I really appreciate it.

Hi Nicolas,

It looks like the (TOTAL AMOUNT 21% VAT) issue is still not solved.
When we show all orders from 31-5-2021 we get an incorrect total amount.
I don't know what's missing in the total price it doesn't seem to be the shipping costs.
We have set all our shipping methodes to Automatic taxes set to Proportional.

The VAT amount is correct!

This version: com_hikashop_business_v4.4.2_2021-05-11_21-14-34.tar.gz was installed on 11-5-2021


Just to be sure, I have now (2021-06-11 15:54) updated the website to version 4.4.3
So I'll test this again with an other date this week.

See screenshots





Screenshot from the 4 orders with the additional information.

New test on 14-6-2021 with Hikashop version 4.4.3 and still the total amount is not correct!
Only the total TAX amount is correct.





Hope you can fix this issue.

Is more known about this problem?
Do you already have a solution or do you have not yet looked at it?

Hello can somebody anwser me?

Hi,

Sorry for that.
I didn't had much time in the past few weeks with the numerous projects I was on and the on going support. And it's quite a complex subject to look into.
I wanted to look at the issue on the website you had provided access to, but it only has orders up to the 10th of May.
Could you update it with a fresh copy of the website so that I can look into the situation with your example of the 14th of June ?

Oké no problem

I have update the website, so you can take a look.

Hi,

Thanks. I didn't had the time to look into it today. Probably won't happen on monday either as I have to catchup with the support from the weekend. I'll probably look into it on Tuesday.

Just a reminder

Hi Nicolas,

Just an extra reminder.
You will be busy, but this is an important part for the new European tax return.
I hope you can look at it soon.

Kind regards,
Lumiga

Hi Nicolas,

My client gets nervous and wonders when this will be resolved.
Could you please prioritize this?

Kind regards,
Lumiga

Hi Nicolas,

Please give us a planning for this issue.

Kind regards,
Lumiga

Any News?

Please fix this issue or fix issue:

www.hikashop.com/forum/taxes/903141-tota...overview.html#336447