Scenario:
When attempting to import Journal Entries using a CSV file, the user may encounter the following error message:
"A record with this ID already exists. You must enter a unique ID in order to create or update this record."
This error typically occurs when the system detects that an External ID (used to uniquely identify records during import) has already been assigned to another existing Journal Entry in NetSuite. Since External IDs must be unique, using the same ID more than once will cause the import to fail.
The error is triggered when the CSV file contains an External ID that already exists in the system—either from a previous import or manually created entry. NetSuite requires that all External IDs be unique to prevent data duplication or overwriting of existing records.
Solution:
Importing Journal Entries with Unique External IDs
To resolve this issue, follow the steps below to ensure a proper and error-free CSV import:
- Prepare Your CSV File
- Ensure the file is saved in CSV format
- Verify that each row (Journal Entry) includes a unique External ID. Avoid reusing IDs from previous imports
- Navigate to Import Tool
- Go to Setup > Import/Export > Import CSV Records.
- Import Setup ( Import Type: Select Transactions | Record Type: Select Journal Entry | CSV File(s): Upload the prepared file )
- Click Next to proceed
- Import Options
- For Data Handling, choose Add (to create new records)
- Click Next
- Field Mapping
- Map fields from your CSV file to the corresponding NetSuite fields
- Ensure the External ID field is properly mapped
- Click Next
- Save Import
- Enter a unique name for your import map
- Confirm that all configurations are correct
- Click Save & Run to begin the import
TIPS:
- Always verify that the External ID column in your CSV is populated with values that haven’t been used before in your NetSuite account.
- You can perform a saved search or review past import summaries to identify used IDs.
Hope this helped!