True/false expression in browse

Andy Grigger

New Member

I am trying to create a custom browse to see open locations that are single item locations. When I try to filter for locations that do not have inventory using Quantity on hand is null my search returns zero records. I was wondering if it was possible to use a calculated field for an expression that returned true or false/yes or no if there is inventory or not.

has anyone run into similar issues with browses not filtering as expected for "is null" when the field is blank?


What do you mean with "is null"?
is null means no value = ?. (not possible or not available)

ld_qty_oh is checked with 0.