Error Messages when importing purchase invoices

Support
1

HI,

Im trying to import purchases invoices and all tranactions are being rejected, See below for error message. What am i doing wrong.

We were unable to import any purchases to your account.
Error at line 1: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 2: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 3: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 4: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 5: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 6: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 7: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 8: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 9: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 10: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 11: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 12: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 13: Conversion from type ‘DBNull’ to type ‘Double’ is not valid.
Error at line 14: Conversion from type ‘DBNull’ to type ‘Double’ is not valid

2

I’ve referred this to a developer to see what’s triggering the error. Will report back as soon as I know more.

3

I am advised that your CSV file contains a number of columns with no data, it looks like you have tried to map this columns and this is triggering an error. Our program should handle this more gracefully, rather than throw those particular errors.

You can solve this simply by not mapping those empty columns, it is not necessary to map every column.