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.
Customers with no sales
OK SQL/saved search gurus....here is a conundrum that has always been a puzzle for me. I am trying to write a search that brings back all customers that have not placed any sales orders. Some may have some other type of transaction but many simply have 0 transactions, ever. Assuming that there is no data field on the customer record that references sales history (such as Last Sales Activity, which is not being used in this NS instance)....how do I do this with a search? Seems that any join to transactions (sales orders or otherwise) will only produce rows that
0