Skip to main content

Subitems appear to be inactive by default. Is there a way to mass enable inventory subitems all at once?

 

I get this error when trying to use the inactive subitems in a Sales Order:

“the default value of the subitem segment is inactive”

I’ll answer my own question. I did an insert from InventoryItem into INSubItemSegmentValue, where I hardcoded the CompanyID, SegmentID and Value fields to be the same as an already active Subitem (I only wanted subitem value 0 to be active for all items). I also excluded any subitems that were already active.

 

This is the Sql query I used...

  Insert INTO INSubItemSegmentValue(CompanyID, InventoryId, SegmentId, Value)
  select 2,InventoryId,1,0 from InventoryItem where InventoryID NOT IN (select InventoryId from INSubItemSegmentValue)


Reply