Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NSC | Saved Search > Available Serial Numbers
Scenario:
The user wants to create a saved search that lists available serial numbers, excluding those with a "Picked" or "Packed" status.
Solution:
To achieve this, you can create an Inventory Balance type Saved Search.
1. Navigate to Lists > Search > Saved Searches > New
2. Use Inventory Balance type Saved Search
3. In the Criteria subtab > Standard:
-Item: Is Serialized Item is true
-Available is not 0
4. In the Results subtab: (as necessary)
-Item
-Location
-Inventory Number
-On Hand
-Available
-Committed Quantity (Per Serial/Lot Number & Location)
5. Click Save or Save & Run
-----
If you find this information useful, let us know by reacting or commenting on this post!
Niks Blando-Oracle | Ask A Guru?️
Learn how to Refer A Member|Earn the Answer Accepter Badge|Be the Content Creator of the Quarter|Vote for the content you want to see!
Expand your NetSuite knowledge by joining this month'sAsk A Guru Live about Advanced Accounting.RSVPon this event now!