Available Quantity of Kit/Package Items

09 Apr 2014

Zeeshan Ahmed

4 Comments

Some time customer would like to display the total available quantity of Kit/Package items through saved search. A simple search shows empty available quantity for Kit/Package item because member items are associated with Kit item and the quantity of Kit item depends on the quantity of its components. The solution is here:

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

2. On Criteria > Standard > Filter >

i. Type = Kit/Package

ii. Inactive = false.

3. On Results > Columns > Fields: Name

i. Name

– Set Summary Type = Group

ii. Formula (Numeric)

– Set Summary Type = Min

– Set Formula = nvl(({memberitem.quantityavailable}/{memberquantity}),0)

6. Save and Run.

It's only fair to share...

Tags: Available Quantity, Formula (Numeric), Items, Kit/Package, Member Item Quantity, Saved Search

Zeeshan Ahmed

Comments

Tom Says: July 21, 2016 at 1:02 am

Thank you, this works great. However we have multiple inventory locations and I would like to have the above code only pull the value from only one location if you would be able to help. Thank you.

- Zeeshan Ahmed Says: July 21, 2016 at 10:56 am
  
  Hi Tom,
  
  Please add filter as MemberItem.InventoryLocation in criteria for fetching quantity from specific location.
  
  Thanks,
  Zeeshan
  
Tom Says: July 21, 2016 at 5:59 pm

Thanks for quick reply, I have tried that but it still pulls inventory from across all locations instead of the one specified.

Here is what I have:
CRITERIA TAB = Use Expressions
( NAME (KIT NAME) is ____ AND
MemberItem: Inventory Location is ____ )

RESULTS TAB = I have your formula
AVAILABLE FILTERS = blank

- Zeeshan Ahmed Says: July 25, 2016 at 12:33 pm
  
  Please use this formula nvl(({memberitem.locationquantityavailable}/{memberquantity}),0) as column along with your filters. I have replaced the column quantityavailable to locationquantityavailable. You would be able to get your desire result. Thanks.