ANS-1231 · CSV IMPORT & DATA MIGRATION
Why Does NetSuite Show ‘Unparseable Internal ID’ During Chart of Accounts Import?
This error typically occurs when a CSV import references an internal ID that NetSuite cannot locate or recognize, often due to incorrect data in a subsidiary mapping.
Short answer
The 'Unparseable Internal ID' error during a NetSuite Chart of Accounts import indicates that a referenced internal ID in the CSV file is either missing or incorrectly formatted. This commonly happens when a subsidiary mapping or other list reference contains an invalid value, such as '#N/A'. Correcting the invalid internal ID in the CSV file resolves the import issue.
Scenario
Users attempting to import a Chart of Accounts into NetSuite may encounter an 'Unparseable Internal ID' error. This error indicates that NetSuite has identified at least one line within the CSV import file that references another list or record using an internal ID that cannot be found or is incorrectly formatted within the system.
Solution
The 'Unparseable Internal ID' error is typically caused by an invalid reference to an internal ID within the import CSV. To resolve this issue:
Review the CSV file used for the Chart of Accounts import.
Identify any columns that map to internal IDs of other records or lists, such as 'Subsidiary Internal ID'.
Locate any instances where these internal ID fields contain invalid values, for example,
#N/A.Correct the invalid internal ID references to valid, existing internal IDs within NetSuite.
Re-attempt the Chart of Accounts import with the corrected CSV file.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support