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!
Customer Search Showing Initial Sale and Follow Up Orders
I'm trying to build a customer search that will show me the amount of a customer's first order in one column, and the total of all subsequent orders in another column. The challenge is, we often send out samples using $0 Sales Orders, which we would like to not count. Because of that, we can't compare the transaction date to the "Customer/Project First Order Date".
The only other way I can think of doing it, is to set the Amount > 0 in the criteria, group by customer name, and use the MIN of the Tran Date to compare to. I think this would work, but ultimately I want to group by customer category and not by customer name.
0