Mass enable subitems?

  • 1 October 2021
  • 1 reply

Userlevel 6
Badge +5

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”


Best answer by rosenjon 1 October 2021, 08:32

View original

1 reply

Userlevel 6
Badge +5

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)


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved