Hi Guys, Can we get data between two periods using...
# accounting
a
Hi Guys, Can we get data between two periods using Netsuite Saved search?
e
Sure, use the Criteria tab and set the conditions.
a
I want all the data between May 2024 to Jan 2030 .....how should set the criteria
s
start and end period for the date criteria
a
It is not working
e
Show a screenshot with said criteria
j
Super late to the party here, but @abodke you are correct, there is a limitation in saved searches of not being able to select period ranges other than the predefined set of dynamic ranges that NetSuite gives you. You can do date ranges, but I'm with you that oftentimes you need things by period and not by date due to date/period mismatches. You can get any period range you want by adding criteria using expressions (e.g. period = Jan 2024 OR period = Feb 2024 OR period = March 2024, etc., etc.) but that can get cumbersome, and can't be used/done in the filter area. Alternatively, suiteanalytics workbooks do allow selecting any number/range of periods.