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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Search: Suppliers: Email: is blank returns suppliers with email addresses
Hi there,
I'm looking to do a bit of a cleanup and add more useful data to our suppliers, starting with their email addresses.
I have a simple search set up that, according to the criteria, looks for "Supplier (Primary) : Email" is blank. This returns many results which have emails, and some of the results are clients, rather than customers.
I've also tried with the "Supplier : EMail" field with the same results.
Still very new to the whole Netsuite thing so may well be missing something obvious. Do I need a formula as well as the 'is blank' to limit the results to just empty email fields?
0