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

is there a way to find record type by internalid or any other method, use case is that I need to update resource cost on projects, and a resource can be an employee or a vendor, there is no search column which provides that, so all i have is internal id to lookup and get values, can we get record type by internalid or any other way in ss1 or ss2 ?

<@UHP0BBX54> Haha beat me to it :laughing:

But, <@U29QCJQF3> your response was probably more helpful - screenshot and all! As always...

Theoretically the same entity could have multiple record types, for example via "Other Relationships" a vendor and customer could share the same internalid. But I don't think a vendor and employee could

if you search entity you dont get labor cost and other required fields - the search is pretty limited - moreover i have to do a load record -

You would search to get the record type to load. This came up on here before, and the other way to do this is try/catch loading the different record types, which I benchmarked and it's surprisingly faster than a search in fact

hmm.. thanks all, seems netsuite deliberately locks out missing important pieces, dont have any thing to update new costs to project task assignments

Yep I actually still have that code in my chrome snippets

no mass update, no csv, no direct search, complex coding seems to be only option

can you share - it would save me some time - i will owe you one :slightly_smiling_face:

```require(['N/search', 'N/record'], (search, record) =&gt; {
    console.time("lookupFields");
    console.log(search.lookupFields({ type: search.Type.TRANSACTION, id: 21295252, columns: 'recordtype'}))
    console.timeEnd("lookupFields");
    
    console.time("recordload");
    try {
        console.log(record.load({ type: record.Type.SALES_ORDER, id: 21295252 }));    
    } catch(error) {
        console.log(error);
    }
    console.timeEnd("recordload");
});```

thanks anyways for all your valuable inputs

Oh sorry, I haven't touched projects / tasks before

its a mess - strangely not even exposed to search, csv, update or even suiteanalytics