Entity Deduplication Task for Record Merging in NetSuite

The Entity Deduplication Task is crucial for maintaining the integrity of your data in NetSuite by enabling the efficient merging of duplicate records. Using the N/task module, developers can create and manage tasks specifically designed for this purpose.

What Is the Entity Deduplication Task?

The EntityDeduplicationTask allows users to submit a task to merge duplicate records within the NetSuite system. This capability ensures that data remains clean, reducing redundancy and improving accessibility across the database.

How to Create an Entity Deduplication Task

To create an EntityDeduplicationTask, use the task object from the N/task module, where you can define several properties:

• dedupeMode: Specify the merging mode for the records using options from the task.DedupeMode enumeration.
• entityType: Designate the entity type to merge duplicates, which can be referenced from the task.DedupeEntityType enum.
• recordIds: Provide an array of internal IDs of the records to be merged.
• masterRecordId: Assign the ID of the master record into which other duplicate records will be merged.
• masterSelectionMode: Use this to define how the master record is chosen, using values from the task.MasterSelectionMode enum.

Submitting the Task

To submit the task, invoke the following method:

1const task = require('N/task');
2 
3let dedupeTask = task.create({
4    taskType: task.TaskType.ENTITY_DEDUPLICATION,
5    entityType: 'customer',
6    recordIds: [1, 2, 3],
7    masterRecordId: 1,
8    masterSelectionMode: task.MasterSelectionMode.MOST_RECENT
9});
10 
11let taskId = dedupeTask.submit();

This code snippet defines and submits a deduplication task where duplicates are merged into the most recent record.

Monitoring Task Status

After submitting the EntityDeduplicationTask, you can monitor the task’s status using the EntityDeduplicationTaskStatus object. Properties such as taskId and status provide critical insights into the processing state of the task.

Example for Checking Status

let taskStatus = task.checkStatus({ taskId: taskId });
console.log(`Current status: ${taskStatus.status}`);

Conclusion

The EntityDeduplicationTask is a powerful tool for developers seeking to maintain data hygiene within NetSuite. It facilitates prompt identification and merging of duplicate records, thus enhancing operational efficiency and accuracy.

Key Features:

• Asynchronous processing of tasks.
• Integration with other tasks like CSV imports and queries.
• Various modes for deduplication and entity selection.

Key Takeaways:

• Use the N/task module to manage deduplication tasks efficiently.
• Different deduplication modes cater to varying business needs.
• Monitoring status ensures seamless task management.

Source: This article is based on Oracle's official NetSuite documentation.