CSV Import on Inventory Adjustment Throws an Error: "You cannot create an inventory detail for this item"

Written by
Junica Ann Capili
Published on
January 29, 2024 at 2:51:32 AM PST January 29, 2024 at 2:51:32 AM PSTth, January 29, 2024 at 2:51:32 AM PST

Scenario:

When importing a CSV File to create or update anInventory Adjustmentrecord, an error: "You cannot create an inventory detail for this item" can be encountered when the item you are importing is not aSerial/Lot Numbered Itemor does not use bins.

Solution:
Make sure that in the CSV file, if the item is notSerializednorLot Numbered, theSerialorLot Numbercolumn must be empty.

Note:Importing an Inventory adjustment containing both Lot Numbered and Regular Inventory items using a single file may cause problems due to the mapping of fields. We recommend customers to use multiple link files instead. User may refer to SuiteAnswers ID65468 for detailed steps.