nasty problems with taxes and coupons

  • Posts: 6
  • Thank you received: 0
8 years 2 weeks ago #254878

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.4
-- PHP version -- : 5.6.26
-- Browser(s) name and version -- : all

Dear Hika Shop,
can you please assist me in finding a solution in coupon tax calculating.
The discount value of the coupon is always calculated on the gross price independently if I set "Product tax category" or not in the Coupon configuration.
In my case I'm showing all net prices, and I would like to show also coupon discount amount as net.
This problem create errors also on the tax calculating.

# Here what it is shown:
Subtotal 143,00 €
Coupon -59,49 € *
IVA 4 % 3,34 € *
Total 89,23 €
(the sum doesn't match 143.00-59.49+3.34=86.85)

# Here what should correctly be:
Subtotal 143,00 €
Coupon -57,20 €
IVA 4 % 3,43 €
Total 89,23 €


You can try it yourself in this test website.
www.iandp.it/test/

Product to choose: "Grand Cru Musignano - Can 5 L"
Coupon to add: "JH40SP" (this is a 40% coupon)

If you need, I can send you in private the admin login credentials.

Thanks for your support
Greg

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

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
8 years 2 weeks ago #255099

Hi,

On top of the "product tax category" setting of the coupon, you also have the "apply discount" setting of the HikaShop configuration, in order to control how the coupon values will be calculated.
So please try the different combinaisons of both options and one of them should do what you want.

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

  • Posts: 6
  • Thank you received: 0
8 years 1 week ago #255322

Hi Nicolas,
I've tried all the four combination having always the same result.
here attached an example image.

Thanks
Greg

Attachments:

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

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
8 years 1 week ago #255377

Hi,

I'm not able to reproduce the problem.
Please provide a backend access and a link to this thread via our contact form so that we can have a look at that.
www.hikashop.com/support/contact-us.html

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

  • Posts: 4748
  • Thank you received: 644
  • MODERATOR
8 years 1 week ago #255476

Hello,

For a reason or another I'm unable to add your "product test" to the cart...
There is no button "add to cart"...
Thanks to make the required change in order to able us to process some tests.

Awaiting news from you.

Regards

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

  • Posts: 6
  • Thank you received: 0
8 years 1 week ago #255494

Hi Philippe,
Notthing strange on my side, here attacched I post you the process I can do.
Can't you see the same?

www.iandp.it/test/en/boutique-en

Thanks
Greg

Last edit: 8 years 1 week ago by gpiraccini.

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

  • Posts: 4748
  • Thank you received: 644
  • MODERATOR
8 years 6 days ago #255756

Hello,

I just have a look on your configuration, and I get it, you don't link your coupon with your tax applied on this product.
And so, I you want to get the tax really applied AFTER the discount reproduce this configuration in your Coupon configuration :



The 44% in order to avoid to reduce your discount with the tax add to your Coupn
Hope this will help you.

Regards

Attachments:
Last edit: 8 years 6 days ago by Philip.

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

  • Posts: 6
  • Thank you received: 0
8 years 6 days ago #255778

Hi Philippe,
I've tried your solution, to reach the correct discount and VAT I had to use a percentage of 38.462% (40% / 1.04 VAT). But still the Total doesn't match. (please see attachment)
This happen either if i set Discount TAX calculation Before or After taxes.

Sorry for this, but I think that the discount percentage shouldn't be modify, this because the discount should be applied to the Subtotal indipendently if it is Gross or Net. It is a percentage so this shouldn't create any arithmetical problem.

Thanks
Greg

Attachments:

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

  • Posts: 4748
  • Thank you received: 644
  • MODERATOR
8 years 5 days ago #255839

Hello,

I spent time on your cart and tax configuration, and the calcuation is right, it's the display which is wrong!
You choose in Configuation Main in "of which VAT" to don't display product price WITH tax BUT of course total price is WITH taxes and so that can't be logical with a quick view.

I set this :



And as result I get this :



Maybe the way tax is displayed can seems wrong, maybe add an little message like "with" or "include" can be more clear.
Make an override view in the checkout - cart.php

Hope that will help you to have what your want.

Regards

Attachments:
Last edit: 8 years 5 days ago by Philip.

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

  • Posts: 6
  • Thank you received: 0
8 years 5 days ago #255858

Hi Philippe,
I'm sorry you get it wrong, this was not my intent.
The one you exposed is the actual method we are using in the live environment. We have also modified the VAT description (di cui IVA 4%) = (of witch VAT 4%). But this is not what the client is asking.

I don't know in other countries but in Italy commercial invoice are all done as follow:
List of Products (excluded VAT)
Subtotal (excluded VAT)
Discount (on Subtotal)
VAT 4% (on sum of all 4% products * (1-discount %))
VAT 22% (on sum of all 22% products * (1-discount %))
Total (sum Subtotal-Discount+VAT 4%+VAT 22%)

So this look normal to me, and this is way I was asking for a check on this.

Now I understand there is no way to reach that goal. I've take a quick view of your code and I understand it is too much structurated to make a simple override for this situation.

Thanks for your time
Greg

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

Time to create page: 0.120 seconds
Powered by Kunena Forum