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

Hello! Anyone know how to include location descendants in this formula? `CASE WHEN {transferlocation.id} = {user.location.id} THEN 1 ELSE 0 END`
I want to be able to filter a saved search to show results to a user including their location and its child locations

On the search criteria, when you select Location have you considered the selection Mine and Descendants?

So you would need to add a custom field to your locations

and in that have a field for "include in search" or something to that effect

and you'd need to store the internal ID of the record that you wanted in that field

then it would be `transferlocation.newcustomfield` instead of `transferlocation.id`

I will try this shortly and let you know, thanks <@UER9Q3SGM>