Check out Oracle NetSuite upcoming events and conferences here
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.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Don't miss out on our Question of the week! You only have until tomorrow, April 25, 2024, 2PM ET to comment your answers and earn rewards! Click here for more details.
Community Poll: What sort of content would you like to see more of?

How to create a Saved search for Sales orders comparing to same months in previous years.

edited Dec 27, 2022 3:13PM in Ask A Guru 11 comments

Hi Guru's,

I am not sure if this is a report or a saved search. I have tried with reports, but I have not been able to make it work. What I am trying to make might almost be a standard report of search, but I have not been able to find it.

I want to show the total number of Billed sales orders, total sales, average $ per transaction, and the average line per transaction by employee per month. Also comparing the same information to the last two previous years. I am not sure I can achieve this with a report. I get pretty close, but only for a specific period. I have a feeling to set it up like this will require a saved search with several formulas.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!


Community Whiz

Quarter 2 (Apr-Jun 2024)

This Week's Leaders

This Month's Leaders

All Time Leaders