Categories
View Replies (5)

Resolved VM - advanced order - tax paid on shipping missing

  1. loppis
    loppis
  2. RO CSVI
  3. Saturday, 03 March 2018
  4.  Subscribe via email
Hi!

I need to export a csv with the following information :

Order ID
Order Number
Date Ordered
Customer Email
Order Total
Tax Total

I have set the following fields to achieve this :

virtuemart_order_id
order_number
created_on
email
order_total
order_tax

I have everything working just fine, except that "order_tax" does not include the tax paid for the shipping cost. It only gives the tax paid for the actual products. I have tried different fields, but nothing gives me the total tax amount correctly.

Any ideas? I'm based in Sweden, and our VAT rate is 25%. For now, I calculate it manually in excel, but it really would be helpful to have the exact amount already available.

Truly grateful for any ideas here ;).

Thanks!
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
yes, order_tax includes only the tax amount of ordered products, you need to use order_billTaxAmount field which includes order_tax ,order_shipment_tax and order_payment_tax.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
loppis
loppis
Accepted Answer Pending Moderation
Perfect, thanks! It gives the correct amount. I'm surprised I didn't see that earlier.

However, there is a small problem. I have set my decimal separator to "," och 2 decimals. In the order_billTaxAmount field I still get "." as the separator and 4 decimals.

The "." as the separator is the biggest problem because in Sweden the separator is ",", and Excel is reading the field as a text field if it's a "." instead of ",".

I'd appreciate if you could share any ideas as to why this is happening.

Thanks in advance!

Best regards

Peter
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Peter,
Can you load the attached patch file and check if order_billTaxAmount field uses the decimal separator as set in the template?

patch_vm_order_2018_03_05.zip
Attachments (1)
patch_vm_order_2018_03_05.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
loppis
loppis
Accepted Answer Pending Moderation
Wow, that worked :). Thanks for the amazing support! Good job :).

Case solved! :)

Have a nice day

Peter
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Peter,
Glad to know it worked. Please leave us a review on Joomla Extension Directory :)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!