Duplicate Detection Rules

In CRM, we do have an OOTB functionality which lets you check for duplicates. This would however, would not stop one from saving the record but letting know the operator that there is a duplicate. This is in a way good as it, lets the operator decide whether to use the existing record or to continue with using a new record.

There are some good features of this as well as there are some limitations.

Main limitations are

• You can have only 5 published duplicate detection rules per entity
• The combination of the match code cannot exceed 450.

These probably have been given to stop one from having performance issues.

If you want a new rule and the entity has exceeded the rule limitation, then you would have to unpublish one rule and get this created. For on premise CRM instances you can change this, but it is unsupported. For Online instances, the unsupported cannot be done.

For Match code though you have alternatives. However, this might not always work, but would be good to know them as well.

For an instance when you create a record for contact and if you want to check for duplicates using first name, last name and street 1, the match code length becomes 352. Now it would be difficult for you to add couple more fields as you only have spare 98 length left from 450.

Most of the time street1 length would not exceed for a live record more than 50(Depends on the requirement). If this is the case then what we can do is instead of having the criteria as “Exact Match”, we can have the filter as “Same First Characters” and give a character length of 50. By doing this we can reduce the match code from 352 to 152, which allows us to add more fields if required.

Apart from that, you do have the operator “Same Last Characters” and can give the character length too.

Also one good thing about this is you can check against another different entity as well. If you need to check when creating a lead record, whether there are contact records with a matching criteria this is also possible.

Apart from that you can check for the following as well.

• Case sensitiveness of characters
• Include/Exclude inactive records
• Ignore blank records