is there any filter in saved search which i can use to get quantity on hand for a particular month
g
George McMullen
04/23/2019, 6:16 PM
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
rajneesh kumar
04/23/2019, 6:30 PM
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
George McMullen
04/23/2019, 8:30 PM
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
rajneesh kumar
04/24/2019, 2:02 AM
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
George McMullen
04/24/2019, 3:48 PM
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.