Andy Grigger
New Member
Hello,
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?
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?