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.

It's only fair to share...Tweet about this on TwitterShare on LinkedInShare on Google+Share on Facebook
Amount Field in Search Column
Prevent Usage Limit Exceeded Exception In Client Script

Zeeshan Ahmed

Comments

  1. 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

  2. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

five × 4 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

ContactUs.com