ItemNumber leading 0s dropped on preview and as well as Inventory transfer destination
GP: 2016 r2
You will need to edit the Excel file so these columns are read correctly. If you add an apostrophe before the number it will be read as text so the leading 0s won’t be dropped.
For example: ‘000789
Thank you! Excel column was formatted as Text and I see green mark on the cells where there is leading 0, but just SmartConnect not reading it correctly. Adding ‘ to 100s of items manually I think is not a feasible option and if I try to use excel formula then it counted as extra char.
I’ll go with importing into SQL table and try to upload, but would be nice if it is addressed in SC.
You won’t need to add the apostrophe to the items in GP, just to the items in Excel, and the driver will read the data correctly. This is an issue with the Excel drivers that SmartConnect uses to read data. All leading zeros need to be preceded by an apostrophe, otherwise the driver guesses what the data type is.
If you would like to submit an answer or comment, please sign in to the eOne portal.