By developing of Search in SuiteScript and need of filter the Transaction based on the Status it needed to know what Status have to be used in the SuiteScript filter. Because the status in UI is not the same that should be used in SuiteScript below is the presented the status list of all transactions.
To use this list, create a NetSuite nlobjSearchFilter with syntax that looks as follows:
filters[2] = new nlobjSearchFilter(‘status’, null , ’is’, 'VendBill:A');
In this example I filter Vendor Bill transaction which are in status Open.
Notice that the criteria for the status is not indicated directly as 'Open' but 'VendBill:A' instead.
Status in UI
|
SearchFilter
|
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
|
Note: Be aware that statuses of the transaction can change in the future so before using please make sure that correct syntax is used.
The way how to find out the correct transaction status is to create Saved Search in UI, in criteria select 'Status' and select status you are supposed to use in SuiteScript. Now in SuiteScript debugger load the Saved Search and getFilters. It can be seen the correct syntax for status field. Here is a sample script for it:
var s = nlapiLoadSearch('salesorder','customsearch564'); // use Search ID of the Saved Search created in UI var filters = s.getFilters();
No comments:
Post a Comment