[Skip to main content](#vessel-content)

#   Deference between total order, and overview Tax Rules totals

##

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 1 month ago [\#280622](#280622) by [renem](/forum/user/47055-renem "View renem's Profile")  *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280622 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")* was created by *[renem](/forum/user/47055-renem "View renem's Profile")*

-- HikaShop version -- : 3.2.0
-- Joomla version -- : 3.8.1

Hi,

Please can you take a look at this YouTube movie my client made to display the Coupon value problem?

This message contains confidential information

The difference between this two values is exactly the coupon code value. How can we sorted this out?

Kind regards René

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86574
- Thank you received: 14318
-
-

9 years 1 month ago [\#280626](#280626) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280626 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi,

I supposing that you're referring to that thread :
[ www.hikashop.com/forum/install-update/89...ax-rates.html#280152](https://www.hikashop.com/forum/install-update/892222-solved-tax-on-order-is-different-from-tax-rates.html#280152)
However, on that thread, you were saying that the issue was solved.
So is that a new issue ?
I've seen your youtube video but it doesn't have any information on how the coupon is configured or the details of the order with the coupon.
So I can't conclude on anything to help solve the issue.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 1 month ago [\#280673](#280673) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280673 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Nicolas,

Yes this is a new issue.

The coupon is set as follows
[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationDiscounts1.png](/forum/attachment/40959) ](/forum/attachment/40959 "...Discounts1.png")

1. I the time period as displayed in the video the coupon was used just 1 time.

2. If you add the invoices together, you will get an amount x (here is the coupon value already)

3. If you add the amount of VAT together, you will get the amount y (here the coupon value is not set)

The difference between these values is exactly the coupon discount. Since the coupons are virtual products, they should not be added to amount y.

A solution may be that this coupon code is not added to the VAT summary.

I hope it's so clearer

Regards René

- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationDiscounts1.png](/forum/attachment/40959) ](/forum/attachment/40959 "...Discounts1.png") [ ](/forum/attachment/40959?download=1 "...Discounts1.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86574
- Thank you received: 14318
-
-

9 years 1 month ago [\#280677](#280677) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280677 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi,

So, in the rates listing, which is not correct ? The tax total amount or the untaxed total amount ? Or both ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 1 month ago [\#280773](#280773) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280773 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Nicolas,

Tax total tax please.

regards.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86574
- Thank you received: 14318
-
-

9 years 1 month ago [\#280788](#280788) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280788 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi,

Ok. Then try changing the line from the other thread to:
$tax_amount = $taxes_info-&gt;tax_amount + @$taxes_info-&gt;tax_amount_for_coupon;

Otherwise, please provide a concreate example so that we can have precise information, like a screenshot of the order details for the order creating the difference.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 1 month ago -  9 years 1 month ago [\#280838](#280838) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280838 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Nicolas,

Unfortunately it doest doe anything for the tax amounts
I made several screenshot hopefully this give more clearance.

See the total value of the sales: **€ 2.377,33**

If I add all amounts by VAT, I will deduct this amount: **2380,72**

The difference between these amounts is exactly the coupon discount used in this period: **3,39**

I made a widget with these settings: See the total value of the sales: **€ 2.377,33**

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationReport.png](/forum/attachment/40989) ](/forum/attachment/40989 "...tionReport.png")

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationReport1.png](/forum/attachment/40990) ](/forum/attachment/40990 "...ionReport1.png")

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationReport2.png](/forum/attachment/40991) ](/forum/attachment/40991 "...ionReport2.png")

Total tax overview: If I add all amounts by VAT, I will deduct this amount: **2380,72**

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationRates.png](/forum/attachment/40992) ](/forum/attachment/40992 "...ationRates.png")

- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationReport.png](/forum/attachment/40989) ](/forum/attachment/40989 "...tionReport.png") [ ](/forum/attachment/40989?download=1 "...tionReport.png")
- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationReport1.png](/forum/attachment/40990) ](/forum/attachment/40990 "...ionReport1.png") [ ](/forum/attachment/40990?download=1 "...ionReport1.png")
- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationReport2.png](/forum/attachment/40991) ](/forum/attachment/40991 "...ionReport2.png") [ ](/forum/attachment/40991?download=1 "...ionReport2.png")
- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationRates.png](/forum/attachment/40992) ](/forum/attachment/40992 "...ationRates.png") [ ](/forum/attachment/40992?download=1 "...ationRates.png")

Last edit: 9 years 1 month ago by [renem](/forum/user/47055-renem "View renem's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86574
- Thank you received: 14318
-
-

9 years 4 weeks ago [\#280840](#280840) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280840 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

HI,

Thanks, but that's not what I asked. What I need is a screenshot of the details of the order where you have that coupon. You can blur the user data. What I need to see is the product price, tax, the additional area prices, etc.
Please provide the information we ask so that we can move forward. It's the third time I'm asking for it. Is there a reason you don't want to provide that ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 3 weeks ago [\#280988](#280988) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#280988 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Nicolas,

No problem just a misunderstandment :

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationOrder1.png](/forum/attachment/41029) ](/forum/attachment/41029 "...tionOrder1.png")

Regards René

- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationOrder1.png](/forum/attachment/41029) ](/forum/attachment/41029 "...tionOrder1.png") [ ](/forum/attachment/41029?download=1 "...tionOrder1.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86574
- Thank you received: 14318
-
-

9 years 3 weeks ago [\#281028](#281028) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281028 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi,

Ok, that's great thanks.
Now, can you tell me if the "show taxed prices" setting is activated or not in your HikaShop configuration ?
And also, can you go in the menu System&gt;Mass actions, create a new mass action on the "order" data with a filter on the "order column" order_id with the value 1616 and with an action "display the values" with the order_tax_info, order_discount_price and order_discount_tax columns check and click on the "process" button ?
That will give you a table with data directly from the database for that order.
That will help us better understand the situation if you can provide that data for that order.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 3 weeks ago [\#281051](#281051) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281051 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Nicolas,

**Tax settings:**

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationConfiguration.png](/forum/attachment/41043) ](/forum/attachment/41043 "...figuration.png")

**And the results of the mass action**

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationMassactions.png](/forum/attachment/41044) ](/forum/attachment/41044 "...assactions.png")

Regards René

- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationConfiguration.png](/forum/attachment/41043) ](/forum/attachment/41043 "...figuration.png") [ ](/forum/attachment/41043?download=1 "...figuration.png")
- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationMassactions.png](/forum/attachment/41044) ](/forum/attachment/41044 "...assactions.png") [ ](/forum/attachment/41044?download=1 "...assactions.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86574
- Thank you received: 14318
-
-

9 years 3 weeks ago [\#281105](#281105) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281105 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi,

Ok, thanks !

You need to use that line of code:
$tax_amount = $taxes_info-&gt;tax_amount + $v-&gt;order_discount_price - $v-&gt;order_discount_tax;

And you also have to change the line:
$database-&gt;setQuery('SELECT order_tax_info, order_currency_id FROM '.hikashop_table('order').$filters);

to:
$database-&gt;setQuery('SELECT order_tax_info, order_currency_id, order_discount_price, order_discount_tax FROM '.hikashop_table('order').$filters);

in that same file.
That should normally work fine after that.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 3 weeks ago [\#281387](#281387) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281387 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Nicolas,

I have modified the code as suggested, but the difference remains.

The totals of VAT and amounts still differ from sales with the difference of the coupon amount.

In my opinion, only the coupon amount of the totals must be added to the VAT summary, then it is correct.

Kind regards René

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

9 years 2 weeks ago [\#281414](#281414) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281414 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hello,

> In my opinion, only the coupon amount of the totals must be added to the VAT summary, then it is correct.

Can you please clarify what you mean ?

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 2 weeks ago -  9 years 2 weeks ago [\#281606](#281606) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281606 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Nicolas,

It should be true that total sales are equal to VAT + Total sales?

That is not the case, the difference is exactly the coupon value. The coupon will also be subject to VAT, so it must be added (in this case with the 6% VAT)

Vat rates

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationRates&#95;2017-11-01-2.png](/forum/attachment/41162) ](/forum/attachment/41162 "...17-11-01-2.png")

Admin total

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationReport&#95;2017-11-01-2.png](/forum/attachment/41163) ](/forum/attachment/41163 "...17-11-01-2.png")

Coupon tax

[ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationDiscounts.png](/forum/attachment/41164) ](/forum/attachment/41164 "...nDiscounts.png")

When I compare these values, difference is exactly the coupon value: (admin total) € 2.776,25 - (tax total) € 2779,64 = € 3,39

Kind regards René

- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationRates&#95;2017-11-01-2.png](/forum/attachment/41162) ](/forum/attachment/41162 "...17-11-01-2.png") [ ](/forum/attachment/41162?download=1 "...17-11-01-2.png")
- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationReport&#95;2017-11-01-2.png](/forum/attachment/41163) ](/forum/attachment/41163 "...17-11-01-2.png") [ ](/forum/attachment/41163?download=1 "...17-11-01-2.png")
- [ ![PuptrainingspecialistHondentraininghondentrainerDickStaalAdministrationDiscounts.png](/forum/attachment/41164) ](/forum/attachment/41164 "...nDiscounts.png") [ ](/forum/attachment/41164?download=1 "...nDiscounts.png")

Last edit: 9 years 2 weeks ago by [renem](/forum/user/47055-renem "View renem's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

9 years 2 weeks ago [\#281617](#281617) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281617 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hello,

But Nicolas proposed you a patch to add that coupon value to adjust the total :

> You need to use that line of code:
> $tax\_amount = $taxes\_info-&gt;tax\_amount + $v-&gt;order\_discount\_price - $v-&gt;order\_discount\_tax;

You seems to have the solution :

> In my opinion, only the coupon amount of the totals must be added to the VAT summary, then it is correct.

So, can you explain me why that patch is not the right one ?

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 2 weeks ago [\#281696](#281696) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281696 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Jerome,

No idea all I do is compare the total sales with the total in the VAT calculations. And then I see a difference. The difference appears to be the amount of the coupon value paid 1 times, but that number of value can also be coincidence. But in any case, the sum of the sums should not show a difference.

Regards René

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86574
- Thank you received: 14318
-
-

9 years 2 weeks ago [\#281821](#281821) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281821 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi,

I'm sorry but it's still not clear.
Do you mean that you've made the last changes I told you to do but you didn't see any difference in the calculations before/after the change ?

If so, I don't see how that's possible. And to look deeper into it, I guess we'll have to ask you a backend access and a FTP access to your website so that we can look at the data, check the changes and debug if necessary so that we can directly test the patch.
Could you provide these along with a link to this thread via our contact form ? [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html)

If not, then it means that the patch is correct and we can close this thread. so I'm not sure why you're explaining again the situation since we already know the difference comes from the coupon value ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[renem](/forum/user/47055-renem "View renem's Profile")**
- [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") Topic Author
- [ Offline](/forum/user/47055-renem)

Less More

- Posts: 198
- Thank you received: 7
-
-
- [](http://www.muldermedia.nl)
-

9 years 2 weeks ago [\#281830](#281830) by [renem](/forum/user/47055-renem "View renem's Profile")  Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[Deference between total order, and overview Tax Rules totals](/forum/40-taxes/892401-deference-between-total-order-and-overview-tax-rules-totals#281830 "-- HikaShop version -- : 3.2.0 -- Joomla version -- : 3.8.1  Hi,  Please can you take a look at this YouTube movie my client made to display the Coupon value problem?  The difference between this two values is exactly the coupon code value. How can we sorted this out?  Kind regards René")*

Hi Nicolas i have send you a mailform.

Thanks for your patience and good care.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQwLXRheGVzLzg5MjQwMS1kZWZlcmVuY2UtYmV0d2Vlbi10b3RhbC1vcmRlci1hbmQtb3ZlcnZpZXctdGF4LXJ1bGVzLXRvdGFscz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.170 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
