Trying to prevent items being set as INACTIVE if w...
# suiteflow
p
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
k
This is a case where it's probably easier to correct with a scheduled workflow that sends an email/unchecks the inactive box rather than getting the workflow to prevent the record from being saved.
Odds are there's something off about the way NS is determining quantity on hand in display vs how the record shows it and the underlying criteria won't work