how can we apply a filter on a saved search that c...
# generale
Ehsan Ali
12/04/2019, 7:02 AMhow can we apply a filter on a saved search that contains only Months?
I have generated a report that shows a comparison of two months sales Amount. (e.g comparison of Dec 2018 and Dec 2019)
I want to take a month from the filter and compare sales of that month of the current year and the same month of the previous year?
(e.g If we select November, then generate a report that compares sales amount between November 2018 AND November 2019 )
a
aaz
12/04/2019, 9:30 AMIn saved search there is options in dates as different types like 'last month' , 'last month one fiscal quarter ago' etc.
e
Ehsan Ali
12/04/2019, 9:50 AMI want to show only months for selection that user can select month instead of full date to filter the result
a
aaz
12/04/2019, 10:09 AM@Ehsan Ali There is also custom option which is like you could select for e.g say march as 1/3/2012 to 1/4/2012
aaz
12/04/2019, 10:10 AMjust the thing that user have to select the starting days on
aaz
12/04/2019, 10:10 AMfield start date and end date
aaz
12/04/2019, 10:11 AMor for end date may be like end date of that month
aaz
12/04/2019, 10:14 AMor You could also use the custom page i.e. suitelet where your script will do the selection in backend and give you set of result on identified label by end user from dropdown or text field.
e
Ehsan Ali
12/04/2019, 11:39 AM@aaz Thanx for replying
Ehsan Ali
12/04/2019, 11:42 AMYou want to say that there is no option available in default filters of Netsuite that shows a dropdown of months name
Ehsan Ali
12/04/2019, 11:44 AMif I want this then we need to create a custom page i.e suitelet script
Ehsan Ali
12/04/2019, 11:46 AMright? am I understand your answer correctly?
e
Eric B
12/04/2019, 2:17 PMFor something like this you might want to look into creating custom fields to hold the values you want summarized values for and update those values with a map/reduce script at night so that you're not retrieving transactions spanning a year's worth of data.
6 Views