Hi Guru's,

I am trying to create a saved search that will show me currently what Items I have in inventory per location with an inventory location other than "good" and the quanity per status. I need this so I can review it, but more importantly to arrange for notifications to defferent people depending on the status type.

I have tried several times using a variety of different search types but I keep having the same issue. Either I am able to see the current on hand by location regardless of the status. The other more curious result, I can see the correct statuses and quanities, but it is not current, it is a list of the instances that the status changed. I have tried using formulas to look for Status, or Bin with the status, etc.