Import by Scenario Error

  • 16 August 2021
  • 2 replies


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 16 August 2021, 21:24

View original

2 replies

Userlevel 7
Badge +15

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.


Userlevel 3

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.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved