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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
Searching Customers using Custom Record Criteria
I could use some help on a search, please.
I have a custom record type:
Description ID Type List/Record Tab Show In List
Customer custrecord1 List/Record Customer Yes
Software Name custrecord5 List/Record Item Yes
License Number custrecord2 Free-Form Text Yes
Maintenance Start Date custrecord3 Date Yes
Maintenance End Date custrecord4 Date Yes
Service Agreement custrecord6 Free-Form Text Yes
SendRenewalNotice custrecord7 Check Box Yes
I want to find customers who have one or more records where Software Name = X and has no records where Software Name is <> X. I'm trying to find customer who have one of our products but to whom we could market for other products.
0