Discussions
SuiteWorld is where the NetSuite community comes together to learn, connect, and discover what’s next.
Whether you’re looking for product updates, practical tips, new ways to improve efficiency, or insights from other customers, SuiteWorld offers something for every stage of your NetSuite journey.
■ NetSuite 2026.2 Release Notes
■ NetSuite SuiteApps Release Notes
■ NetSuite Sneak Peeks
■ Release Preview Guide
■ Release Preview Test Plan Template
What roles permissions are required to query Vendor Credits via SuiteQL
Hi Team,
What roles permissions are required to get all the Vendor Credits via SuiteQL.
Please note: I am able to fetch 'Vendor Bills' from transaction table.
SELECT transaction.* FROM Transaction INNER JOIN TransactionLine ON (TransactionLine.Transaction = Transaction.ID) where lower(Transaction.Type) IN ( 'vendbill' )
But when I am trying to get 'Vendor Credits', it is not returning any data.
Below is the SQL I am using:
SELECT transaction.* FROM Transaction INNER JOIN TransactionLine ON (TransactionLine.Transaction = Transaction.ID) where lower(Transaction.Type) IN ( 'vendcred' )
I am using the below REST method to fetch the data:
https://xxxxxx.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql