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.
Thanks!
JM
You have to use the internal status code which is a single letter. We will add a new filter for the future which will be friendlier. For now, try 'PurchOrd:B'. But this will exclude partially received. To get everything that is still pending receipt in some way you need to add B,D, and E to the filter. Here's the full list:
A Pending Supervisor Approval
B Pending Receipt
C Rejected by Supervisor
D Partially Received
E Pending Billing/Partially Received
F Pending Bill
G Fully Billed
H Closed