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

How can I query custom fields with SuiteQL?

```SELECT
	Transaction.TranID,
	Transaction.TranDate,
	Transaction.Type,
	Transaction.Status,
	Transaction.Entity,
	Transaction.Employee,
	Transaction.dueDate,
    Transaction.customFieldHere....
FROM
	Transaction
WHERE
	(Transaction.TranID = 'INV2285117' )```

use the internal field ids, eg. custbody_my_field