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

I connected Netsuite tables via ODBC to Excel
• Anything in NetSuite with the category “Custom Record” does not show up in the “Roles1" db table
• It appears that names can be changed on the front end without reflecting on the back end. For example, the “Roles1” table shows a permission_name as “Jobs”, but in the front end it shows up as “Projects”. Someone changed the name but the database was not updated.
Datasource is <http://Netsuite.com|Netsuite.com>

You cannot write to the DB in any way. It is read only. Any name changes you make will not be reflected 

I think <@U0102B97XBM> means that the record was renamed in NetSuite (Setup &gt; Company &gt; Rename Records/Transactions), but that doesn't (and shouldn't!) change the schema

<@U0102B97XBM> regarding the custom records, this might be permission related. Does the role you are using for ODBC have access to the custom records in question?

<@U29QCJQF3> thanks - i do have the permissions for custom records - also any idea why a name change wouldnt display in the back end?