This notice is to inform you of an upcoming change of behavior in Analytics Data Source for custom records.
In NetSuite 2024.2, restrictions can be configured for custom record types using standard segments (subsidiary, department, location, and class). If a custom record type has restrictions that are configured using a custom field of type Multiple Select using a standard segment, and has the Apply role restriction box checked, access is evaluated as described in the following table.
Entry of the custom record type is accessible through Analytics Data Source, Suite QL, ODBC 2.0, and REST if one of the following conditions is met:
For | The role must have access to |
|---|
Subsidiary | all subsidiaries selected in the multiselect field |
Class | all classes selected in the multiselect field |
Location | all locations selected in the multiselect field |
Department | all departments selected in the multiselect field |
What Is Changing
In NetSuite 2025.1, a change will be made to ensure that restrictions are evaluated consistently in all cases. For Analytics Data Source, Suite QL, ODBC 2.0 and REST, NetSuite will evaluate the accessibility of custom record entries in the same way as it does for Search, UI, SuiteScript, ODBC, SOAP and CSV Import/Export. This means that the entry will be accessible if one of the following conditions is met:
(at least) one common | between | selected in a multiselect field | and |
|---|
subsidiary | Subsidiaries | | subsidiaries to which the role has access |
class | Classes | classes to which the role has access |
location | Locations | locations to which the role has access |
department | departments | departments to which the role has access |
For more information, see Behavior of Custom Record Type Restrictions (SuiteAnswers ID: 1019624).
Recommended Actions
This change will impact the Analytics Data Source, ODBC 2.0, and REST channels, and all scripts that use Suite QL to obtain values by conditions from the system. Before your account is upgraded to version 2025.1, you should complete the following tasks.
First, identify the custom record types that use multiple select fields to set restrictions. You can do this in one of the following ways:
- Manually check each custom record type for multiselect fields of type Subsidiary, Class, Location, and Department that have the Apply role restrictions box checked.
- (Using Analytics) create a new Dataset over Custom Field Definition. For more information about creating datasets, see Defining Datasets, SuiteAnswers ID 82518.
Then, compare the current behavior and the new behavior by doing the following:
- Create a Search for a restricted custom record. For more information, see Searching Custom Record Entries, SuiteAnswers ID 51699.
- Compare the data returned from the search. After the new behavior is applied, the dataset results will be the same as the search results
If you need your dataset to return the same data as it did previously, you must reconfigure the subsidiary (and class, location, and department) restrictions on the role or by the data in multiselect fields, if possible.
If you require assistance or more information, please contact NetSuite Customer Support.