Discussions
"Over/Under Stock" Report
Desired Result:
I would like to have a list of all inventory item, with a column for available qty, and a column for how many have sold in the last 60 days (even if its zero).
Then I will sort/highlight based on if we have more than 60days worth or less than 60 days worth available in stock.
Hopefully this will help me determine what parts im stocked too heavily on, and what parts need to be stocked heavier.
The way i started to try to accomplish this was by creating a
Saved Search Type: Item
Criteria -
Type: Inventory Item