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

Weirdness with N/task.SuiteQLTask. :netsuite:
Below join to accountType makes the query fail in task.SuiteQLTask but not in query.runSuiteQL
`JOIN accountType ON account.acctType = accountType.id`

I can't even run `SELECT * FROM accountType`  in SuiteQLTask. Seems like someone forgot to add support for that table :rage:

Very.
I had like 12 tables in a rather large query that I wanted to run. 2 tables were not available for some reason. accountType was one of them and the other was one of our custom segments. (just one of them, other worked)

<@UP0GS40AF> there's no difference in roles/permissions between the contexts for these two different approaches?

No, both were executed with administrator