Skip to main content
Solved

Import by Scenario Error

  • August 16, 2021
  • 2 replies
  • 1218 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.

 

View original
Did this topic help you find an answer to your question?

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • 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
  • 29 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings