The first and easiest solution would be to leverage Microsoft Excel for customer data entry. Excel can make it simple to adjust the data captured to reflect the specific needs of your individual customer, keeping in mind that the information captured may not be the same across all customers. You can attach the spreadsheet to your customer account, a sales opportunity, or a support case. While this is by far the simplest solution, it may not be the most effective because of the risk of multiple attachments of the information and the inability to report on or search for the information.
Dynamics CRM's customization framework – specifically the ability to create custom entities – is a more sophisticated solution, but will likely offer a great deal more flexibility than an Excel solution. Using the entity builder, you can create a completely custom component for CRM that could be linked to an account and to multiple cases or opportunities. CRM even provides tools for designing an intuitive user interface for laying out the questions in logical groupings by tabs and/or sections. What is even better, new entities created through the Dynamics CRM tools will work with the Web and online/offline Outlook clients.
The nature of the questions would determine the best way to configure the new relationship. When we have created this type of configuration for a client, we have typically created a new entity that stores all of the questions, and then configure the relationships so that the entity can be linked to the appropriate Dynamics CRM account, case, etc. This makes it possible to access the data from both the account and the case record, for example, and to search for data using advanced find. Using SQL Reporting Services, you can also develop reports on the data.
One of the best benefits of using the custom-entity approach for customer data entry is the ability to create exactly what you need, in terms of the fields (questions and answers). If the information that you need to capture dramatically changes over time, it is possible to either extend the entity with additional fields or to create another entity that reflects the new information that is critical to your business. In working with clients to select and implement CRM solutions, we have found Dynamics CRM's customization support to be some of the best in the industry for enabling customers to model their business in their CRM solution.
CRM Solutions manage sales and marketing campaigns easily with integrated customer relationship management.
CRM Solution Resource offering essential research by professionals to help you choose the right solution.