Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Transfer Order Status pendingFulfillment
I am trying to loop through all the Pending Fulfillment Transfer Orders. Every time I add the status filter I get zero results. I've tried it a number of ways but every time I end up with no records returned. I know there is records out there from a saved search I am running. What am I doing wrong with the status filter?
function test(){ var recordType = ["TrnfrOrd"]; // Define search filters var f = new Array(); f[0] = new nlobjSearchFilter ('type', null, 'anyof', recordType); f[1] = new nlobjSearchFilter ('item', null, 'anyof', 2290966); f[2] = new nlobjSearchFilter ('mainline', null, 'is', 'F'); f[3] = new nlobjSearchFilter ('status', null, 'anyof', 'pendingFulfillment'); // Define search columns var c = new Array(); c[0] = new nlobjSearchColumn('entity'); c[1] = new nlobjSearchColumn('tranid'); c[2] = new nlobjSearchColumn('status'); // Search for child records var r = nlapiSearchRecord('transaction', null, f, c); if (r==null){ //return true; alert('not found'); }else{ //return false; alert(r.length); for (var i = 1; i < r.length; i++){ alert("|"+ 0