Merging Different Types of Records

Sometimes duplicate records exist between record types, such as a vendor record and a partner record for the same person or company. The Duplicate Detection feature only searches for possible matches within the same record type, but if you know of duplicated between two record types, you can merge them manually.

Note:

System notes are not transferred from duplicate entity records to the primary entity record during a merge. Merging entities updates the system notes and last modified date for all transactions associated with the duplicate entity or entities. The system notes for these transactions will indicate that they were updated by the Duplicate Resolution process.

Warning:

Merging entities is a data-intensive operation, and complex merges of many records such as transactions, custom fields, or workflows may time out when processing. You should test the merge process in a sandbox account first to ensure that it can be completed.

You should designate the entity with the most transactions as the primary record and entities with fewer transactions as duplicates to reduce the time it takes to complete the merge. You should also avoid merging entities with large numbers of transactions whenever possible.

You can merge records between the following record types:

You must have full permissions for the entity types you are merging. For example:

Merging Customer/Vendor Entities in Different Subsidiaries

You can merge Customer/Vendor entities across subsidiaries, creating a single multi-subsidiary Customer/Vendor entity. Merging two entities from different subsidiaries results in the following:

  • The primary subsidiary becomes the Master Entity subsidiary.

  • The Duplicate Entity subsidiary becomes a secondary subsidiary for each entity.

  • The Contact from the primary subsidiary is linked and synchronized with the primary entity.

To merge records of different types:

  1. Open the duplicate record you want to merge into a primary record in edit mode. Do not make any changes to the record.

  2. Click Merge. This opens a new page.

  3. In the Master field, select the name of the customer, partner, or vendor record into which the record should be merged.

    The record selected in the Master field becomes the primary record.

  4. A summary of the files to be merged will appear in the Duplicate/Master Summary.

  5. Click Save.

The merged record opens. All activities, transactions, messages, files, cases, contacts, and other subtab lists are combined on the merged record. Fields previously blank on the primary record are filled with information from the duplicate record, but no field data is replaced.

Note:

Administrators can restrict the ability of users to merge records. For more information about how to limit the merge function by role, see Duplicate Entity Management Permission.

Related Topics

General Notices