Saved Search to get the purchase order which changed the status to pending billing on yesterday.

let purchaseorderSearchObj = search.create({
type: “purchaseorder”,
filters:[
[“custbody27”, “anyof”, “2”],
“AND”,
[“custbody28”, “noneof”, “@NONE@”],
“AND”,
[“status”, “anyof”, “PurchOrd:F”],
“AND”,
[“item.class”, “noneof”, “57”, “110”],
“AND”,
[“item.custitem_jj_product_type”, “noneof”, “3”],
“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”]]
],
columns:
[
search.createColumn({
name: “internalid”,
summary: “GROUP”,
label: “Internal ID”
}),
search.createColumn({
name: “custbody28”,
summary: “GROUP”,
label: “End Destination”
})
]
});
let searchResultCount = purchaseorderSearchObj.runPaged().count;