This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Guys, can anyone tell me how to add not eqal to in case when formula in saved search?

```case when {type} = 'Journal' and {custbody_journal_entry_type}  != 4 then 1 else 0 END```

:heavy_plus_sign:

what is journal type 4? is that the internal ID? If so add .id to the end of the journal type field eg {custbody_journal_entry_type.id}

4 is internal ID and jornal entry type is a list field

I agree with <@UHRE7JTGE> use {custbody_journal_entry_type.id}

might also be vendorbill, invoice, expensereport, etc

If it’s record type  you need to use {recordtype} not type 

in suitescript that might be the case, but it isn't. In search, you set it as a transaction search

I have transaction type saved searches that use the {recordtype} well and therefore give me journal, vendorbill etc

seems both are true, type is a friendly name - you don't "need" to use one or the other but you do need to ensure you understand the differences - I've never used recordtype.

furthermore, opportunity returns null in recordtype

seems a bit of an oversight tbh, would have expected both fields to return at least something

<https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2015_1/schema/enum/recordtype.html|https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2015_1/schema/enum/recordtype.html>  <@UHRE7JTGE> it's strange that you're not the record type for the opportunity

what can I say, I took the screenshot seconds ago.

everything else had a value, it wasn't filtered and it certainly isn't expected

I concur with you / the record browser - it should be showing in that search I did