Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | NetSuite2.com: Unable to Access Location-Related Tables
Some users find that their ODBC connection does not have state, province, and country tables listed and encounter the error: Base table: state not found.
To resolve this, the permission named “Set Up Company” must be added to the integration role being used. This can be done by following these steps:
- Go to Setup > Users/Roles > Manage Roles
- Open the integration role in Edit Mode
- Under the Permissions subtab, go to Setup > Add Set Up Company and set its Level to at least View.
After this, you can reconnect your ODBC/JDBC Integration to apply the changes and rerun your query.
Refer a Member to the Community | Earn the Answer Accepter Badge | Vote for the contents you'd like to see
Tagged:
1