This notice is to inform you of an upcoming change to the IDs used for custom segments in SuiteAnalytics Workbooks, SuiteScript 2.x Analytics APIs including SuiteQL, and SuiteAnalytics Connect queries. This change will provide consistency in how custom segments are identified across different channels. To prevent issues after this change, you may need to update your workbooks, scripts, or SuiteAnalytics queries.
ID types affected by this change are:
- Legacy ID - uses different record type-specific prefixes for a custom field that is used with multiple different record types.
- Unified ID - uses the same script ID without any prefixes on all record types.
What Is Changing
After your account is upgraded to NetSuite 2023.2, custom segments in your account will use the unified ID instead of the legacy ID for SuiteAnalytics Workbooks, SuiteScript 2.x Analytics APIs including SuiteQL, and SuiteAnalytics Connect queries. Custom segment IDs in other channels will not change.
Required Actions
After your account is upgraded to 2023.2, you must do the following:
- Check if you have any custom segments defined in Customization > Lists, Records & Fields > Custom Segments.
- If the answer to Step 1 is no, you have nothing to do. Note: For more details about custom segment IDs, see Identifying the Correct Script ID for a Custom Segment.
- If the answer to Step 1 is yes, investigate where custom segments are used in your account. If custom segments are used in SuiteAnalytics Workbooks, SuiteScript 2.x Analytics APIs, or SuiteAnalytics Connect queries, you must make appropriate changes to facilitate the new unified ID.
- For more details about how to make these changes, see the Where the ID Change will Occur table in Custom Segment IDs: Change from Legacy ID to Unified ID, SuiteAnswers ID 1013295.
Complete the following:
- SuiteAnalytics Workbooks: If you use datasets and workbooks of type Custom Field Definition, that Script ID column will now return the unified ID instead of the legacy ID. The internal ID of the field won't change. Therefore, you can map the old script ID to the new script ID using the internal ID.
- SuiteScript 2.x Analytics APIs (including SuiteQL): If you use a CustomField record, you must update your scripts to work with the new unified script ID for unified segment fields.
- SuiteAnalytics Connect: Affects NetSuite2.com data source only. If you use this channel to export data from NetSuite and mapping in an external system using a script ID, you must make changes in your scripts/API to support mapping the old script ID to the new script ID. If you use custom segment IDs in your queries (especially in filters) you must update your queries to work with the new unified script ID. For more information, see the Where the ID Change will Occur table in Custom Segment IDs: Change from Legacy ID to Unified ID, SuiteAnswers ID 1013295.
For more information, see Identifying the Correct Script ID for a Custom Segment, SuiteAnswers ID 49346 and Custom Segment IDs: Change from Legacy ID to Unified ID, SuiteAnswers ID 1013295.
If you require assistance or more information, please contact NetSuite Customer Support.