Hi, how can I pull up 'entity' field in transaction saved search? I tried to find 'entity' in transaction saved search, but there was no 'entity'... is it displayed in a different name ?

believe it is called "Name", however if you use a formula, it will be referenced as {entity}

@gstea6 Thanks! It IS called "Name", however, every entity has a code (numbers in front of the name). When I select this on the form, I can see the code and the entity name. How can I show the code of the entity as well? there is no 'name field' in a saved search

don't recall doing this from a transaction search so i'm only guessing - you may need to use a joined field. ie: • in the field dropdown, select "Customer fields" • then select Name from the dropdown I'm still not 100% on that though - the customer id number has a different field reference to the customer name, so if all else fails, you may need to use a Formula (Text) with the field reference {customer.entityid}

@gstea6 Thanks a lot for the details explanation!!! It's weird.. when I hit refresh, it suddenly showed the code and the name..!!!

welcome to netsuite 😅 many such moments await you

@gstea6 Hi,sorry to bother you again, apparently, I have to separate the code and the name... I can't find name field though.... Do you have any idea how I can separate these two?

Just caught me 😄 I think you'll have to use the joined fields option Name by itself can be found under Company fields: Company Name I'm not sure about the number by itself... In this situation I usually use REGEX_SUBSTR but that can be an animal if you're not used to it

he there - on the Company fields, I think the number is

ID

- not to be confused with Internal ID.

@Betsy Barefoot Thank you ! @gstea6 It was ID 😄 ! Thanks for mentioning REGEX_SUBSTR might be helpful in the future !