NetSuite Transaction Status Search Filters

Here are some internal ids of different NetSuite transaction statuses. Couldn’t find these on ‘NetSuite Help’, so adding these from a website.
These values are really useful for understanding an already created saved search filters used inside suitescript.

Note: Be aware that statuses of the transaction can change in the future so before using please make sure that correct syntax is used.

Status in UI………………………….Search-Filter

Bill:Open………………………….VendBill:A
Bill:Paid In Full………………………….VendBill:B
Bill:Cancelled………………………….VendBill:C
Bill:Pending Approval………………………….VendBill:D
Bill:Rejected………………………….VendBill:E
Bill Payment:Voided………………………….VendPymt:V
Bill Payment:Online Bill Pay Pending Accounting Approval………………………….VendPymt:Z
Blanket Purchase Order:Pending Approval………………………….BlankOrd:A
Blanket Purchase Order:Approved………………………….BlankOrd:B
Blanket Purchase Order:Closed………………………….BlankOrd:H
Blanket Purchase Order:Rejected………………………….BlankOrd:R
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
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
Customer Refund:Voided………………………….CustRfnd:V
Deprecated Custom Transaction:Status A………………………….DeprCust:A
Deprecated Custom Transaction:Status B………………………….DeprCust:B
Deprecated Custom Transaction:Status C………………………….DeprCust:C
Deprecated Custom Transaction:Status D………………………….DeprCust:D
Deprecated Custom Transaction:Status E………………………….DeprCust:E
Deprecated Custom Transaction:Status F………………………….DeprCust:F
Deprecated Custom Transaction:Status G………………………….DeprCust:G
Deprecated Custom Transaction:Status H………………………….DeprCust:H
Deprecated Custom Transaction:Status I………………………….DeprCust:I
Deprecated Custom Transaction:Status J………………………….DeprCust:J
Deprecated Custom Transaction:Status K………………………….DeprCust:K
Deprecated Custom Transaction:Status L ………………………….DeprCust:L
Deprecated Custom Transaction:Status M…………………………. DeprCust:M
Deprecated Custom Transaction:Status N…………………………. DeprCust:N
Deprecated Custom Transaction:Status O………………………….DeprCust:O
Deprecated Custom Transaction:Status P…………………………. DeprCust:P
Deprecated Custom Transaction:Status Q………………………….DeprCust:Q
Deprecated Custom Transaction:Status R………………………….DeprCust:R
Deprecated Custom Transaction:Status S………………………….DeprCust:S
Deprecated Custom Transaction:Status T…………………………. DeprCust:T
Deprecated Custom Transaction:Status U………………………….DeprCust:U
Deprecated Custom Transaction:Voided………………………….DeprCust:V
Deprecated Custom Transaction:Status W………………………….DeprCust:W
Deprecated Custom Transaction:Status X………………………….DeprCust:X
Deprecated Custom Transaction:Status Z………………………….DeprCust:Z
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
Invoice:Open………………………….CustInvc:A
Invoice:Paid In Full………………………….CustInvc:B
Invoice:Pending Approval………………………….CustInvc:D
Invoice:Rejected………………………….CustInvc:E
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
Opportunity:In Progress………………………….Opprtnty:A
Opportunity:Issued Estimate………………………….Opprtnty:B
Opportunity:Closed – Won………………………….Opprtnty:C
Opportunity:Closed – Lost………………………….Opprtnty:D
Order:Pending Approval………………………….SalesOrd:A
Order:Pending Fulfillment………………………….SalesOrd:B
Order:Cancelled………………………….SalesOrd:C
Order:Partially Fulfilled………………………….SalesOrd:D
Order:Pending Billing/Partially Fulfilled………………………….SalesOrd:E
Order:Pending Billing………………………….SalesOrd:F
Order:Billed………………………….SalesOrd:G
Order:Closed………………………….SalesOrd:H
Paycheck:Created………………………….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
Paycheck:Error………………………….Paycheck:X
Payment:Unapproved Payment………………………….CustPymt:A
Payment:Not Deposited………………………….CustPymt:B
Payment:Deposited………………………….CustPymt:C
Payroll Liability Check:Voided………………………….LiabPymt:V
Purchase Contract:Pending Approval………………………….PurchCon:A
Purchase Contract:Approved………………………….PurchCon:B
Purchase Contract:Closed………………………….PurchCon:H
Purchase Contract:Rejected………………………….PurchCon: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
Quote:Open………………………….Estimate:A
Quote:Processed………………………….Estimate:B
Quote:Closed………………………….Estimate:C
Quote:Voided………………………….Estimate:V
Quote:Expired………………………….Estimate:X
Request For Quote:Pending Bid Open………………………….Rfq:A
Request For Quote:Pending………………………….Rfq:B
Request For Quote:Cancelled………………………….Rfq:C
Request For Quote:Bid Open………………………….Rfq:D
Request For Quote:Bid Closed………………………….Rfq:E
Request For Quote:Partially Awarded………………………….Rfq:F
Request For Quote:Fully Awarded………………………….Rfq:G
Request For Quote:Closed………………………….Rfq:H
Requisition:Pending Approval………………………….PurchReq:A
Requisition:Pending Order………………………….PurchReq:B
Requisition:Cancelled………………………….PurchReq:C
Requisition:Partially Ordered………………………….PurchReq:D
Requisition:Fully Ordered………………………….PurchReq:E
Requisition:Partially Received………………………….PurchReq:F
Requisition:Fully Received………………………….PurchReq:G
Requisition:Closed………………………….PurchReq:H
Requisition:Rejected………………………….PurchReq:R
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
Revenue Arrangement:Pending Approval………………………….RevArrng:A
Revenue Arrangement:Approved………………………….RevArrng:B
Revenue Arrangement:Closed………………………….RevArrng:H
Revenue Arrangement:Rejected………………………….RevArrng:R
Sales Tax Payment:Voided………………………….TaxPymt:V
Sales Tax Payment:Online Bill Pay Pending Accounting Approval………………………….TaxPymt:Z
Statement Charge:Open………………………….CustChrg:A
Statement Charge:Paid In Full………………………….CustChrg:B
Store Pickup Fulfillment:New………………………….StPickUp:A
Store Pickup Fulfillment:Picked………………………….StPickUp:B
Store Pickup Fulfillment:Picked Up………………………….StPickUp:C
Tax Liability Cheque:Voided………………………….TaxLiab:V
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
Tegata Receivables:Voided………………………….TegRcvbl:V
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 Request For Quote:Pending Bid Open………………………….VendRfq:A
Vendor Request For Quote:Pending………………………….VendRfq:B
Vendor Request For Quote:Cancelled………………………….VendRfq:C
Vendor Request For Quote:Bid Open………………………….VendRfq:D
Vendor Request For Quote:Bid Closed………………………….VendRfq:E
Vendor Request For Quote:Partially Awarded………………………….VendRfq:F
Vendor Request For Quote:Fully Awarded………………………….VendRfq:G
Vendor Request For Quote:Closed………………………….VendRfq: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
Work Order:Planned………………………….WorkOrd:A
Work Order:Released………………………….WorkOrd:B
Work Order:Cancelled………………………….WorkOrd:C
Work Order:In Process………………………….WorkOrd:D
Work Order:Built………………………….WorkOrd:G
Work Order:Closed………………………….WorkOrd:H

Leave a comment

Your email address will not be published. Required fields are marked *