Method Community

In our system, we are assigning a unique FullName which is made up of characters from the LastName, the Address, FirstName, and ZipCode.  So, a new lead might be assinged the FullName of SENICK14740JIM2484J.  A duplicate lead (of which we acquire many) would have a FullName of SENICK14740JIM2484J(2).

I have a new screen with a new default grid filter to show only those leads ending in ')', that are IsLeadStatusOnly, and have any LeadStatus other than Qualified.

For the new delete duplicate leads button, I am looping through only those grid records that are selected.

For these leads there would only be one activity.  I have the actions to loop through and delete these.  But I am wondering from which table(s) do I delete the actual lead records?

I have checked the QB Audit Trail after manually deleting a lead and see "For table 'accCustomer' the record xxxxx was deleted" and "For table 'accEntity' the record xxxxx was deleted".  Both record numbers are the same and the Table Names listed are Entity and ENTITY respectively.  I expected to see the Customer and / or Contacts table instead.  Anyway, should I be deleting from Entity and Contacts?

- James

Hi James.

Naeem

Naeem,

Understood.  Thank you very much.  I was close...but just a little confused. All good now. 

No problem James -- have a great day! :)

Naeem,

One more question: I notice that the contacts (table) record remains (with partial data) after manual deletion.  Is there  MethodCRM specific reason I would not want to delete the contact record as well?  In this situation these are duplicate leads.

Thanks again,

James

Hi James,

There's no reason in your case to keep around any of the contact data, so you should go ahead and delete that too. :)

Cheers,

Naeem

Naeem,

Perfect.  Thank you!

- James