Item Saved search that indicates whether an item is a matrix child in Netsuite?

Hi All,

Pupose: Create an Item Saved search that indicates whether an item is a matrix child

-->Go to Lists > Search > Saved Searches > New
-->Click on the Results tab > open Columns, add the Formula Text Field:

Use Formula  "CASE WHEN {parent} is not null then 'Yes' else 'No' END"**

You can give the Label you want or simply "Matrix Child "
--Click Save & Run.

You will see in search result those items which are Matrix Child will come as Yes and other will come as No.

** Netsuite uses PL/SQL for formula in Saved Searches.
If you want return type as Text use Formula Text else you have to use other type of formula.


Thanks
Abhi