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!
Update your Profile with your Support type to get your Support Type badge.
Uncover the power of data with the Analytics Hub —your ultimate guide to mastering NetSuite Saved Searches and Reports. Simplify the complex and unlock your organization's true potential. Dive into the Analytics Hub now and soar to new heights!
To help you get the most out of your 2025.2 Release Preview account, review the topics outlined in the 2025.2 Release Preview Guide.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
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