Monday, January 28, 2008

Typical MS CRM customization

Before I start implementing and customizing MS CRM system, I need to assess the requirements whether need just tweaking MS CRM standard functions or need additional custom functions which require C# with Visual Studio 2003 for CallOut and Workflow assembly or Visual Studio 2005 for creating new add-on application.


When talk about MS CRM customization, I have 2 perspective methods:-

1. Tweak: For example, if you want to hide tab, column which is not necessary in contact, lead, if you want to change label of each text box, if you want to change menu etc. Basically, this type of customization you can use what MS CRM standard provides and modify it.

2. Add new functions: For example if you want to convert from email to quotation / incident / opportunity. This kind of functions doesn't come with standard in Version 3.0 so you need to add and plug it into MS CRM for serve your needs.

Hope this can give you some basic ideas of how to customize MS CRM system.

Sunday, January 27, 2008

Why a lot of company fail in CRM system?

From my experiences of implementation CRM System, a lot of companies can't achieve fully benefit of CRM functions capability. Sales and Customer Services people who are real end-users of CRM System don't feel that CRM system can help and support their daily work operations at all. Additionally, they feel using CRM system is wasting their time to make sales.

Why they feel like this??

I have some explanation from my experience:-

1. A lot of companies underestimate the implementation process of CRM package. Some companies might have .NET developers as internal resource and they assume that those resources will be able to implement Microsoft CRM system as well. The result is "YES" they can implement because Microsoft CRM has foundation from .NET technology. But for effectively implementing MS CRM, your implementer required to understand and know how to use MS CRM SDK object and tool, JScript, JavaScript, AJAX, DMF (Data Migration Framework) etc as well otherwise your CRM system will be like you have a powerful engine car but you can drive just at speed at 50 mph which is not worth your money.

This problem lead to your company will miss important MS CRM functions that you suppose to gain that advantage from CRM software.

- One client of mine, they have exactly problems what I just mentioned. They spent over 6 months to use .NET developer to implement MS CRM. But the result is nothing can generate for benefit of money investing, so they come to me. After I evaluate what messy of old CRM system have done, I come up with a plan and fix those problems. It takes a lot of effort to clear and clean old messy but eventually this client can use efficiently MS CRM system that really help sales and customer service in their work operation and also help managers to manage their sales and customer service staffs for improving sales at the right time.


2. End-users Resist adoption of the new CRM system

This classic problem always happens in organization which roll out new IT system. The best strategy I think it work out is come up and select a pilot group of users first to test new system. This type of users should have characteristic type is

- Understand sales and customer service work operation
- Feel excited about technology and enthusiasm about CRM functions

Then, you provide users' training for this group of users first which might have 4-5 users.
Each week, have a feedback meeting to check what progress / problems they have. By scheduling weekly meeting, it also can ensure that your team test and try new system. When pilot users have problems, you go to explain and help them very closely at their desks.

Pilot project should test about 1 month at least, after that you can come up the plan of roll out for entire group of users. From this strategy, when other users have problems, then they will try to help each other in the team first which help them feel more comfortable to adopt new system.

These are main reasons why a lot of company fail in implementation CRM system.

Tuesday, January 22, 2008

Auto converting MS CRM data into PDF files

Last week, I have a prospect who is interested to implement MS CRM project for his company. The issue that he is very concerned is how to integrate customer data into MS CRM and also allow sales people (end-users) can also convert that data into varied pdf files reports.

As we know MS CRM report has feature to export reports into pdf format. But this is not enough to support this requirement because it can't convert automatically into pdf format. So the way we approach for this issue is:-

1. create a new web application for users to key in customer data
2. once user save that data, then it need to call callout custom to update data in MS CRM system also.
3. create a filter form for allowing users to select what report they want to convert into pdf.
4. This filter form will allow for choosing multi form at the same time.
5. When users click convert, then back-end will go to take those data and do processing convert into pdf format. And save them into local or server computer.
6. If sales user want to send those pdf file to client by email for fax, they can use feature "attachment" which comes with MS CRM. So every file is sent out, it will be tracked.