Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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!