Searching by status in NetSuite

Introduction

When using a NetSuite Search activity to search for NetSuite objects based on a specific status, you will need to specify the correct search filter value that corresponds with the desired status. You can determine the corresponding search filter value as provided in the NetSuite transaction status table below.

Example

For example, if you want search criteria to limit the ItemFulfillment records to only ones where the Ship Status = Shipped, instead of using the enum for Shipped (_shipped), you would actually need to use the a value of ItemShip:C as provided in table below.

This screenshot shows how this would be configured using a NetSuite Search activity:

attachment

Similar translations apply to a variety of NetSuite objects.

NetSuite transaction status

Status	Search Value
`Cash Sale:Unapproved Payment`	`CashSale:A`
`Cash Sale:Not Deposited`	`CashSale:B`
`Cash Sale:Deposited`	`CashSale:C`
`Check:Voided`	`Check:V`
`Check:Online Bill Pay Pending Accounting Approval`	`Check:Z`
`Commission:Pending Payment`	`Commissn:A`
`Commission:Overpaid`	`Commissn:O`
`Commission:Pending Accounting Approval`	`Commissn:P`
`Commission:Rejected by Accounting`	`Commissn:R`
`Commission:Paid in Full`	`Commissn:X`
`Statement Charge:Open`	`CustChrg:A`
`Statement Charge:Paid In Full`	`CustChrg:B`
`Credit Memo:Open`	`CustCred:A`
`Credit Memo:Fully Applied`	`CustCred:B`
`Customer Deposit:Not Deposited`	`CustDep:A`
`Customer Deposit:Deposited`	`CustDep:B`
`Customer Deposit:Fully Applied`	`CustDep:C`
`Invoice:Open`	`CustInvc:A`
`Invoice:Paid In Full`	`CustInvc:B`
`Payment:Unapproved Payment`	`CustPymt:A`
`Payment:Not Deposited`	`CustPymt:B`
`Payment:Deposited`	`CustPymt:C`
`Customer Refund:Voided`	`CustRfnd:V`
`Quote:Open`	`Estimate:A`
`Quote:Processed`	`Estimate:B`
`Quote:Closed`	`Estimate:C`
`Quote:Voided`	`Estimate:V`
`Quote:Expired`	`Estimate:X`
`Expense Report:In Progress`	`ExpRept:A`
`Expense Report:Pending Supervisor Approval`	`ExpRept:B`
`Expense Report:Pending Accounting Approval`	`ExpRept:C`
`Expense Report:Rejected by Supervisor`	`ExpRept:D`
`Expense Report:Rejected by Accounting`	`ExpRept:E`
`Expense Report:Approved by Accounting`	`ExpRept:F`
`Expense Report:Approved (Overridden) by Accounting`	`ExpRept:G`
`Expense Report:Rejected (Overridden) by Accounting`	`ExpRept:H`
`Expense Report:Paid In Full`	`ExpRept:I`
`Inventory Count:Open`	`InvCount:A`
`Inventory Count:Started`	`InvCount:B`
`Inventory Count:Completed/Pending Approval`	`InvCount:C`
`Inventory Count:Approved`	`InvCount:D`
`Item Fulfillment:Picked`	`ItemShip:A`
`Item Fulfillment:Packed`	`ItemShip:B`
`Item Fulfillment:Shipped`	`ItemShip:C`
`Journal:Pending Approval`	`Journal:A`
`Journal:Approved for Posting`	`Journal:B`
`Payroll Liability Check:Voided`	`LiabPymt:V`
`Opportunity:In Progress`	`Opprtnty:A`
`Opportunity:Issued Estimate`	`Opprtnty:B`
`Opportunity:Closed – Won`	`Opprtnty:C`
`Opportunity:Closed – Lost`	`Opprtnty:D`
`Paycheck:Undefined`	`Paycheck:A`
`Paycheck:Pending Tax Calculation`	`Paycheck:C`
`Paycheck:Pending Commitment`	`Paycheck:D`
`Paycheck:Committed`	`Paycheck:F`
`Paycheck:Preview`	`Paycheck:P`
`Paycheck:Reversed`	`Paycheck:R`
`Purchase Order:Pending Supervisor Approval`	`PurchOrd:A`
`Purchase Order:Pending Receipt`	`PurchOrd:B`
`Purchase Order:Rejected by Supervisor`	`PurchOrd:C`
`Purchase Order:Partially Received`	`PurchOrd:D`
`Purchase Order:Pending Billing/Partially Received`	`PurchOrd:E`
`Purchase Order:Pending Bill`	`PurchOrd:F`
`Purchase Order:Fully Billed`	`PurchOrd:G`
`Purchase Order:Closed`	`PurchOrd:H`
`Return Authorization:Pending Approval`	`RtnAuth:A`
`Return Authorization:Pending Receipt`	`RtnAuth:B`
`Return Authorization:Cancelled`	`RtnAuth:C`
`Return Authorization:Partially Received`	`RtnAuth:D`
`Return Authorization:Pending Refund/Partially Received`	`RtnAuth:E`
`Return Authorization:Pending Refund`	`RtnAuth:F`
`Return Authorization:Refunded`	`RtnAuth:G`
`Return Authorization:Closed`	`RtnAuth:H`
`Sales Order:Pending Approval`	`SalesOrd:A`
`Sales Order:Pending Fulfillment`	`SalesOrd:B`
`Sales Order:Cancelled`	`SalesOrd:C`
`Sales Order:Partially Fulfilled`	`SalesOrd:D`
`Sales Order:Pending Billing/Partially Fulfilled`	`SalesOrd:E`
`Sales Order:Pending Billing`	`SalesOrd:F`
`Sales Order:Billed`	`SalesOrd:G`
`Sales Order:Closed`	`SalesOrd:H`
`Tax Liability Cheque:Voided`	`TaxLiab:V`
`Sales Tax Payment:Voided`	`TaxPymt:V`
`Sales Tax Payment:Online Bill Pay Pending Accounting Approval`	`TaxPymt:Z`
`Tegata Payable:Endorsed`	`TegPybl:E`
`Tegata Payable:Issued`	`TegPybl:I`
`Tegata Payable:Paid`	`TegPybl:P`
`Tegata Receivables:Collected`	`TegRcvbl:C`
`Tegata Receivables:Discounted`	`TegRcvbl:D`
`Tegata Receivables:Endorsed`	`TegRcvbl:E`
`Tegata Receivables:Holding`	`TegRcvbl:H`
`Transfer Order:Pending Approval`	`TrnfrOrd:A`
`Transfer Order:Pending Fulfillment`	`TrnfrOrd:B`
`Transfer Order:Rejected`	`TrnfrOrd:C`
`Transfer Order:Partially Fulfilled`	`TrnfrOrd:D`
`Transfer Order:Pending Receipt/Partially Fulfilled`	`TrnfrOrd:E`
`Transfer Order:Pending Receipt`	`TrnfrOrd:F`
`Transfer Order:Received`	`TrnfrOrd:G`
`Transfer Order:Closed`	`TrnfrOrd:H`
`Vendor Return Authorization:Pending Approval`	`VendAuth:A`
`Vendor Return Authorization:Pending Return`	`VendAuth:B`
`Vendor Return Authorization:Cancelled`	`VendAuth:C`
`Vendor Return Authorization:Partially Returned`	`VendAuth:D`
`Vendor Return Authorization:Pending Credit/Partially Returned`	`VendAuth:E`
`Vendor Return Authorization:Pending Credit`	`VendAuth:F`
`Vendor Return Authorization:Credited`	`VendAuth:G`
`Vendor Return Authorization:Closed`	`VendAuth:H`
`Bill:Open`	`VendBill:A`
`Bill:Paid In Full`	`VendBill:B`
`Bill:Cancelled`	`VendBill:C`
`Bill:Pending Approval`	`VendBill:D`
`Bill:Rejected`	`VendBill:E`
`Cash Payment:Voided`	`VendPymt:V`
`Cash Payment:Online Bill Pay Pending Accounting Approval`	`VendPymt:Z`
`Work Order:Pending Build`	`WorkOrd:B`
`Work Order:Cancelled`	`WorkOrd:C`
`Work Order:In Process`	`WorkOrd:D`
`Work Order:Built`	`WorkOrd:G`
`Work Order:Closed`	`WorkOrd:H`

Source: NetSuite SearchFilter Transaction Internal Status List