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.
nlobjSearchFilter Sales Order status
Hi,
I need to create a sales order search using nlapiSearchRecord and filter by status. Basically, I need to return all sales orders containing item x where the SO status is not "pending approval, cancelled, fully billed, closed".
Is there any documentation on what values should be used to filter on the status field of a transaction? I found an old post from Evan dating from 2006. I'm not sure if this still applies and what are the values for the sales orders.
I tried doing this by calling a saved search but I could not manage to pull the item quantities (committed, shipped...). I know it works without the saved search though but I'm having a hard time filtering the status.
0