[Netsuite] Getting Started with Netsuite Permissions

Use Case

You are interested in setting up a Netsuite connector but are not sure about which permissions to get started with. You are looking for a core set of Fivetran tables and respective Netsuite permissions to begin syncing data.

Fivetran Recommendation

Fivetran recommends starting with the main tables used in our Netsuite dbt package. These are a great place to get started, and you can always add more tables later to meet your specific business needs.

1. Confirm you have the following Netsuite prerequisites:

   • A NetSuite SuiteAnalytics administrator account

   • A NetSuite administrative account

   • The SuiteAnalytics Connect Service enabled

   • A NetSuite login email

   • A NetSuite password
     

2. Follow our Netsuite Setup Guide

3. In Step 4 of the NetSuite Setup Guide (“Table Permissions”), follow this table for each table to add the permissions:
   

   TABLE	SUBTAB	PERMISSION NAME
   accounts	Lists	Accounts
   accounting_periods	Setup	Manage Accounting Periods
   accounting_books	Transactions	Make Journal Entry
   consolidated_exchange_rates	Lists	Currency
   currencies	Lists	Currency
   customers	Lists	Customers
   classes	Lists	Classes
   departments	Lists	Departments
   expense_accounts	Lists	Accounts
   income_accounts	Lists	Accounts
   items	Lists	Items
   locations	Lists	Locations
   partners	Lists	Partners
   transaction_lines	Setup	Custom Column Fields
   transactions	Transactions	Find Transaction
   subsidiaries	Lists	Subsidiaries
   vendors	Lists	Vendors

4. Complete the connector Setup
5. Enable the tables in your “Schema” tab
6. Initiate the historical sync
7. Validate data meets business needs in warehouse
8. (Optional) Set table permissions after initial setup for additional tables