NetSuite SearchFilter Transaction Internal Status List

10 thoughts on “NetSuite SearchFilter Transaction Internal Status List”

1. […] NetSuite SearchFilter Transaction Internal Status List […]

2. […] NetSuite SearchFilter Transaction Internal Status List […]

3. […] NetSuite SearchFilter Transaction Internal Status List […]

4. 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. 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. Hi Rob,

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

   Marty

7. 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. Thank you for this! It applies to the SuiteTalk SOAP API as well.

9. 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. Thank you Clay. That’s quite helpful.

    Marty