I have succesfully imported all my customers and suppliers.
I am now trying to import invoices. I get the following error message for each row of infomation.
[ERROR] Row 2: Missing field 'VAT Treatment ID'
I have got a column headed VAT Treatment ID> I have inserted the number 1 into each row. I have formatted the cells as a number and integer but with no success.
Any thoughts.
[
Hi Robert,
Can you please email us your CSV file? We can then investigate the problem further...
Cheers,
Did you find out what was wrong as I have exactly the same problem
Yes - the import process is case-sensitive, so you will need to ensure ensure the field is spelt "VAT Treatment ID" (not "Vat Treatment ID")
Thanks, that's fixed it!
Hi Michael,
Glad to hear that. We'll fix this problem in the next release by making the field header case-insensitive.
Cheers,
I get the error messages invalid name, is the name field case sensitive?
Hi Danny,
No, the name field is not case-sensitive when importing invoice data.
When you import invoices the customer must already exist in the system. In your case it sounds like you are trying to import invoices whether there is not already a customer with the same name as on the invoice.
Regards,