Filter items - existing stock

hi everyone,

I was wondering if I can filter items to show items which exist in stock (stock level is not zero)

Not possible without modifications.

This is because Item stock is tracked per Warehouse. So there is a 1:Many relationship between the 'Item' document and the 'Bin' document (which holds the stock levels)

  • Item A, Warehouse 1, quantity 100
  • Item A, Warehouse 2, quantity 0
  • Item A, Warehouse 3, quantity 10

In the example above, is the Item “in stock” or not? The answer varies by Warehouse.

The Filters aren’t designed to handle this extra depth of complexity.

You could use a Report instead, though.