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 all! I'm giving SuiteQL a first real try and am having a hard time getting the invoice amount field out of SQL. Any ideas what the field ID is?

probably want to first try in the analytics ui to create your dataset

<https://system.netsuite.com/app/common/report/list.nl>

Is there not a way to join datasets in this UI? It only seems to let me work with one at a time...

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1543418452.html|Guidelines for Joining Record Types in SuiteAnalytics Workbook>

Watched the help video, figured it out, not how I would have guessed it'd work