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

whats the suiteql behind the 2 different queries?

Is there suiteql behind the queries? How do I check that?

<https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_157960623712.html|Converting an Existing Query to SuiteQL>

<https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_157960443690.html|SuiteQL.query> and occasionally <https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_157960427733.html|SuiteQL.params> have the interesting bits

can you setup a formula in the ui to get internal ids?