Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
NSC | Saved Search for Tracking Expiring Lots
Scenario
You are an inventory manager who wants to proactively monitor and manage inventory with upcoming expiration dates to minimize waste. You aim to create a saved search that shows lots with expiration dates within the upcoming week and their respective bin locations.
Solution
- Navigate to Lists > Search > Saved Searches > New
- Select Inventory Balance search
- Enter a search Title
- On the Criteria tab > Standard subtab, add filters as needed, e.g:
- Item : Inactive is False
- Item : Is Lot Numbered Item is True
- Inventory Number : Expiration Date is within next week
- On Hand is greater than 0
- On the Results tab, add the columns such as:
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!
Tagged:
0