Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Search to show quantity of assemblies/kits that can be built based upon component inventory levels
We are attempting to create a saved search to show how many of our assembly items or kits we have sufficient stock in inventory to build. Here is what we currently have set for the saved search:
Criteria:
Type - Assembly/Bill of Materials, Kit/Package
Member Item : Inventory Location - Desired Location
Matrix Item - False (as we build matrix sub-items, not matrix items)
Inactive - False
Results:
Name - Group
Description - Group
Member Item
Member Quantity
Member Item : Location on Hand
Formula (Numeric) trunc(nvl(to_number({memberitem.locationquantityonhand}),0)/to_number({memberquantity}),0) - Minimum
The issue we are having is we have several assembly items built with sub-assembly items. Those final assemblies are not showing correct numbers. The way we have it setup now, it will show the quantity that can be built as the quantity of a sub-assembly that is in stock.