Is there a filter in saved search that lets you to...
# general
d
Is there a filter in saved search that lets you to filter the date to be "as-of" a certain date? Can't seem to find anything that can do that in the filters available
m
There's not anything that will just go snap shot a saved search as of a date like that, but there's usually a way. For example if you wanted to get an inventory snap shot as of a date with a search, you'd have to do a transaction search, set the account to your asset account(s) in the criteria, then group by item and sum the qtys on the results. This would basically include every inventory impacting transaction and recreate the inventory as it would have been on that date.
d
hmm I was looking at how to pull a saved search for fixed assets as of say, 31/12/2018. I'm currently using 'date created' but if there is a way to get it 'as-of' that would be better.
p
its better to just use the Inventory Valuation report!
k
Yeah so if you are using FAM that should be one of the standard reporte
Unless of course someone is back dating assets
m
I agree, was just trying to think of an example where you'd use as of in a search.
d
Unfortunately, inventory management was not enabled for the NS account in my company as most of those features are not used...
k
I'm not sure I track inventory management and fixed assets being related
d
the inventory valuation report requires inventory management feature no?
k
Inventory valuation report does not typically touch fixed assets management.
Unless you are using items in a very strange way.