Skip to content

Tools / CSV Error Translator

NetSuite cannot identify the record to import

Check which record the identifier belongs to and whether the import expects a name, internal ID, or external ID.

The customer has no primary identifier

Message may mention: Primary name.

What it means

The customer cannot be identified.

Import context: Customers.

Check this first

Use its internal ID, external ID, or customer ID.

Show the steps

Check the record reference

  1. Find the field named in the error on the import's Field Mapping page.
  2. Open its edit control and check the selected reference type.
  3. Compare that setting with the actual CSV value. A number could be a name, an external ID, or an internal ID. Its appearance alone does not establish the type.
  4. Locate the intended record in the same account. Confirm its identity and whether it is available for this transaction.
  5. Correct the file or mapping so they agree. Use a default only when it applies to every affected row.

If you need to see internal IDs, enable them in your personal preferences or include them in a saved-search export. Supported reference types vary by field. Name matching is generally case-insensitive, so changing capitalization alone should not be the standard recommendation.

Reference types

For a duplicate-record message, determine whether you intend to update the existing record or create a different one. Do not generate new external IDs simply to get past the error. For inactive records or subsidiary restrictions, verify the intended business setup before changing it. Those are account decisions, not text-cleanup operations.

If that looks right

Read Oracle's guidance

Documentation checked September 16, 2026.

More than one customer matches

Message may mention: Matched more.

What it means

Several customers fit.

Import context: Customers.

Check this first

Add a unique customer identifier, especially for parent and child customers.

Show the steps

Check the record reference

  1. Find the field named in the error on the import's Field Mapping page.
  2. Open its edit control and check the selected reference type.
  3. Compare that setting with the actual CSV value. A number could be a name, an external ID, or an internal ID. Its appearance alone does not establish the type.
  4. Locate the intended record in the same account. Confirm its identity and whether it is available for this transaction.
  5. Correct the file or mapping so they agree. Use a default only when it applies to every affected row.

If you need to see internal IDs, enable them in your personal preferences or include them in a saved-search export. Supported reference types vary by field. Name matching is generally case-insensitive, so changing capitalization alone should not be the standard recommendation.

Reference types

For a duplicate-record message, determine whether you intend to update the existing record or create a different one. Do not generate new external IDs simply to get past the error. For inactive records or subsidiary restrictions, verify the intended business setup before changing it. Those are account decisions, not text-cleanup operations.

If that looks right

Read Oracle's guidance

Documentation checked September 16, 2026.

The custom list has no mapped identity

Message may mention: CUSTOMLIST, [id, name].

What it means

The list record has no mapped identity.

Import context: Custom lists.

Check this first

Choose a name or supported identifier and map it to the intended field.

Show the steps

Check the record reference

  1. Find the field named in the error on the import's Field Mapping page.
  2. Open its edit control and check the selected reference type.
  3. Compare that setting with the actual CSV value. A number could be a name, an external ID, or an internal ID. Its appearance alone does not establish the type.
  4. Locate the intended record in the same account. Confirm its identity and whether it is available for this transaction.
  5. Correct the file or mapping so they agree. Use a default only when it applies to every affected row.

If you need to see internal IDs, enable them in your personal preferences or include them in a saved-search export. Supported reference types vary by field. Name matching is generally case-insensitive, so changing capitalization alone should not be the standard recommendation.

Reference types

For a duplicate-record message, determine whether you intend to update the existing record or create a different one. Do not generate new external IDs simply to get past the error. For inactive records or subsidiary restrictions, verify the intended business setup before changing it. Those are account decisions, not text-cleanup operations.

If that looks right

Read Oracle's guidance

Documentation checked September 16, 2026.

A revaluation needs an identifier

Message may mention: unique identifier.

What it means

The new revaluation needs an external ID or reference number.

Import context: Inventory cost revaluations.

Check this first

Map the intended identifier.

Show the steps

Check the record reference

  1. Find the field named in the error on the import's Field Mapping page.
  2. Open its edit control and check the selected reference type.
  3. Compare that setting with the actual CSV value. A number could be a name, an external ID, or an internal ID. Its appearance alone does not establish the type.
  4. Locate the intended record in the same account. Confirm its identity and whether it is available for this transaction.
  5. Correct the file or mapping so they agree. Use a default only when it applies to every affected row.

If you need to see internal IDs, enable them in your personal preferences or include them in a saved-search export. Supported reference types vary by field. Name matching is generally case-insensitive, so changing capitalization alone should not be the standard recommendation.

Reference types

For a duplicate-record message, determine whether you intend to update the existing record or create a different one. Do not generate new external IDs simply to get past the error. For inactive records or subsidiary restrictions, verify the intended business setup before changing it. Those are account decisions, not text-cleanup operations.

If that looks right

Read Oracle's guidance

Documentation checked September 16, 2026.

The transaction needs a unique identifier

Message may mention: unique identifier.

What it means

The import needs a supported transaction identifier.

Import context: Transactions.

Check this first

Choose one appropriate to the record and operation.

Show the steps

Check the record reference

  1. Find the field named in the error on the import's Field Mapping page.
  2. Open its edit control and check the selected reference type.
  3. Compare that setting with the actual CSV value. A number could be a name, an external ID, or an internal ID. Its appearance alone does not establish the type.
  4. Locate the intended record in the same account. Confirm its identity and whether it is available for this transaction.
  5. Correct the file or mapping so they agree. Use a default only when it applies to every affected row.

If you need to see internal IDs, enable them in your personal preferences or include them in a saved-search export. Supported reference types vary by field. Name matching is generally case-insensitive, so changing capitalization alone should not be the standard recommendation.

Reference types

For a duplicate-record message, determine whether you intend to update the existing record or create a different one. Do not generate new external IDs simply to get past the error. For inactive records or subsidiary restrictions, verify the intended business setup before changing it. Those are account decisions, not text-cleanup operations.

If that looks right

Read Oracle's guidance

Documentation checked September 16, 2026.

Browse all errors

Still stuck?

We can help you work through the file, the mapping, and the NetSuite setup behind the error.

Talk to MySuite

Last updated:

NetSuite Implementation Advisory & Administration