pen one
10/14/2020, 5:12 PMvar s = search.create({
type: search.Type.TRANSACTION,
filters: [
["custbody_origin_so","anyof",originSO],
"AND",
["type","anyof","SalesOrd"],
"AND",
["mainline","is","T"],
],
columns: [
search.createColumn({name: "tranid"}),
]
});
var pagedData = s.runPaged({pageSize : 1000});
// iterate the pages
for( var i=0; i < pagedData.pageRanges.length; i++ ) {
// fetch the current page data
var currentPage = pagedData.fetch(i);
// and forEach() thru all results
currentPage.data.forEach( function(result) {
// you have the result row. use it like this....
var previousBK = result.getValue('tranid');
alert('The origin sales order number you have entered has already been used in ' + previousBK +'. Make sure you are not creating a duplicate record before saving this order.');
});
}