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

image.png

For some reason, I can't fetch custom transactions (sales) using suiteql, although I can fetch all other transactions.

I tried to find a permission specific to it, but I couldn't find it. Any ideas?

This fetches the definition, I was trying to fetch the records. I will try to add some permissions.

Yeah I figured after I sent that message, I'll have a look

Using Administrator and Developer role I can pick up a custom sale transaction from TRANSACTION table fyi

What role are you using? Sometimes it should complain about not having a certain permission also.

I assume you don't have Admin/Developer access?

When I use SuiteQL from the UI, with the Administrator role, I get the record.

But from the REST API, I don't get anything back.

Did you try REST api with Adminstrator too?

You can't create an access token using the Administrator role.

Pretty sure you can, I would confirm the permission limitation by hitting the rest api with a role with higher privileges

I will try to add all the permissions I can.

try log in with Admin and generate the token from the dashboard, manage access tokens

That menu should prompt you to choose an application/integration not a Role

What I sent earlier is the choices in the Role menu. It is what is relevant in this context.

I understand, but you could bypass the role selection by using the role you are already logged in with by going to Manage Access Tokens from the Home Dashboard and not from Setup &gt; Users/Roles &gt; Access Tokens

It worked. :partying_face:

I didn't know that. Thanks very much :pray::heart:

No probs.  If it works for Developer also, you could <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N292157.html|compare> the developer and your custom role and try spot the difference.

Under the role, under Permissions Transactions list you need to add in each custom transaction type, I believe.