Import Itemdetails


I’m trying to import item details form, first I tried to import invent table the following error showed up.


May I know how could I import the tables InventItemPurchSetup?


It seems you have two problems there:

  • You’re trying to import a record without any ItemId
  • You already have such a record in database

Either your input data don’t contain correct item IDs, or you have a problem in the code you use for import.

In addition to fixing the import, make sure you remove the invalid record from database (there shouldn’t be any InventItemPurchSetup record without ItemId.

If you’re using custom code to insert records, make sure you call validateWrite() and isert data only if it returns true.