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

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.

ContactUs.com