Reduce Duplication on Accounts

[juanwang]

Hi All,

Duplication of records (in particular Accounts) has always been a problem with CRM systems. In the SugarCRM Account import, I have set it up to import the Account Name as the ID. This basically prevents importing of duplicate account records if the ID already exists.

Anyway, I wanted to apply the same logic to the manual adding of Accounts and was hoping if someone can point me to where the INSERT SQL logic lived so that I can change the auto ID generating to instead use the Account name.

Cheers,

Juan

[sadek]

Not sure if I am understanding this correctly. You would like the Sugar ID (guid) to be the name of the account?

-Sadek

[juanwang]

yes.
when a user createes a new account, instead of generating an ID, it uses the account name for the ID.

I actually thought about this a little bit more and it's not fools proof because if someone type in an account name with a slightly different spelling than it won't prevent the duplicate from being entered. But I think it will help reduce duplicate entries.

NetSuite uses this method ie. Account Name as ID

Cheers,

Juan