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?
Many thanks in advance!