anyone know the syntax to get the name from user l...
# suiteanalyticsj
Janiece
12/01/2021, 4:01 AManyone know the syntax to get the name from user location when viewing a transfer order?
So far I have the following, but only can get the location internal id show.
n
Netsuite Tragic
12/01/2021, 7:46 AMWhen I create a saved search of Transfer Orders, add a results field of Formula (Text) {user.location} I get '2' being the Internal ID of the Employees location
Netsuite Tragic
12/01/2021, 7:46 AMWhen I select the Location and Join through the Field column I get the text Name "01: San Francisco".
Netsuite Tragic
12/01/2021, 8:17 AMActually I may have misread your requirement. If you want it to display on a Transfer Order record itself, then I used a Transaction Body field, Type = List/Record, List/Record = Location, Store Value = F, Validation & defaulting tab, Dynamic Default = Current User's Location.
Netsuite Tragic
12/01/2021, 8:19 AMThe Default Value formula field on Transaction Body Fields do not support joins.
j
Janiece
12/01/2021, 8:22 PM@Netsuite Tragic thanks for sharing! Ultimately im trying to figure out a work around to show a list of transfer orders that show only when the "Ship To location" matches the logged in user.
CASE WHEN {transferlocation.id} = {user.location.id} THEN 1 ELSE 0 ENDJaniece
12/01/2021, 8:23 PMonly issue is, it does not show child locations in this list 😞 and when receiving a transfer order it would be useful to see sub locations applicable to your locations.
Janiece
12/01/2021, 8:24 PMI figured I could write a workaround case when contain statement, but couldnt figure out how to get the user.location to show a name and not the internal id num
n
Netsuite Tragic
12/01/2021, 11:29 PMahh, have you look at the criteria Location = - Mine and Descendants -?