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.
creating saved search - days in current opportunity status
I'm trying to create a saved search that links opportunities to system notes.
The list will show how long an opportunity has been in its current status.
This seems to be a standard field generated in most CRM systems, but apparently it's not here.
What am I missing here?
Opportunity Search
Criteria:
- Sales Rep
- System notes: field Description is Entity Status
- Formula (Numeric) Description is 0 Formula CASE {entitystatus} WHEN {systemnotes.newvalue} THEN 1 ELSE 0 END
- Opportunity Status (Select)
Results:
- Sort By: Customer
Fields: Number, Customer (Summary Type: Group), Title (Summary Type: Group), Opportunity Status (Summary Type: Group), System Notes: Date (Summary Type: Maximum), System Notes (Summary Type: Maximum)
0