Dear all
In IFS Cloud 24R2, for purchase requisition lines, select one supplier, there are 20 items (maybe 50-100 lines) to be released to convert purchase order, but among of them about 2-5 items will not to be released, use “not equal to” and “;”, but it does not work, the filter out items are still there.
In IFS10, it worked. Can we have any other simple solution for end user? please help to check.
Thanks
Susan
+21Hello
This is due to the search logic. You are facing with Boolean logic trap. With your search the condition is always TRUE.
See how it works.
(PartNo != '1001000042') OR (PartNo != '1001000056')
This condition is always true, no matter what Part No is.
Example 1: PartNo = '1001000042'
PartNo != '1001000042' → false
PartNo != '1001000056' → true
➡ false OR true = true
So 1001000042 is not excluded.
Example 2: PartNo = '1001000056'
PartNo != '1001000042' → true
PartNo != '1001000056' → false
➡ true OR false = true
So 1001000056 is not excluded.
Example 3: PartNo = ANYTHING ELSE
both expressions are true
➡ true OR true = true
(PartNo != '1001000042') AND (PartNo != '1001000056')
This is only true if the part number is neither of them.
Example: PartNo = '1001000042'
false AND true = false → gets excluded
Example: PartNo = '1001000056'
true AND false = false → gets excluded
Example: PartNo = ANYTHING ELSE
true AND true = true → allowed
Hope this is clear
Furkan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
