Hello all,

We have a role defined for ODBC access to NetSuite for our data warehouse. We need to access the systemnote table to read the history associated with transaction lines (e.g., Sales Orders) to accurately record order bookings (i.e., changes to sales order dates, quantities, prices).

However, even when the role used has full access to the 'Notes tab' list, the result set for select * from systemnote are only those records created by activities of the current signed in user.

If, in the user's role, we select the 'Core Administration Permissions' checkbox, then all rows are returned. However, in our experience this checkbox forces a requirement for two-factor authentication which breaks access via ODBC.