Skip to main content

NetSuite

NetSuite ERP connector for managing customers, vendors, employees, invoices, sales orders, purchase orders, and accounting records.

Categories: ERP, Accounting

What you can ask​

  • List open invoices over 30 days past due, by customer.
  • Pull total revenue by region for Q1 and rank by largest.
  • Find purchase orders pending approval longer than 5 days.

Set up​

NetSuite needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.

  1. Go to Organization > Connectors and find NetSuite. Click Enable, and choose which tools to allow.
  2. Create an OAuth application in the NetSuite developer portal.
  3. Add the Redirect URI shown in the connector settings to the application.
  4. Copy the application's Client ID and Client Secret into the connector, then save it.
  5. Each member connects their own account the first time they use it.

⚠️ Warning: Do not enter your Devs.ai or NetSuite login email or password in the OAuth application fields.

To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.

OAuth scopes used by these tools (1)

Grant the scopes for the tools you plan to allow.

  • rest_webservices

Tools​

NetSuite offers 75 tools. Admins choose which ones agents can use. See Tool permission groups.

Read (38)​

View and search information without changing it.

ToolWhat it does
get_accountGet a NetSuite account by internal ID.
get_contactGet a NetSuite contact by internal ID.
get_credit_memoGet a NetSuite credit memo by internal ID.
get_customerGet a NetSuite customer by internal ID.
get_customer_paymentGet a NetSuite customer payment by internal ID.
get_employeeGet a NetSuite employee by internal ID.
get_estimateGet a NetSuite estimate by internal ID.
get_inventory_itemGet a NetSuite inventory item by internal ID.
get_invoiceGet a NetSuite invoice by internal ID.
get_journal_entryGet a NetSuite journal entry by internal ID.
get_purchase_orderGet a NetSuite purchase order by internal ID.
get_sales_orderGet a NetSuite sales order by internal ID.
get_subsidiaryGet a NetSuite subsidiary by internal ID.
get_vendorGet a NetSuite vendor by internal ID.
get_vendor_billGet a NetSuite vendor bill by internal ID.
list_accountsList NetSuite accounts (chart of accounts) with pagination.
list_classificationsList NetSuite classifications (classes).
list_contactsList NetSuite contacts with pagination.
list_credit_memosList NetSuite credit memos with pagination.
list_currenciesList NetSuite currencies.
list_customer_paymentsList NetSuite customer payments with pagination.
list_customersList NetSuite customers with pagination.
list_departmentsList NetSuite departments.
list_employeesList NetSuite employees with pagination.
list_estimatesList NetSuite estimates/quotes with pagination.
list_inventory_itemsList NetSuite inventory items with pagination.
list_invoicesList NetSuite invoices with pagination.
list_journal_entriesList NetSuite journal entries with pagination.
list_locationsList NetSuite locations.
list_non_inventory_itemsList NetSuite non-inventory items (items not tracked in inventory) with pagination.
list_purchase_ordersList NetSuite purchase orders with pagination.
list_sales_ordersList NetSuite sales orders with pagination.
list_service_itemsList NetSuite service items (services sold to customers) with pagination.
list_subsidiariesList NetSuite subsidiaries.
list_vendor_billsList NetSuite vendor bills with pagination.
list_vendorsList NetSuite vendors with pagination.
run_suiteqlExecute a SuiteQL query against NetSuite.
validate_credentialValidate NetSuite credentials by making a test API call.

Write (13)​

Create or send data.

ToolWhat it does
create_contactCreate a new NetSuite contact.
create_credit_memoCreate a new NetSuite credit memo.
create_customerCreate a new NetSuite customer.
create_customer_paymentCreate a new NetSuite customer payment.
create_employeeCreate a new NetSuite employee.
create_estimateCreate a new NetSuite estimate.
create_inventory_itemCreate a new NetSuite inventory item.
create_invoiceCreate a new NetSuite invoice.
create_journal_entryCreate a new NetSuite journal entry.
create_purchase_orderCreate a new NetSuite purchase order.
create_sales_orderCreate a new NetSuite sales order.
create_vendorCreate a new NetSuite vendor.
create_vendor_billCreate a new NetSuite vendor bill.

Delete or overwrite (24)​

Remove or replace existing data.

ToolWhat it does
delete_contactDelete a NetSuite contact by ID.
delete_credit_memoDelete a NetSuite credit memo by ID.
delete_customerDelete a NetSuite customer by ID.
delete_customer_paymentDelete a NetSuite customer payment by ID.
delete_employeeDelete a NetSuite employee by ID.
delete_estimateDelete a NetSuite estimate by ID.
delete_invoiceDelete a NetSuite invoice by ID.
delete_journal_entryDelete a NetSuite journal entry by ID.
delete_purchase_orderDelete a NetSuite purchase order by ID.
delete_sales_orderDelete a NetSuite sales order by ID.
delete_vendorDelete a NetSuite vendor by ID.
delete_vendor_billDelete a NetSuite vendor bill by ID.
update_contactUpdate an existing NetSuite contact.
update_credit_memoUpdate an existing NetSuite credit memo.
update_customerUpdate an existing NetSuite customer.
update_employeeUpdate an existing NetSuite employee.
update_estimateUpdate an existing NetSuite estimate.
update_inventory_itemUpdate an existing NetSuite inventory item.
update_invoiceUpdate an existing NetSuite invoice.
update_journal_entryUpdate an existing NetSuite journal entry.
update_purchase_orderUpdate an existing NetSuite purchase order.
update_sales_orderUpdate an existing NetSuite sales order.
update_vendorUpdate an existing NetSuite vendor.
update_vendor_billUpdate an existing NetSuite vendor bill.
⌘J