Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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.