Oliver Andersson
01/09/2025, 12:09 PMCeligo AI
01/09/2025, 12:09 PMAI generated answer (using internal Slack threads):Yes, standard item fields also have an internal ID and an external ID. The internal ID is a unique identifier assigned by NetSuite to each record and field, while the external ID is a unique identifier that you can assign to a record for use in external systems. To check the internal ID of a standard field, you can navigate to the field in the NetSuite UI, and the internal ID will be displayed in the URL. For example, if you navigate to an item record, the URL might look something like this:
<https://system.netsuite.com/app/common/item/item.nl?id=1234>
. In this case, 1234
is the internal ID of the item.
To check the external ID of a record, you can use a custom field and source the "external id" value from the native field. However, by default, you cannot access the external ID from the UI. You can set the external ID (which must be unique) for the records via CSV import.
If you want to display the external ID on the item record itself in the UI, you can create a custom text formula field with the formula {externalid}
. This will show the external ID whenever anyone brings up the form. Alternatively, you can create a calculated field and use a formula to show it.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
01/09/2025, 12:10 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838635087
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836962163
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833750844
Celigo AI
01/09/2025, 12:10 PM