wrong total price exclusice tax in admin email

Hi,
when order is finished 2 emails are sent:

one to the client
one to the admin

the corresponding views are not modified by me (original version)
the views seems for me to access the same data

the total value in client email is correct calculated.
the total value in admin email is wrong.

the difference comes by wrong tax calculation of the shipping price in some other place of HS.
(Liefermethode: price 9,48 is incl. tax)

here is the client email

Hi,
just for curiosity.
the admin email was sent 09:00:47 with wrong total_price_without_tax
the client email was sent 09:00:48 with correct total_price_without_tax

could it be that some calculations were not finished and the admin email process has seen other values from the database, than the client email process? I don't know if there is record locking forseen in the software.

Hi,

That's indeed something we found out recently and already fixed on our end. You can correct the problem by changing the file media/com_hikashop/mail/order_admin_notification.html.php by the one in the archive enclosed.

Hi Nicolas!

Thank you for the prompt answer, but this would have been to easy. I wrote it has nothing to do with the view of the emails. Maybe I didn't explain it clearly.

Name Einzelpreis Menge Summe
Bluetooth Transmitter 238,80 € 1 238,80 € inkl. VAT correct
Liefermethode : 9,48 € inkl. VAT correct
Gesamtsumme exkl. MwSt.: 208,48 € exkl. VAT WRONG
Gesamtsumme inkl. MwSt.: 248,28 € inkl. VAT correct

All taxes are 20%

The failure is in : Gesamtsumme exkl. MwSt.: 208,48 €
248,28 divided by 6 times 5 is 206,90

Liefermethode : 9,48 € is the shipment price inclusive tax
price without tax is 7,90
difference is 1,58

this is exact the amount your calculation is wrong.

This failure is done not in the email views, it has to do with one of your controllers or helper functions.
As I explained earlier the admin email is sent first getting wrong data from the system (database, variables what ever), with wrong calculation.
Next is sent the client email with correct calculation.

Somewhere in your system you take for the shipment instead of the excl. price the inkl. price to calculate the "Gesamtsumme exkl. MwSt.: 208,48 €".

I hope I explained it more clearly now.

best regards
Michael

Please try to replace the line
$tax = $data->cart->order_subtotal - $data->cart->order_subtotal_no_vat;

by
$tax = $data->cart->order_subtotal - $data->cart->order_subtotal_no_vat + $data->order_discount_tax + $data->order_shipping_tax;

in that file. The shipping and discount taxes are apparently not taken into account in the display of the price without tax in the admin email.

Hi Nicolas!

Thank you very much for your support.
Now it works correct.

hi, sorry to open again this topic, but I find a quite important mistake which is a little bit different than michael_steiner's one :

at the end of order, after paiement, two mails are send :

- one for the admin with (first amount of items without VAT, amount of VAT only and last line is the total amount)

- a second mail is sent to the client for a recap and the same information should appear, but that's my prob, amount of items is ok, total amount is ok, but, the amount of the VAT only in wrong !

here's a sreenshot of an email sent to a client :



corrects informations should appears (which are rights on the mail admin receive) :

- total for each items without VAT : 16,72 € ok
- shipping (never VAT on that) 5 € ok
- total without VAT 38,44 euro (it appears with 40€ more)
- total amount with tax and shipping : 45€ ok

what is weird is that total general is correct ! and the mail sent to admin is all ok...

thanks a lot if you can spend a minute to help me...

Please download the new version on our website and update your website. That should correct the problem.