I'm at absolute wits end here. I know that the CSV import is always trial and error (and is extremely poorly documented), but I'm not sure what else to try at this point. For reference, here is what my file looks like:
The fields are:
- External ID
- Item Name (not used in the import)
- Lot Number
- Qty to adjust
- Internal ID of item
Here is what my mapping looks like:
Here is the mapping:
- Inventory Adjustment Account (hard coded)
- Inventory Location (hard coded)
- Inventory Customer (hard coded)
- External ID maps to the ExtID field in my file (just a unique number as a primary key)
- Inv. Adjust Subsidiary (hard coded)
- Inv. Adjust Date (hard coded)
- Inv. Adjust Qty maps to the Qty field in the file
- Inv. Adjust Item maps to internalid in file (and yes, it is selected as internalid)
- Receipt Inventory number maps to "Serial" in my file.
...and every row fails with this error:
Help tells me that the "You cannot create an inventory detail for this item." means that I'm trying to add a serial/lot number to an item that isn't set up. All of these items are set up as Lot Numbered Inventory items.
Note that I can manually create an inventory adjustment record to do this, but it is extremely time consuming because I have to click in to each item to manually add the lot number. This is a file that I am getting daily that if I can suck in via CSV will save me quite literally dozens of hours per month.
Anyone have any ideas?