Hello all,
I thought it will be beneficial to share the below yesterday drove me crazy. We have configured the Inventory Code to be 20 unicode character. We imported the stock items without any issues. When we tried to import our opening inventory we started receiving some wierd errors like “the record couldn’t be imported due to an error in the next record” and this would repeat until the very last record in the import file. We tried importing through the upload button in “IN Purchase” but there we received an error that “Inventory ID can not be null” and we had no null value in the file.
Long story short I did a lots of trial and error to figure out the errors all are misleading. What has happened we had “/” and “\” in our part numbers. Although we had successfuly imported them as Stock Items but the other import referencing them was failing to import. When we changed these two charcters to “-” all worked out just fine. There could be other special characters potetially causing problem.
Just wanted to share this with community.
