1. plomp47
  2. RO CSVI
  3. Wednesday, 23 December 2015
  4.  Subscribe via email
Hello,

I want an export with all my saleorders in it, but with de tax-total split up if there are more than 1 tax-percentage used in the order. Because i work with 6% tax and 21% tax products. (Holland)

The only field i could find is: order_billTax
Result: {"2":{"virtuemart_calc_id":2,"calc_name":"6% BTW","calc_value":"6.0000","result":0.815039999999999},"1":{"virtuemart_calc_id":1,"calc_name":"21% BTW","calc_value":"21.0000","result":12.45265812}}

Both tax-values are present, but i only want these results in separate collums.

Is this posible?
Accepted Answer Pending Moderation
Hello,
We dont have the option of having separate columns for Tax results. However You can create your own override using Override import/export routine documentation to do so.
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
Accepted Answer Pending Moderation
I just want to say we experience the same issue. Is a bit of a mess trying to separate different taxes currently.

This is an important thing for accountancy reasons, doesn't matter if is Holland, Spain like our cause or any other country.
Different type of products have different taxes.

In our case is even worst, we have 4% 10% and 21% tax products...

I believe CSVIpro just exports it as VirtueMart stores it in the database, but VM is developed by a german brickhead so please consider improving this aspect.


Regards
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Overrides? i will look in to that, never done this?

It would be great if it was possible, so think about this option.
CSVI Pro then can be used for taxreports in different countries :-)

Comenaranjas; for now i solved my problem with a Excelsheet.
A friend of my build it (i don't knpow Excel that good) but it works for me.
Maybe it wil help you to?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Excelsheet
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
I am working on the patch to get tax reports working and will post it here when its ready, So you can test.
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
Accepted Answer Pending Moderation
Hello,
I am working on the patch to get tax reports working and will post it here when its ready, So you can test.


Great!
I like to test it when it is finished :-)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Thanks guys ill await news,

I know Roland didn't see CSVIpro as an accountancy data export tool but the reality is that since we bought it we are using it for that purpose too and does a pretty decent job.

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
The patch is ready for Tax reports. Please load the patch and let me know how it goes.

patch_vm_ordertax_2016-01-08.zip
Attachments (1)
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. # 8
Accepted Answer Pending Moderation
Hi thanks,

I tested but it returns same result:

{"2":{"virtuemart_calc_id":2,"calc_name":"IVA del 4%","calc_value":"4.0000","result":0.25}}
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello

I had to reinstall CSVIpro to latest stable and the plugin for vm since the patch broke the replacemente rules and didnt export all products,

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
You can check out the tutorial Using Tax as export fields to know on how to use Tax percentage as export fields.
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. # 11
Accepted Answer Pending Moderation
Hello

I just tested but doesnt seem to work, we get all the taxes displayed in our 4% tax.

We have 3 taxes:

4% VatTax
10% Tax
21% Tax

When updating fields in CSVI only the VatTax of 4% was detected, we had to change the 10 and 21% to VatTax and then they appeared.

However when exporting, all the values appear in the 4% column. The 10% and 21% appear empty.

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
I just tested but doesnt seem to work, we get all the taxes displayed in our 4% tax.

We have 3 taxes:

4% VatTax
10% Tax
21% Tax

When updating fields in CSVI only the VatTax of 4% was detected, we had to change the 10 and 21% to VatTax and then they appeared.

This is correct, we have made only VatTax items to be available fields for export.

However when exporting, all the values appear in the 4% column. The 10% and 21% appear empty.

The values are generated and stored in order_billTax field in Virtuemart orders table and when a new order is placed. Changing these fields to VatTax wont update the orders table for entries which are already in there. Can you please try making a new order and send us the debug log if you still see the issue?
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. # 13
Accepted Answer Pending Moderation
Thanks Tharuna, after setting taxes to VatTax it worked perfectly in the newly generated orders, great addon.

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
The patch does not load?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
The patch does not load?


I uploaded it manualy and it works PERFECT!!!

GREAT JOB!

:) i am verry happy :)
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
I am still struggling to create a good salesreport for my taxes.

Does anyone have an example for me that i can use?
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello,

The patch is part of CSVI 6.5.0 so it should be included already if you are running the latest version.

As for your salesreport for taxes, I don't have any ideas here since I don't use it as such. Perhaps someone else has an idea.
Kind regards,

RolandD

=========================
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. # 18
  • Page :
  • 1


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