NetSuite Query of Status Field

Document created by chris_stevens Employee on May 25, 2016Last modified by chris_stevens Employee on Nov 9, 2016
Version 2Show Document
  • View in full screen mode

When attempting to perform a query on a status field (eg. Invoice|status), you may get the following error, based on the filter value:

The field status's enum value <Open> is invalid for this search.

 

This means you're using an invalid filter field value, and should be using one of the following:

StatusSearchFilter
Cash Sale:Unapproved PaymentCashSale:A
Cash Sale:Not DepositedCashSale:B
Cash Sale:DepositedCashSale:C
Check:VoidedCheck:V
Check:Online Bill Pay Pending Accounting ApprovalCheck:Z
Commission:Pending PaymentCommissn:A
Commission:OverpaidCommissn:O
Commission:Pending Accounting ApprovalCommissn:P
Commission:Rejected by AccountingCommissn:R
Commission:Paid in FullCommissn:X
Statement Charge:OpenCustChrg:A
Statement Charge:Paid In FullCustChrg:B
Credit Memo:OpenCustCred:A
Credit Memo:Fully AppliedCustCred:B
Customer Deposit:Not DepositedCustDep:A
Customer Deposit:DepositedCustDep:B
Customer Deposit:Fully AppliedCustDep:C
Invoice:OpenCustInvc:A
Invoice:Paid In FullCustInvc:B
Payment:Unapproved PaymentCustPymt:A
Payment:Not DepositedCustPymt:B
Payment:DepositedCustPymt:C
Customer Refund:VoidedCustRfnd:V
Quote:OpenEstimate:A
Quote:ProcessedEstimate:B
Quote:ClosedEstimate:C
Quote:VoidedEstimate:V
Quote:ExpiredEstimate:X
Expense Report:In ProgressExpRept:A
Expense Report:Pending Supervisor ApprovalExpRept:B
Expense Report:Pending Accounting ApprovalExpRept:C
Expense Report:Rejected by SupervisorExpRept:D
Expense Report:Rejected by AccountingExpRept:E
Expense Report:Approved by AccountingExpRept:F
Expense Report:Approved (Overridden) by AccountingExpRept:G
Expense Report:Rejected (Overridden) by AccountingExpRept:H
Expense Report:Paid In FullExpRept:I
Inventory Count:OpenInvCount:A
Inventory Count:StartedInvCount:B
Inventory Count:Completed/Pending ApprovalInvCount:C
Inventory Count:ApprovedInvCount:D
Item Fulfillment:PickedItemShip:A
Item Fulfillment:PackedItemShip:B
Item Fulfillment:ShippedItemShip:C
Journal:Pending ApprovalJournal:A
Journal:Approved for PostingJournal:B
Payroll Liability Check:VoidedLiabPymt:V
Opportunity:In ProgressOpprtnty:A
Opportunity:Issued EstimateOpprtnty:B
Opportunity:Closed – WonOpprtnty:C
Opportunity:Closed – LostOpprtnty:D
Paycheck:UndefinedPaycheck:A
Paycheck:Pending Tax CalculationPaycheck:C
Paycheck:Pending CommitmentPaycheck:D
Paycheck:CommittedPaycheck:F
Paycheck:PreviewPaycheck:P
Paycheck:ReversedPaycheck:R
Purchase Order:Pending Supervisor ApprovalPurchOrd:A
Purchase Order:Pending ReceiptPurchOrd:B
Purchase Order:Rejected by SupervisorPurchOrd:C
Purchase Order:Partially ReceivedPurchOrd:D
Purchase Order:Pending Billing/Partially ReceivedPurchOrd:E
Purchase Order:Pending BillPurchOrd:F
Purchase Order:Fully BilledPurchOrd:G
Purchase Order:ClosedPurchOrd:H
Return Authorization:Pending ApprovalRtnAuth:A
Return Authorization:Pending ReceiptRtnAuth:B
Return Authorization:CancelledRtnAuth:C
Return Authorization:Partially ReceivedRtnAuth:D
Return Authorization:Pending Refund/Partially ReceivedRtnAuth:E
Return Authorization:Pending RefundRtnAuth:F
Return Authorization:RefundedRtnAuth:G
Return Authorization:ClosedRtnAuth:H
Sales Order:Pending ApprovalSalesOrd:A
Sales Order:Pending FulfillmentSalesOrd:B
Sales Order:CancelledSalesOrd:C
Sales Order:Partially FulfilledSalesOrd:D
Sales Order:Pending Billing/Partially FulfilledSalesOrd:E
Sales Order:Pending BillingSalesOrd:F
Sales Order:BilledSalesOrd:G
Sales Order:ClosedSalesOrd:H
Tax Liability Cheque:VoidedTaxLiab:V
Sales Tax Payment:VoidedTaxPymt:V
Sales Tax Payment:Online Bill Pay Pending Accounting ApprovalTaxPymt:Z
Tegata Payable:EndorsedTegPybl:E
Tegata Payable:IssuedTegPybl:I
Tegata Payable:PaidTegPybl:P
Tegata Receivables:CollectedTegRcvbl:C
Tegata Receivables:DiscountedTegRcvbl:D
Tegata Receivables:EndorsedTegRcvbl:E
Tegata Receivables:HoldingTegRcvbl:H
Transfer Order:Pending ApprovalTrnfrOrd:A
Transfer Order:Pending FulfillmentTrnfrOrd:B
Transfer Order:RejectedTrnfrOrd:C
Transfer Order:Partially FulfilledTrnfrOrd:D
Transfer Order:Pending Receipt/Partially FulfilledTrnfrOrd:E
Transfer Order:Pending ReceiptTrnfrOrd:F
Transfer Order:ReceivedTrnfrOrd:G
Transfer Order:ClosedTrnfrOrd:H
Vendor Return Authorization:Pending ApprovalVendAuth:A
Vendor Return Authorization:Pending ReturnVendAuth:B
Vendor Return Authorization:CancelledVendAuth:C
Vendor Return Authorization:Partially ReturnedVendAuth:D
Vendor Return Authorization:Pending Credit/Partially ReturnedVendAuth:E
Vendor Return Authorization:Pending CreditVendAuth:F
Vendor Return Authorization:CreditedVendAuth:G
Vendor Return Authorization:ClosedVendAuth:H
Bill:OpenVendBill:A
Bill:Paid In FullVendBill:B
Bill:CancelledVendBill:C
Bill:Pending ApprovalVendBill:D
Bill:RejectedVendBill:E
Cash Payment:VoidedVendPymt:V
Cash Payment:Online Bill Pay Pending Accounting ApprovalVendPymt:Z
Work Order:Pending BuildWorkOrd:B
Work Order:CancelledWorkOrd:C
Work Order:In ProcessWorkOrd:D
Work Order:BuiltWorkOrd:G
Work Order:ClosedWorkOrd:H

 

Source: Marty Zigman on "NetSuite SearchFilter Transaction Internal Status List"

Attachments

    Outcomes