Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Over time, as different people create new customers, vendors, or contacts, or you create new records during data migration, there's a risk that you duplicate records. If you find a duplicate, you can use the Merge Duplicate page from the card of the record that you want to keep. The page gives you an overview of duplicated field values and lets you select which values to keep or discard when you merge two records into one.
Note
Only users with the MERGE DUPLICATES permission set can use this functionality.
Tip
The Merge Duplicate page shows all fields where the values are different for the two records being compared. Therefore, if the page shows only a few fields, it might indicate a duplicate. If the page shows many fields, the record probably isn't a duplicate.
The following procedure is based on a customer card. The steps are similar for a vendor and contact cards.
Choose the
icon, enter Customers, and then choose the related link.Select the customer that you know or suspect that a duplicate record exists for, and then choose the Edit action.
On the Customer Card page, choose the Merge With action.
On the Merge Duplicate page, in the Merge With field, select the customer that you believe is a duplicate of the one you opened, which shows in the Current field.
The Fields FastTab lists fields where the values are different for the two customers. This means that if the selected customer is really a duplicate, then only few fields should be listed, such as typing errors and other data entry mistakes.
The Related Tables FastTab lists tables where there are fields with a relation to both customers. The Current Count and Duplicate Count fields show the number of fields in related tables where the No. value of both the current and the duplicate customer is used. On the Merge Duplicate page, this section is informational only. However, if there are merge conflicts, you can resolve them on the Merge Duplicate Conflicts page. Refer to steps 8 through 12.
For each field where you want to use another value than the current one, select the Override checkbox. The value in the Alternate Value field transfers to the current record when you complete the process.
After you specify the values to keep or override, choose the Merge action.
Business Central checks whether the merge of values for the duplicate customer into the current customer causes conflicts. A conflict exists if a value in at least one primary-key field is the same for both customers while the value in the No field is different for the two customers.
If no conflicts are found, choose the Yes button in the confirmation message.
The duplicate customer is renamed so that all use of its No. value in all fields with relations to the customer table are replaced with the No. value of the current customer.
If conflicts exist, choose the Resolve (xx) conflicts before merge action on the Conflicts FastTab, which displays if conflicts exist.
On the Merge Duplicate Conflicts page, select the line for a related table with a conflict, and then choose the View Details action.
The Merge Duplicate page now shows the fields in the selected table that cause a merge conflict between the two customer records. Notice in both the summarised values in the Current and Conflicts With fields and on the lines that at least one primary-key field is the same for both customers and the value of the No. field is different for the two customers.
If you don't want to keep the duplicate customer record, choose the Remove Duplicate action, and then choose the Close button.
Identical field values, other than the value in the No. field, are removed from the duplicate record and inserted on the current record.
If you want to keep the duplicate customer record after the merge, choose the Rename Duplicate.
On lines, not for the No. field, where the field has the same value on both records, change the value in the Alternate Value field, and then choose the Close button.
The conflicting field value is updated on the duplicate record so that it can be merged with the current record. The duplicate record continues to exist after the merge.
Repeat steps 8 through 12 until all conflicts are resolved. The Conflicts FastTab disappears.
On the Merge Duplicate page, choose the Merge action again, and then select the Yes button in the confirmation message box.
Note
For contacts, you can use functionality to find duplicate contacts before you use the Merge Duplicate page. For more information, see Search for duplicate contacts.