Skip to content

Tools / CSV Error Translator

An item demand plan has an identity or date mismatch

Distinguish the plan’s identity from its item reference and check the complete planning period.

The plan and item identifiers need checking

Message may mention: internal ID.

What it means

The import is not identifying the intended record.

Import context: Item demand plans.

Check this first

Distinguish the plan's identity from its item reference before changing the mapping.

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

The plan’s body Internal ID identifies the plan for an update. The Item field identifies the item. Check both separately. Read the supported field definitions.

If that looks right

Read Oracle's guidance

Documentation checked September 16, 2026.

The planning dates are inconsistent

Message may mention: start date.

What it means

The plan dates may conflict with its year or end date.

Import context: Item demand plans.

Check this first

Supply a consistent period instead of changing the start date alone.

Show the steps

Check dates, periods, and address values

Dates

  1. Check the importing user's date format in personal preferences.
  2. Compare the actual CSV text with that format, including the year.
  3. If the date is ambiguous, establish the intended date from the source. Do not guess whether 04/05 is April 5 or May 4.
  4. For a period or time range, verify both ends and any accompanying year or view.
  5. Recheck the saved file after editing it in a spreadsheet.

Use the first check above for this record type. Their requirements are not interchangeable.

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