Hi Barb,
I'm not sure if this helps you but we have a Gridview that shows a list of all items by location. We use "*IC Item Loc w IC Item" with fields, Item #, I/C Item Description. If you have each column show the total then select the "Summarize" button it will give you the quantities at each location. We find this really helpful when we want to do a visual scan of our inventory.
We have tried mins and maxs but ended up not using them. Our items change too often to keep up with it.
We have another gridview that we use for ordering that tells us what we need to order to fill our current back orders. Unfortunately it doesn't tell us what to order to replenish stock, only to fill back orders, but it still helps. We use "*IC Item Loc w IC Item" with fields Item #, I/C Item Description, Qty on SO & Pty on PO. We filter it with
AND(
{Loc} = " WA",
{Qty on Hand - WA} + {Qty on PO} < {Qty on SO},
{Stock Item?} =TRUE()
)
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario