- Posts: 96
- Thank you received: 4
Calculation error in invoices -version 1.51
15 years 3 months ago #17903
by chris711
Calculation error in invoices -version 1.51 was created by chris711
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
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.
15 years 3 months ago #17951
by nicolas
Replied by nicolas on topic Re: Calculation error in invoices -version 1.51
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.
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.
15 years 3 months ago #18459
by aknot242
Replied by aknot242 on topic Re: Calculation error in invoices -version 1.51
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
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.
15 years 3 months ago #18479
by nicolas
Replied by nicolas on topic Re: Calculation error in invoices -version 1.51
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.
15 years 3 months ago #18489
by Rickhavoc
Replied by Rickhavoc on topic Re: Calculation error in invoices -version 1.51
would installing this over the current version remove changes to the display -> view?
Please Log in or Create an account to join the conversation.
15 years 3 months ago #18490
by nicolas
Replied by nicolas on topic Re: Calculation error in invoices -version 1.51
No.
Please Log in or Create an account to join the conversation.
15 years 3 months ago #18502
by aknot242
Replied by aknot242 on topic Re: Calculation error in invoices -version 1.51
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
Thanks
Please Log in or Create an account to join the conversation.
15 years 3 months ago #18503
by nicolas
Replied by nicolas on topic Re: Calculation error in invoices -version 1.51
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.
$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.
15 years 3 months ago #18504
by aknot242
Replied by aknot242 on topic Re: Calculation error in invoices -version 1.51
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!
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.
15 years 3 months ago #18505
by nicolas
Replied by nicolas on topic Re: Calculation error in invoices -version 1.51
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.
15 years 3 months ago #18522
by aknot242
Replied by aknot242 on topic Re: Calculation error in invoices -version 1.51
Replacing the line in the order_status_notification.html.php fixed the problem.
Thank you!
Daniel
Thank you!
Daniel
Please Log in or Create an account to join the conversation.
Time to create page: 0.207 seconds