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!
Sales search
Greetings:
I am trying to create a search that shows me all customers who have purchased over $500 (cumulative over all sales orders) during 2007.
I am able to do this with a report, but haven't successfully found out how to do this on a search. When I search by transaction, it will only show me those who have had single transactions over $500.
In the search, I also tried using "total amount purchased" but that is over all time, not this year, and there wasn't a way to limit it to this year (that I could find).
I need this to be a search rather than a report, because based on the results, we edit/update some other fields manually and via mass update.
0