10 thoughts on “NetSuite SearchFilter Transaction Internal Status List”

1. Pingback: Marty Zigman on "NetSuite SearchFilter Internal Account Type Codes"
2. Pingback: Marty Zigman on "NetSuite SearchFilter Internal Transaction Type Codes"
3. Pingback: Marty Zigman on "NetSuite Transaction Type Internal ID Numbers"
4. Agop says:

   February 6, 2015 at 11:28 am

   Very valuable information.

   When you fetch a transaction record in SuiteScript, you get something similar to this (in this case, an item fulfillment):

   
"shipstatus": {
"name": "Shipped",
"internalid": "C"
}


   So, surely, a search filter with shipstatus, anyof, and [“C”], should find this same record, right?

   Nope.

   Not only do you have to use status in place of shipstatus, but you also have to use ItemShip:C in place of C.

   Even clicking on the field in NetSuite tells you that the internal ID of the field is shipstatus.

5. Rob Grier says:

   April 28, 2016 at 7:13 am

   This works for searching but not always for changing status from script.

   I’m trying to start, complete, and approve an inventory count from script and it just ignores the change. Any hints to help?

6. Marty Zigman says:

   April 30, 2016 at 7:44 am

   Hi Rob,

   Status can not always be changed via script. Many times, it is calculated from other related records.

   Marty

7. Darren R says:

   November 19, 2018 at 12:00 pm

   I find it astonishing that five years later this information is *still* not documented anywhere by NetSuite (that I’ve been able to find). Thank you for this excellent resource!

8. Dylan Sprague says:

   January 3, 2020 at 7:25 am

   Thank you for this! It applies to the SuiteTalk SOAP API as well.

9. Clay Roper says:

   July 16, 2020 at 7:32 am

   I’ve got this page bookmarked for good reason – thanks for providing this resource Marty!

   I’d like to add a note for anyone who encounters this obstacle related to transaction statuses and SuiteQL:
   
SELECT DISTINCT status
FROM transaction
WHERE type = 'Opprtnty'
AND status NOT IN ('C', 'D')
ORDER BY status

   /* results
STATUS
A
B
C
D
*/


   You may notice that the statuses (‘C’,’D’) still appear in that list even though I ruled them out. Taking a cue from the composed status as listed in Marty’s article (Opprtnty:C, Opprtnty:D), the approach should be
   
SELECT DISTINCT status
FROM transaction
WHERE type = 'Opprtnty'
AND status NOT IN (type||':C', type||':D')
ORDER BY status

   /* results
STATUS
A
B
*/


   This isn’t readily apparent from inspecting the results of a query returning the status column, but a query filtering by status must concatenate the transaction type and the status as shown above.

   I hope this helps someone else that runs into a similar situation in the future!

10. Marty Zigman says:

    July 19, 2020 at 5:20 am

    Thank you Clay. That’s quite helpful.

    Marty