Hi Everyone, I want to a

Sales order totals search by Month

and I wrote a Saved search for it but When I try to use it in script how do I group it by month? Currently get grouped by date in script

hey you are leaking business info. monthly revenue. 🤣

Yeah even that does not give you the grouping

found you another friend, google. https://stackoverflow.com/questions/40188497/performing-a-sum-or-grouped-query-in-suitescript-2-0

amazing that is what I was looking for.. ultimately what I did was do a formular to extract the month and group by that. When we export the search we never get this exported Thank you good for next time