some time ago i had the same requirement, I wanted a list of the
items that have no stock.
I found the following trick :
In the local variables I added this piece of code :
pt_mstr is the table that is in my browse.
on find of pt_mstr do: find first in_mstr no-lock
where in_domain = pt_domain and in_part = pt_part and (in_qty_oh
> 0 OR in_qty_nonet > 0) no-error. if available
in_mstr then return Error. Init (pt_part). end.
it is the 'return error' that does the trick. If you put that in an
on find block of your table in the browse, it will skip that line.
the init function is the function I made to do my calculations of
some calaculated columns.
I hope this can help you,
Replied: Jan 02, 2020
Thanks this a good thing to put into my pocket!
Replied: Jan 03, 2020
Sorry, is very interesting your way. Do you have any chance to share