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??
Exporting VAT Numbers with Orders
Re: Exporting VAT Numbers with Orders
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.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?
Use customized user download option and select the selected user option on dataport. Finally specify the country for which you want to download users.Additionally, is there a way of filtering the data - e.g. users based in Europe??
Re: Exporting VAT Numbers with Orders
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..
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..