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.
Question: Is there a different permission that would grant a user in that role access to all rows in the systemnote table? Or, if Core Administration Permissions' is required, is there a way to, by exception, disable the 2FA requirement for a specific user?
Here's the query that joins transactionline and systemnote that isn't returning results for all users unless 'Core Administration Permissions' is checked on the role used:
select t.trandisplayname, BUILTIN.DF(tl.item), tl.id, n.*
from transaction t
left join transactionline tl on t.id = tl.transaction
left join systemnote n on tl.transaction = n.recordid and tl.id = n.lineid
where t.id = '<transinternalid>';
Thanks for any guidance.
Regards,
David