by KimberSullivan » Wed Feb 03, 2010 3:44 pm
We user workflow alerts in several areas to help with our data integrity.
For example, anyone can enter contacts and clients but if someone other than an Account Exec does so, the Account Exec assigned to that client/contact is alerted. If none is assigned yet, the Sales Manager is alerted.
Accounting gets alerts on new clients only when their first project is approved, so that they can get billing addresses/contacts established correctly.
We also have minimum data requirements for our records and fields with dependencies that we've added. For example, we require all contacts to be associated to a client.
There are some fields, such as Account Exec, that trigger a notice to the Sales Manager if they are changed.
If someone leaves one company and moves to another, we inactivate the original Contact and create a new one under the new Company. When we do a lookup on that person's name, we'll see the other contact. This way we don't lose the history under the old Company.
When someone leaves a company, we inactivate the record so we can see it but not change it.