Trying to prevent items being set as INACTIVE if we have stock. Looking at using [totalquantityonhand] which is populated correctly as a workflow field, but when added to the criteria, the trigger doesnt work. Any thoughts on this?
If I set the condition to [inactive = t] on field edit [Inactive field], it works
If I set the condition to [inactive = t && totalquantityonhand > 0] it doesnt trigger.
totalquantityonhand = 6