Answer

how to filter out multiple items in purchase requisition lines

Forum|Forum|13 days ago
November 27, 2025
2 replies
40 views

+8

Susan Su
Sidekick (Customer)

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

Best answer by Furkan Zengin

Hello @Susan Su

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

+21

Furkan Zengin
Ultimate Hero (Partner)
Answer
Forum|Forum|13 days ago
November 27, 2025