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!
Cold Customer Saved Search
I need some help with a saved search.
I have been asked to create a search that shows customers who's last order was prior to 1/1/2019. But they also want to be made aware of any customers who drop off that list by placing an order now or in the future.
I can narrow down to the last order, its the second part I am not sure how to do. So far i have the following Criteria on a customer search'
Inactive is True
Date of Last Order is Before 1/1/2019
0