Asking for a completely different topic, but how do I reference the "Items Purchased" Fields, using a Formula(TEXT) filter in criteria?

UNI- in the beginning or the end?

Beginning

try "does not start with"

I just tried "does not start with" and the results were the same as before 😞

instead of formula use item:name (join) and define the names

the uh, UNI- themeed names number over 100+ are you saying I should manually add all of those names under the list for the search to exclude?

Oh, im doing a customer search, is this more of a transactional search? Ill give your method a try, one second

best bet would be transaction search since it touches almost everything. That's why taking the route of transaction search would be the logical choice.

Sorry I'm still a bit new to using NetSuite, I've implemented what I think you're suggesting in a transactional search, however even when I set the results to "customers:name" it seems to be outputting the incorrect information

What do you mean by that?

vendor, customer, employee, contacts are all classified as entity

Oh, Thank you ! I see what you mean, I changed the results to be Customer (Main Line) : Name, and I got some outputs, but the customers that appear are still not what I'm looking for, if I were to look at the customer records and go to the items purchased section, they still have purchases of items with "UNI" at the start

that will be difficult to exclude

I've tried a few methods and ways to try to get it to work, I know if I were to do this using suiteQL itd probably be quite easy, or even just generate two seperate searches, export it into excel and fix it up myself even but I was hoping there might be an easier way to get it done through a saved search

may need some custom SQL to sift through

ill probably keep trying at it

with SQL EXCLUDE function you might able to do so