hey guys I’m trying to create a saved search which shows items below reorder point - I used the formula on an inventory balance search as “{onhand}<{item.locationreorderpoint}” but am getting “Error: Invalid Expression”

Try a case when statement in your criteria and see if that works. CASE WHEN {onhand} < {item.locationreorderpoint} THEN 1 ELSE 0 END equal to 1

just NVL around the field should do it

@Chloë - Thanks for that! @AK47 - never used NVL. What does it do? And should I just do a NVL[{onhand}<{item.locationreorderpoint}] as the formula?

NVL({onhand}, 0) basically if it’s null spit out a numeric value (in this case zero).

correct, it's like isNULL() in SQL. If the value is null, put something other value.

Here’s the SA for at or below reorder point https://netsuite.custhelp.com/app/answers/detail/a_id/35205/kw/below%20reorder%20point