ExtendInsights for Data Management (NetSuite) allows you to use NetSuite Internal IDs to reference valid values in picklist (list/record) fields, such as:
Entity (Customer, Vendor, Employee)
Location
Department
Class
G/L Account
Other list-based fields
This approach is especially useful for power users, large datasets, and scenarios where performance and accuracy are critical.
Why Use Internal IDs?
Using internal IDs can help you:
Avoid ambiguity when multiple values have similar names
Improve upload performance
Eliminate the need for name-based lookup
Ensure precise mapping for bulk updates
How to Use Internal IDs in ExtendInsights
To reference a picklist value by its internal ID:
Find the internal ID of the NetSuite value you want to use. For example, the ID of the G/L account, department, or entity.
In Excel, enter that ID in the cell for the corresponding picklist field.
Wrap the ID in double brackets.
Example: If the G/L account’s internal ID is 567, enter:
[[567]]
When you upload the data:
ExtendInsights recognizes the value as an internal ID
NetSuite maps the field directly to the correct record
No text-based lookup is performed
Use Cell Operations if you don’t know the ID
You don’t need to look up or enter internal IDs manually. Use Cell Operations (Picklists) to search for and select a valid NetSuite value. ExtendInsights resolves the selected value for you.
Need Help?
If you’re unsure which internal ID to use or whether this approach fits your use case:
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat
✉️ Email cloudextend-support@celigo.com
📎 Include the field name and record type if possible.