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”
Answer
Mass enable subitems?
Best answer by rosenjon
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)
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.