Hi All, I need some help understanding an issue I ...
# csvimports
v
Hi All, I need some help understanding an issue I am consistently facing during an Item Fulfillment CSV import. I receive the following error: Invalid issueinventorynumber reference key "16727839". Here is what I have already checked before posting: • The lot number 16727839 is active and belongs to the correct item. • The lot exists in the same location and same bin used in the import. • There is available quantity under that lot, so quantity is not the issue. • I verified the CSV file format → no special characters, no hidden spaces, no encoding issues. • I confirmed the lot number is not being auto-formatted by Excel (e.g., stored as number/text/scientific). • Field mapping in the Import Assistant is correct and points to Issue Inventory Number (Lot Number). Even after validating all these points, the import still throws the same error. So the usual causes (inactive lot, wrong location/bin, insufficient qty, formatting) do not apply here. Has anyone experienced a similar issue or knows what additional validation NetSuite performs on issueinventorynumber during fulfillment imports? Any guidance or suggestions would be greatly appreciated. Thanks in advance!
r
I would try creating the Item Fulfillment manually in the UI to check if the Serial Number is available or if you need to provide additional information for the import to work.
r
I've not tried an Item Fulfillment import ever, but I do know I've torn my hair out before on CSV imports before realizing I had forgotten to change that little selector (via the pencil) on the mapping screen to Internal ID from whatever the default is. Do you have the option on Item Fulfillments to import using the lot name and you didn't change it to internal ID? If that's the case, it's looking for a lot named 16727839 and not that internal ID. That scenario will still throw "invalid reference key." I assume that's literally the first thing you checked and is covered by your last bullet, but you didn't call that out specifically, so just covering bases.