Import failed. Error: Error converting data type nvarchar to float.

[Magyours]

Hi There,

I'm having the above error when uploading a standard purchase order by using the template. There isn't any comma nor other punctuation symbols in the file & my date format is yyyy/mm/dd. Has anyone encountered such error and what was the way to move forward with the upload?

Thanks for your reply

[ChrisG]

To move forward, you will need to find where you have some text data in your input file in a location where numeric data is expected. Unfortunately the error message you're seeing probably doesn't give a very specific indication of where the problematic data is, but you can trust the error as being a reliable indication that there is problematic data there somewhere.