is there any filter in saved search which i can us...
# suiteanalytics
r
is there any filter in saved search which i can use to get quantity on hand for a particular month
g
Sounds like you'd either need to use two separate filters, one for month and the other for quantity. Or use a summarized saved search, grouping by month.
r
There is no date filter on item saved search. Just wondering what do you mean by use a summarized saved search, grouping by month.
g
Ah didn't realize you were looking at an Item saved search. So you're looking for a historical amount of the quantity on hand of items? I know NetSuite isn't strong in being able to provide historical changes like that, but have you looked at System Notes fields in the saved search?
r
Item record system notes does not track quantity on hand changes, so it is not possible to get quantity on hand for a particular month in saved search
g
Too bad. I guess your only recourse is a scheduled script that runs monthly, which runs a saved search to get the current quantity on hand and then stores the value with a join to the item into a custom record.
r
yeah. I am thinking something similar