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

Hi is there any way to get the parent department in saved search created on the department?

Someone might have a way to get it in the search itself. I don't see a way, looking briefly. An alternative would be to use the search to get all the internal id's of the departments and then do record.load and record.getValue('parent') on each.

Or you could add it again as a custom field on the department and set it via script or workflow. That would elevate it to visible on a search.

if you only need the name, you can infer it from the hierarchy in the name

which you could also use to figure out the actual id if you get all the departments