Hello,

I have a question with workflow. Basically, I'm trying to set up a workflow in the event that the amount tracked from the MTK object is either 5% above or below the expected quantity. Ex. If 36 units are expected, and only 30 are made (80%), a notification is triggered. The way I have it set up now is such:

Conditions

Header - (0.95 > ([M:MTK2]MFITOTQTY(0) / [M:MTK2]MFIUOMQTY(0))) ? (1.05 < ([M:MTK2]MFITOTQTY(0) / [M:MTK2]MFIUOMQTY(0)))

where ([M:MTK2]MFITOTQTY(0) / [M:MTK2]MFIUOMQTY(0))) represents the two numbers above for the first line. (I have also tried using | )

The issue I'm getting is with using the 'OR' clause, it seems that all tracked work orders are now triggering a notification (even those that are within the 0.95-1.05 range), which doesn't work.

When I change the '?' to an '&', it doesn't trigger anything because it's either below the 0.95 or above 1.05 (it cannot be both).

Has anyone run into this problem with using the 'or' before and what is the workaround. 

I guess I could create 2 seperate workflows for above 5% and below 5% with 2 different texts, but I'd rather have it in one. 

Thank you,

Mike

Sage ERP X3 V6.5 PU29