Skip to main content
Solved

Import by Scenario Error

  • August 16, 2021
  • 2 replies
  • 1299 views

Hi,

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 Boga

Hi @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.

 

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • August 16, 2021

Hi @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.

 


Forum|alt.badge.img
  • Jr Varsity III
  • August 16, 2021

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.