I get the following error when I try to prepare the import of stock items via an import scenario I created.
Value was either too large or too small for a Decimal
The file I need to import is about 23k rows. I copied the first 14 rows from the original file with the same headers and those 14 prepared and imported just fine. I think it has to be some sort of formatting error but I cannot figure it out. Has anyone else had this issue and was able to resolve it?
Thanks,
Jess
Best answer by wfilipiak67
I have found that with this error message, there is usually a field in excel that is not formatted as text but contains a large number.
Like an item code that is 123456789012
The excel cell might be displaying the number in exponential notation
+3
I have found that with this error message, there is usually a field in excel that is not formatted as text but contains a large number.
Like an item code that is 123456789012
The excel cell might be displaying the number in exponential notation
I’ve got the same problem since updating to 2021 R1.
+7My issue happened to be a reference code from another system in the format of an exponential expression 9508e triggered Acumatica to think this was an extremally large number resulting in an error.
+13
See below-attached screenshot, if your excel contains invalid data it throws an error Value was either too large or too small for a Decimal
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.