Exporting VAT Numbers with Orders

[niall08]

At the minute I'm storing a user's VAT Number in the Comments field in the ac_Users table..

I need to export this data when exporting orders - how do I do that?

Additionally, is there a way of filtering the data - e.g. users based in Europe??

[mazhar]

At the minute I'm storing a user's VAT Number in the Comments field in the ac_Users table..

I need to export this data when exporting orders - how do I do that?

There is nothing out of the box to export users information with order export. One way could be to first export order and then export users. Then write some custom code that manipulate both order and users CSV's and generate your desired CSV by using user name information available with order for mapping between orders and users.

Additionally, is there a way of filtering the data - e.g. users based in Europe??

Use customized user download option and select the selected user option on dataport. Finally specify the country for which you want to download users.

[niall08]

Thanks Mazhar

My understanding was that AC is supposed to be an international tool - the storage of VAT data and the export of this data in relation to orders is IMPERATIVE to EU businesses for accounting purposes, but the current iteration of AC doesn't look like it can't handle this..