ANS-0123 · SAVED SEARCHES & FORMULAS

How to Filter by Opportunity Status in NetSuite Saved Searches

Learn the most effective methods for creating NetSuite saved searches that accurately filter opportunities based on their current status.

Short answer

To filter by Opportunity Status in NetSuite, the most direct method is to create an Opportunity Saved Search. While transaction searches can also reference opportunity status through related fields like 'Transaction: Status' or 'Transaction: Estimate/Opportunity', an Opportunity Search provides a more straightforward and recommended approach for precise filtering.

Scenario

Users often need to create NetSuite saved searches to track opportunities based on their current status. A common challenge arises when attempting to filter by Opportunity Status, particularly when considering different search types like transaction searches versus opportunity searches.

Solution

To effectively filter records by Opportunity Status in NetSuite, the recommended approach is to utilize an Opportunity Saved Search. This search type directly accesses opportunity-specific fields, including the 'Status' field, allowing for precise filtering based on the opportunity's lifecycle stage. While an Opportunity Search is the most direct method, it is also possible to reference Opportunity Status within a Transaction Saved Search. This can be achieved by leveraging related record fields such as 'Transaction: Status' or 'Transaction: Estimate/Opportunity' to link back to the opportunity's status. However, for clarity and directness when the primary filtering criterion is Opportunity Status, an Opportunity Saved Search is generally preferred.

Expert NetSuite Support

Need help with this NetSuite issue?

Saved Searches & Formulas consulting and configuration support

Talk to a consultant