Stopping the creation of duplicate contacts

Does anyone have any suggestions on how to stop the creation of a new contact record when a duplicate Email Address is used? I’m thinking of trying to use either a Method or Data Directive, but not totally sure the best way to get there. I’m thinking Data Directive on the PerCon table when a new record is being created to validate against other email addresses in the table. I’m just not sure if that will stop the creation of the record on items such as the CustCnt table. I’m trying to do some testing in between projects and other day-to-day needs, which is not going very quickly but I was hoping someone else might have already run into this and possibly have some suggestions.

Eric, I’ll be following this one closely.

In general I get confused about contacts. You can end up with a million duplicates.

I feel like there is a built in way to avoid this already, is there not?

There is the built-in Partial Match function, but it is counter-intuitive. You have to make a selection and then click “CANCEL” in order to use the already existing contact. It is completely opposite for everything else in the system…select the record you want to use and click “OK”…A major mistake on Epicor’s part IMHO!

2 Likes

OKAY THANK YOU!!! I was so confused about how that screen worked!!! That’s why I never understood it.

select an existing row you would like to use + Cancel = contact not created, existing contact used.

is that right?

As far as I understand it and my testing has been confirmed. You can confirm on your end, but that’s what I found to be true.

you are right. Wow, never noticed that.

That Partial Match Contact screen is hopelessly confusing. Users freeze up when they see it and end up making an absolute mess out of contact data.

2 Likes