I needed to get a list of the total number of kits on hand, which meant that my saved search had to look at the available component items and see which one had the lowest number on hand, and use that number as the maximum number of kits we could build. Makes sense. The only problem is when a kit contained a non-inventory item, which doesn't list any that are on hand. NetSuite interprets this as zero. Therefore, by default, the maximum number of kits will always be zero if a kit contains a non-inventory component item. There are always an abundance of our non-inventory items so I need to somehow exclude them from the search. Any suggestions?

can you entirely exclude your NII from the search results? as these results are ignored

Do a case when statement for the MIN value that excludes non-inventory items.