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.