Saved Search to show purchase order which has a non-blank End Destination and items that don’t fall under the “Accessory” or “Parts” category.

let poSearchObj = search.create({
type: “purchaseorder”,
filters:
[
[“custbody27”, “anyof”, “2”],
“AND”,
[“item.custitem_aha_parent_class”, “noneof”, “57”, “58”, “59”, “60”, “61”,
“62”, “63”, “64”, “65”, “66”, “257”, “110”, “111”, “112”],
“AND”,
[“type”, “anyof”, “PurchOrd”],
“AND”,
[“custbody28”, “noneof”, “@NONE@”],
“AND”,
[“mainline”, “is”, “T”]
],
columns:
[
search.createColumn({ name: “internalid”, label: “Internal ID” }),
search.createColumn({ name: “tranid”, label: “Document Number” }),
search.createColumn({ name: “custbody27”, label: “PO Type” }),
search.createColumn({ name: “custbody28”, label: “End Destination” })
]
});
let searchResultCount = poSearchObj.runPaged().count;
if (searchResultCount > 0) {
return poSearchObj;
}
else {
return {};
}