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

Hi All
Does anyone know how to access the custom fields on the InventoryNumber table in <http://NetSuite2.com|NetSuite2.com> ODBC data source? It appears that these fields are not available when transitioning from <http://NetSuite.com|NetSuite.com> ODBC data source.

Do you have access to SuiteQL? Is it not showing in OA_COLUMNS?

SELECT * FROM OA_COLUMNS WHERE COLUMN_NAME = 'your_field_id'