Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.