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?
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
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
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?
Excelsheet
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
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 :-)
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
Hello,
The patch is ready for Tax reports. Please load the patch and let me know how it goes.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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}}
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
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
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
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% TaxWhen 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
Thanks Tharuna, after setting taxes to VatTax it worked perfectly in the newly generated orders, great addon.
Regards
The patch does not load?
The patch does not load?
I uploaded it manualy and it works PERFECT!!!
GREAT JOB!
:) i am verry happy :)
I am still struggling to create a good salesreport for my taxes.
Does anyone have an example for me that i can use?
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
Log in to reply to this topic.