All Transaction Status in Netsuite .

While adding filters , We required status internalid to be added to search correct result.
 Below Status can be used for search filters :

Status on Bill Record in Netsuite:

1. Bill:Open - VendBill:A
2. Bill:Paid In Full - VendBill:B
3. Bill:Cancelled - VendBill:C
4. Bill:Pending Approval - VendBill:D
5. Bill:Rejected - VendBill:E

Status on Bill Payment in Netsuite
1. Bill Payment:Voided - VendPymt:V
2. Bill Payment:Online Bill Pay Pending Accounting Approval - VendPymt:Z
3. Blanket Purchase Order:Pending Approval - BlankOrd:A
4. Blanket Purchase Order:Approved - BlankOrd:B
5. Blanket Purchase Order:Closed - BlankOrd:H
6. Blanket Purchase Order:Rejected - BlankOrd:R
7. Cash Sale:Unapproved Payment - CashSale:A
8. Cash Sale:Not Deposited - CashSale:B
9. Cash Sale:Deposited - CashSale:C
10. Check:Voided - Check:V
11. Check:Online Bill Pay Pending Accounting Approval - Check:Z
12. Commission:Pending Payment - Commissn:A
13. Commission:Overpaid - Commissn:O
14. Commission:Pending Accounting Approval - Commissn:P
15. Commission:Rejected by Accounting - Commissn:R
16. Commission:Paid in Full - Commissn:X
17. Credit Memo:Open - CustCred:A
18. Credit Memo:Fully Applied - CustCred:B
19. Customer Deposit:Not Deposited - CustDep:A
20. Customer Deposit:Deposited - CustDep:B
21. Customer Deposit:Fully Applied - CustDep:C
22. Customer Refund:Voided - CustRfnd:V
23. Expense Report:In Progress - ExpRept:A
24. Expense Report:Pending Supervisor Approval - ExpRept:B
25. Expense Report:Pending Accounting Approval - ExpRept:C
26. Expense Report:Rejected by Supervisor - ExpRept:D
27. Expense Report:Rejected by Accounting - ExpRept:E
28. Expense Report:Approved by Accounting - ExpRept:F
29. Expense Report:Approved (Overridden) by Accounting - ExpRept:G
30. Expense Report:Rejected (Overridden) by Accounting - ExpRept:H
31. Expense Report:Paid In Full - ExpRept:I
32. Inventory Count:Open - InvCount:A
33. Inventory Count:Started - InvCount:B
34. Inventory Count:Completed/Pending Approval - InvCount:C
35. Inventory Count:Approved - InvCount:D
36. Invoice:Open - CustInvc:A
37. Invoice:Paid In Full - CustInvc:B
38. Invoice:Pending Approval - CustInvc:D
39. Invoice:Rejected - CustInvc:E
40. Item Fulfillment:Picked - ItemShip:A
41. Item Fulfillment:Packed - ItemShip:B
42. Item Fulfillment:Shipped - ItemShip:C
43. Journal:Pending Approval - Journal:A
44. Journal:Approved for Posting - Journal:B
45. Opportunity:In Progress - Opprtnty:A
46. Opportunity:Issued Estimate - Opprtnty:B
47. Opportunity:Closed - Won - Opprtnty:C
48. Opportunity:Closed - Lost - Opprtnty:D




Comments