We have custom records and use the ODBC connector to access our data and need to join the custom record to the System Notes. We need to pull this combination into our data warehouse.
Enable System Notes = Yes on our custom records.
I am using the Administrator role.
We are using NetSuite2.com data source, I have navigated to Setup > Records Catalog to see the available fields, feature and permission requirements for the System Note record.
We need to access our custom records', System Notes using NetSuite2.com data source and the ODBC connector but it doesn't look like custom records', System Notes are available using NetSuite2.com data source and the ODBC connector.
Can anyone confirm?
Does anyone know another tool, I can leverage to extract the custom record and its System Notes into a data warehouse?
I know the System Notes are being captured because, using Saved Search in the NetSuite UI, I can join my custom record to its System Notes and I can do the reverse, join System Notes to my custom record to return results.
I tried accessing System Note and defining the Record Type as my custom record using a NetSuite SuiteAnalytics dataset and I did return System Note data but I am unable to pull my custom record details into the dataset.
I tried accessing my custom record and accessing the System Notes using a NetSuite SuiteAnalytics dataset and the System Notes are not available to pull into the dataset.
Thanks all.