09 Apr 2014
Zeeshan Ahmed
4 Comments
Available Quantity of Kit/Package Items
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.
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.
Hi Tom,
Please add filter as MemberItem.InventoryLocation in criteria for fetching quantity from specific location.
Thanks,
Zeeshan
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
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.