Our organization is in the process of switching to Acumatica. I'm trying to import stock item profiles from our currant system, and when the import reaches half the sheet, the following error appears, input string was not in a correct format.
Best answer by Naveen BogaView original
@sburger Based on the error, I can say it is related to length issue.
For instance, if Acumatica is allowing us enter only 30 characters but we are trying to insert/update that field more than 30 characters, then Acumatica system will throws this error.
You should be able to tell which record has the data error in that on the import scenario screen you will get an error in the error column. If you sort the import scenario by error message descending, it will show you the record that has the error. And the data will be there too.