Saved Search > Kit/Item Group Quantity On Hand per Location

Scenario

Create a Saved Search to show Kit/Item Group Quantity On Hand per location.

Solution

Kits and Item Groups do not keep track of their quantity on hand unlike the Assembly Items. Item count of these types are dependent on the available quantity of the members or components. If a Kit or an Item Group is sold, the quantity of the components or members are automatically deducted.

To show the available quantity on hand of Kits/Item Groups, create a save search that will use the minimum quantity available of its components or members:

1. Navigate to Lists > Search > Saved Searches > New > Item
   
   

2. Under Criteria subtab:

• Type: is any of Kit/Package, or Item Group

• Inactive: is False
  
  

3. Under Results subtab:

• Name | Summary Type: Group

• Formula (Numeric) | Summary Type: Minimum | Formula: (NVL({memberitem.locationquantityavailable},0))/{memberquantity} |  Summary Label: Available Qty

• Member Item : Inventory Location | Summary Type: Group

• Member Quantity

• Member Item : Name
  
  

4. Rename the Search
   
   

5. Click Save and Run