I am using var recordOwner = nlapiLookupField('salesorder', idToCheck, 'entity'); to fetch the record in service controller. And this query is not returning any record and when I run the same query on my console it provides me the data. Can anyone help ?

Which script type is it?

SS 1.0

I meant is it a UE or client script?

backend Suitescript file

This should work in that case. And should return the value: var recordOwner = nlapiLookupField('salesorder', <salesorderid>, 'entity'); You might want to log the salesorderid before you do the lookup and see if that's indeed the correct id.

yes the id is correct and still not able to get the data.

what role is the deployment and does that role have access to the sales order

yes I have given elevated permission and the role has the following permission

i advise logging in via that role and seeing if you can search for that sales order

yes I am able to search that sales order

and you can do the lookup in the console

res in that I am able to get the data

too weird, I would have guessed permission issue but your followup suggests otherwise

Could be a permissions issue with the script though, Check what role does script run on, as current user or any other role. Also, then log the role when you run the script from wherever you are running, let's see what role does that log.

how can print the role in service ?

In your Suitelet. I am assuming it is Suitelet/Restlet just do a var userRole = nlapiGetRole( ); and print it's value. Also, can you share a screen-shot your your deployment screen.