Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why do I get an invalid VAT number, 1E+08, on the Submission Summary of my Comma Separated Variable (CSV) uploaded file?

April 26, 2017comma csv invalid separated submission summary VAT

0

Posted

Why do I get an invalid VAT number, 1E+08, on the Submission Summary of my Comma Separated Variable (CSV) uploaded file?

1 Answer

0

Posted

When you open a CSV file in Excel some fields are converted to scientific format, for example 1E+08. When the CSV file is then saved the fields are saved as scientific notation which is not recognised by the EC Sales List (ECSL) validation process. To overcome this problem you may wish to consider using the template provided. This can be accessed from the Bulk Upload page. For more information on CSV files see the Submitting ECSL declarations by CSV page.