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 everyone, assistance with suitescript code, trying to fetch Subsidiary ID from a location record, though I'm getting the text name rather than number value.

    var locationLookup = search.lookupFields({
        type: search.Type.LOCATION,
        id: locationId,
        columns: ['subsidiary']
    });
    subsidiaryName = locationLookup.subsidiary[0].value;

locationLookup Debug:

{"subsidiary":"Topco Inc"}

```var x = search.lookupFields({
        type: search.Type.LOCATION,
        id: 1,
        columns: ['subsidiary','internalid', 'name']
    });

var subsidiaryId = x['internalid'][0].value;

var subsidiaryName = x['subsidiary']```

<@U6SCH2RAS> thanks for trying, but didnt'work . it brings up the location internal id rather than sub id :disappointed:

Ok, it looks like you can access these if your load them:
```var x = record.load({ type: 'location', id: 14 });
var subsidiaryId = x.getValue({ fieldId: 'subsidiary' });```