[GarrettSulzman]

I am building a Workflow where when an Item is set to a Custom Status of “Discontinued” and the On Hand reaches Zero, it will mark the Item Inactive. Unfortunately, in my Saved Search, I can’t get the Item to show in my Results if On Hand is zero. What am I missing???
This is a cached copy. Click here to see the original post.

[blitzsport]

Hi Garrett,

have you tried the criteria of On Hand = 0 OR On Hand Is Empty?

Chris

---

GarrettSulzman replied on 01/08/2016, 04:38 PM: When I use the On Hand = 0, the Item drops off the list. I will see if the On Hand is Empty will keep the Item on my Result List…

[KCSF Bud]

Also helpful to use a formula criteria using w/ NVL({quantity},0) function in many scenarios.

---

GarrettSulzman replied on 01/08/2016, 04:57 PM: Function worked! Thank you.

[GarrettSulzman]

Thank you guys for your help. Fresh eyes are always nice to have.

[Author]

Posts