Discussions
Highlighting saved search results, On Hand Qty < Reorder Point
I'm building a saved search for use in re-ordering products, currently it is a straightforward on-hand search for items that have a custom "stocking" item checkbox (items that we would like to have around at all times as opposed to one-off runs). I have the item name, on hand qty, and reorder point columns on the search.
I would like to highlight an item on the report if its on hand qty is lower than the individually defined reorder point. This would save time from having to check every single line for discrepancies. It seems to me that you can only highlight an item in this way if you make an overall criteria i.e "highlight all items with an on hand qty of 5 or less." I am wondering if anyone has suggestions, or perhaps a better way to filter this data.