Calculation error in invoices -version 1.51

  • Posts: 96
  • Thank you received: 4
  • Hikashop Business
13 years 5 months ago #17903

Hi Nicolas,

After upgrading our Essential software yesterday we are seeing errors in the invoicing calculations and also
the orders are coming through paypal without product information listings, just a total amount.

Example:
SUMMARY OF YOUR ORDER


Name Unit price Qty Total before Tax

Yellow Detached Daddy Long Legs Dry Fly on a size 10 hook £ 0.31 5 £ 1.55

Detached Daddy Long Legs Red Dry Fly on a size 10 hook: 10 £ 0.29 5 £ 1.45

Natural Detached Daddy Long Legs Dry Fly: 10 £ 0.29 5 £ 1.45

Brown Detached Daddy Long Legs Dry Fly: 10 £ 0.29 5 £ 1.45

Barbless Daddy Long Legs White Tail: 12 £ 0.30 48 £ 14.40

Shipping method : £ 1.95

TOTAL without VAT : £ 46.63

TOTAL with VAT : £ 26.33

In this case Total without VAT should be £22.25 - and with VAT the Total should be £26.31 (the shipping method is not subject to VAT so tax at 20% is calculated on £20.30)

Please can you advise.

Thanks
Chris

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 5 months ago #17951

Hi,

We uploaded a new build of the 1.5.1 version which should fix that problem. Please download it again and install it over your current version.

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

  • Posts: 6
  • Thank you received: 0
13 years 5 months ago #18459

I am also seeing an issue similar to this, but i'm running the latest build of Essential, which I downloaded yesterday.

For some reason, on the confirmation email, the ORDER CREATED email shows this:

Of Iron and Clay CD $10.00 1 $10.00
Shipping method : $3.00
TOTAL without tax : $13.00
TOTAL with tax : $13.00


but, the ORDER CONFIRMATION email shows this:

Of Iron and Clay CD $10.00 1 $10.00
Shipping method : $3.00
TOTAL without tax : $23.00
TOTAL with tax : $13.00

I've highlighted the problem area with the total without tax (VAT). It looks like that amount is $10 more in this second email.

Can you help?

Thanks,
Daniel

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 5 months ago #18479

Please download again HikaShop on your order details page on our website and reinstall it with that new install package. That should fix the problem.

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

  • Posts: 156
  • Thank you received: 0
13 years 5 months ago #18489

would installing this over the current version remove changes to the display -> view?

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 5 months ago #18490

No.

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

  • Posts: 6
  • Thank you received: 0
13 years 5 months ago #18502

I reinstalled as you suggested. Still having the issue. Is there any code I can dig up for you in order to verify that I have the correct install?

Thanks

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 5 months ago #18503

If you edit the file media/com_hikashop/mail/order_admin_notification.html.php you should have a line like that in it with the correct version:
$tax = $data->cart->order_subtotal - $data->cart->order_subtotal_no_vat;

Since you still have the problem, it's likely that you have something like that instead:
$tax = $order->cart->order_subtotal - $data->cart->order_subtotal_no_vat;

If you change it that should solve the problem.

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

  • Posts: 6
  • Thank you received: 0
13 years 5 months ago #18504

The one in my order_admin_notification.html.php looked like the correct code: $tax = $data->cart->order_subtotal - $data->cart->order_subtotal_no_vat;

For grins, I wandered over to the order_status_notification.html.php file, and I found this line in there:

$tax = $order->cart->order_subtotal - $data->cart->order_subtotal_no_vat;

Since it is in the customer notification email that i'm seeing the problem in (not the administrative email), is the above line the culprit?

Thanks!

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 5 months ago #18505

Ah yes. It's the status email file you should change. Sorry for the typo.

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

  • Posts: 6
  • Thank you received: 0
13 years 5 months ago #18522

Replacing the line in the order_status_notification.html.php fixed the problem.

Thank you!

Daniel

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

Time to create page: 0.093 seconds
Powered by Kunena Forum