ANS-1792 · CSV IMPORT & DATA MIGRATION
How Does NetSuite Handle Duplicate Document Numbers in CSV Imports?
Learn how NetSuite's auto-generated numbering and override settings interact with CSV imports, potentially leading to duplicate transaction IDs.
Short answer
When NetSuite's auto-generated numbers have "Allow Override" enabled, CSV imports can introduce custom IDs, potentially creating duplicate transaction numbers. NetSuite now provides "Duplicate Number Warnings" and "Advanced Numbering" features to detect, warn about, or prevent these duplicates during the import process, enhancing data integrity.
Scenario
When importing transactions via CSV into a NetSuite account configured with auto-generated numbers where the "Allow Override" option is enabled, it is possible to introduce custom document numbers. This configuration allows the system to accept IDs provided in the CSV file, which can inadvertently lead to the creation of transactions with duplicate document numbers.
Solution
When transactions are added through CSV Import in a NetSuite account where auto-generated numbers are enabled with the 'Allow Override' option checked, it is possible to create transactions with duplicate document numbers. While this setting permits the import of custom IDs, NetSuite now includes features such as 'Duplicate Number Warnings' preferences and 'Advanced Numbering' capabilities. These features are designed to detect and prevent duplicate document numbers during CSV imports, or at minimum, provide warnings to users about potential duplicates.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support