Brett, I want to say you can do all of that with a single transaction search with a join to the inventory item, but it kind of depends on how you are counting your stock.