Not sure if this is the best group for my question but I'm looking to create a saved search which shows me:
- Avg sold quantity per month of item based on last 3 months of sales orders
- Total items available for that item for a specific set of inventory locations
The thing is, for the first I would create a transaction search and for the second I would use an item search.