All null/empty fields must be converted to 0.
ID numbers must be in General format - no numbers or text
make sure all values for quantities are formatted as numbers
if error message for number stored as text, change so that this error message no longer occurs.
Everything formatted as general. Shows up in ArcCatalog as Double