netsuite turning duplicate detection off what will happen to the existing records what is the risk?

AI generated answer (using internal Slack threads):

If you turn off duplicate detection in NetSuite, the system will no longer prevent you from creating duplicate records. This means that you could potentially end up with multiple records for the same entity, which can lead to confusion, data inconsistency, and potential errors in reporting or processing. As for the existing records, turning off duplicate detection will not affect them directly. They will remain as they are. However, without the duplicate detection, you might unknowingly create new duplicates of these existing records. The risk associated with turning off duplicate detection is primarily related to data integrity. Having duplicate records can lead to confusion and errors. For example, you might update one record, not realizing that there is a duplicate that also needs to be updated. This can lead to inconsistencies in your data. Additionally, duplicate records can skew your reports and make it difficult to get an accurate view of your data. It's also worth noting that NetSuite's native deduplication check is quite strict and doesn't allow for flexible matching such as regular expressions. It also doesn't let you inactivate merged non-master records - it deletes them. This can be a limitation depending on your specific needs. If you have different types of records (e.g., customer and contact) with the same email, standard duplicate detection won't work across these different record types. You'd have to create your own duplicate detection using a workflow or script. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******