Discussions
Date of Last order
What would be the easiest way to search customers who havent ordered in the last 3 months? NetSuite doesnt hold the date of the last order, it only holds the date of first order which is no help. In my mind thinking through it, i would have to do a customer search, then from the results do a transaction search based on the customer id, then from that list order them by date and select the last result. Seems a bit long winded and time consuming to me, is there an easier way of doing this?