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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Please note that on Friday, March 20, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 4 hours. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Filter Search for Sales Order Status
Hi, I've been honing down a scripted search (SuiteLet) and the last issue is with filtering for a particular set of statuses - partiallyFulfilled and pendingFulfillment, which are in the format returned by the search with this filter off. After many iterations and combing through he documentation, this filter will yeild zero results:
var filters = new Array(); var stati = new Array(); stati[0] = 'partiallyFulfilled'; stati[1] = 'pendingFulfillment'; filters[0] = new nlobjSearchFilter('status', null, 'anyOf', stati, null);But if I flip the operator to 'noneOf' then I get the full set of orders that match any other filter criteria.
It feels as though I'm using the wrong format for the status, but trying "Pending Fulfillment" or "Sales Order:Pending Fulfillment" or even the WS enum value "_pendingFulfillment" has the same effect.
0