Saved search formula to get all the purchase order which does not have any item contains a specific class.

filters:
[
[“custbody27”, “anyof”, “2”],
“AND”,
[“custbody28”, “noneof”, “@NONE@”],
“AND”,
[“status”, “anyof”, “PurchOrd:F”, “PurchOrd:G”],
“AND”,
[“mainline”, “is”, “F”],
“AND”,
[“type”, “anyof”, “PurchOrd”],
“AND”,
[[“systemnotes.date”, “on”, “yesterday”], “AND”,
[“systemnotes.newvalue”, “is”, “Pending Bill”], “AND”,
[“systemnotes.field”, “anyof”, “TRANDOC.KSTATUS”], “AND”,
[“systemnotes.type”, “is”, “F”]],
“AND”,
[“closed”, “is”, “F”],
“AND”,
[“max(formulanumeric: CASE WHEN {item.custitem_aha_parent_class}=’Accessory’ THEN 1 ELSE 0 END)”, “equalto”, “0”]
],
columns:
[
search.createColumn({
name: “internalid”,
summary: “GROUP”,
label: “Internal ID”
}),
search.createColumn({
name: “custbody28”,
summary: “GROUP”,
label: “End Destination”
})
]