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!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Search Help Number Days between orders and Amount
Hello,
Has anyone had any luck trying to get the date between sales for customers and the amount of the sales? I cannot seem to get a saved search to act like a matrix and provide the data.
I am looking for something like this:
Customer Id/name - Date of 1st order - Amount - Date of 2nd order - Amount
Each as a seperate column.
The goal is to define how many days between the orders and if the amounts increase or decrease. I have tried both reports and searches with no avail as in a search you can get the 1st order date but nothing after.
0