how to prevent duplicate Company records (vendors, manufacturers, customer etc.) in Servicenow

[Eric M]

Anyone have recommendations on how to prevent duplicate Company records (vendors, manufacturers, customer etc.) in Servicenow. We want all the different processes that should be using the same record

How to normalize the data etc. 

Thanks 

Eric 

[Ankur Bawiskar]

Hi Eric,

have a before insert business rule on core_company table which will check whether combination of fields already exist in company table

you need to identify which fields to be considered as unique; name should be unique or combination of name and other field should be unique

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Eric M]

How would you deal with all Microsoft vs Microsoft Inc

[Ankur Bawiskar]

Hi Eric,

that has to be decided by the customer/stakeholder or client/business what they consider as unique

As a ServiceNow developer/admin Microsoft and Microsoft Inc can be 2 different companies but for client/customer it can be one

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[lana5]

Have you had this resolved?  We have a similar requirement