Skip to Content
Former Member
Jun 16, 2015 at 03:32 PM

Error on importing item prices from ODBC


When attempting to import item prices from an odbc source (SQL Server Native client 11), I am able to define the query in step 4 of the import, but upon pressing ‘Next’ I get two errors. Firstly:

Value cannot be null. Parameter name: Argument 'Array' is Nothing.

On pressing OK I then get:

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index.

The mapping screen is then empty.

The fields I am trying to bring in are ItemCode, LineNum (zero for all), PriceList, Price, Currency, BasePLNum. There are no nulls.

The only reference I have found to this error talks about making sure the file is not open, but that is not relevant for ODBC. I have tried to import via a tsv file with the same data without any error. I have also imported other data from the same ODBC source without incident, including items.

Any ideas? API version is 9.10.150, not sure if that could be relevant.