Merging Customer Records

Epicor ERP 10
1

From time to time we get multiple customer records, usually from web orders. Is there any way to merge them?

1 Like
2

no.
for the ā€˜badā€™ customers you can deactivate all the Valid Payer, Bill To, Ship To, OTS to flags
and if there are any open invoices you can create a national account relationship with a parent - so you can share cash from the other parent customers

1 Like
3

There isnā€™t currently. We rename duplicates with z[CustName]. Anything starting with a z we known not to use. We get duplicates from leads every now and then. A CRM call record gets added and there isnā€™t a way to merge or delete. Appending the z was the best thing we could come up with. Was actually a recommendation from Epicor support.

4

This has to be a common enough issue to warrant a merge function, right? Can we put in a request?

3 Likes
5

I submitted a ticket requesting it. But they just closed the ticket and didnā€™t create a feature request. :man_shrugging:t2:

6

Well maybe we harass some people at Insightsā€¦ :smiley:

7

It wouldnā€™t help with existing ā€œdupsā€, but there might be a way to reduce them from happeneing.

When saving a new customer, E10 will do some sort of check for matching existing customer.

While trying to create a new customer with the name matching an existing customer, I get:

image

Cust TST001 is the existing customer, and TST321 is the new customer Iā€™m trying to create.

But it looks like it needs all several matches on the fields shown in the above dialog

Assume I have the existing Customer

CustID   Name          Country    City      State  ZIP
======   ============  =========  ========  =====  ==========
TST001   John Smith    USA        Richboro  PA     18954-1520

Saving a new Customer with the following, generates the prompt

CustID   Name          Country    City      State  ZIP
======   ============  =========  ========  =====  ==========
TST321   John H Smith  USA        Richboro  PA     18954-1520

But the following (notice the different zip), doesnā€™t

CustID   Name          Country    City      State  ZIP
======   ============  =========  ========  =====  ==========
TST321   John H Smith  USA        Richboro  PA     18954

Maybe some way to expand upon, or leverage that functionality to prevent new Customer from being created.

1 Like
8

Mobile CRM doesnā€™t do any checking :roll_eyes:

Thatā€™s where the majority of our dupes comes from. We are moving away from Epicor Mobile CRM so hopefully itā€™s less of an issue going forward.

9

Thanks everyone for the help. Hopefully Epicor will see this as an issue in the future and add a merge customer recordā€¦ Seems like it should be pretty simple and all of their competitors have itā€¦

1 Like
10

For just CRM, yes itā€™s pretty simple. But when you add in things like Global A/R with credit limits, G/L control changes, and Sales Rep Commissions that may change, it can get complicated very quickly.

11

You are probably correct. It is just that when we were sold Epicor we were told that it was a much more complete product than the one we were using, and they had a simple customer mergeā€¦

Thanks,

Stuart Powell

President/CEO
Cookshack, Inc.

12

Yep. CRM is very basic. It does OK once a customer is a customer but the types of things that people do with CRM, funnels with Leads, integration with email, etc., are not its strength. Downstream, it certainly has better features. And one great thing about Epicor compared to many other ERP companies, they do actively develop the product and do a great job of moving all those products forward. Theyā€™re not like other companies (infor < cough >) who buys solutions and milks them for their support revenue. Epicor moves slowler so as not to leave many behind while others would do a complete rewrite and have us buy new and re-implement. Itā€™s a tough balancing act and Epicor does it very well IMHO - especially for the price-point.

2 Likes
13

Iā€™ve put in probably a dozen bug tickets now and theyā€™ve yet to fix a single one of them in CRM. They just released a new version of CRM and with it another major bug. You canā€™t see newly created contacts on customer/lead records. Like seriously, how does that pass QA. Not being able to see contactsā€¦ I submitted a ticket right away. They closed the ticket as a known issue. The suggested workaround is to use the E10 client. :roll_eyes: For our remote reps working on the road thatā€™s not a workaround.

2 Likes
14

Iā€™m not expecting Epicor to be a Salesforce CRM. But there are very basic features missing and some glaring bugs that have had no action taken for many months now. Our remote sales reps literally cannot do their job with Epicor CRM. For that reason we are moving to a new CRM.