Resolved 2 TAX percentage in export?

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.

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.

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.

patch_vm_ordertax_2016-01-08.zip

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.

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% 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?

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.