Home » Deeper in to NetSuite » Available Quantity of Kit/Package Items

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:

CTA - NetSuite Homepage Banner

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.

Get In Touch With Our Experts


    Get In Touch With Our Experts

      I have read and agree to the Privacy Policy of Folio3
      I agree to be contacted by Phone or Email by Folio3

      Get in touch with the

      Award-Winning

      End-to-end NetSuite Servicing Agency

      Tell us how may we assist you!