Web based CRM guide 101

One of the primary factors in the success of any company is the liaison it shares with its customers. CRM or Customer Relationship Management designates all features of interaction a company shares with its customer. This includes everything from sales to service.

CRM is basically a business strategy designed to accrue gains, generate revenue and cater to customer needs and satisfaction. With the e-media picking up pace, the manner in which companies approach their CRM strategies has greatly changed. This has even altered the consumer's purchasing attitude. So these days CRM too has become a web based effort as most of the customer relationship is handled electronically.

The web based CRM service is more effective. Web-based CRM services mainly covers three areas of service- sales force automation, management of customer relationships and customer services and automated marketing.

A web-based CRM software is a web-based system used for contact management, marketing and sales support, project tracking and other tasks associated with CRM. This software enables teams and departments to share a central and fresh database. The software facilitates its users with an online contact manager and a project-tracking tool, either over the web or within the corporate intranet. With the aid of the CRM software you can view and manage contacts, customer's record, hot leads, projects and left-out work, from anywhere and with any web-browser. Moreover unlike the intervening and needed to be testified upgrades of an enterprise software, the upgrades to the web based software do not affect the organization's regular operations in any manner. Due to these features more and more companies are driven towards this web-based software.

Siebel Systems Inc., HydraNet and Push CRM are some eminent names in web-based software service. Lately SAP has also blessed the market with on-demand Customer Relationship Management solution. A web based CRM has many names out of which on-demand CRM is one.

These systems provide agents with the most up-to-date information on all customer service transactions. The software adds to the strategic value and business of the organization by automating sales, marketing and customer service. For instance the SAP product specializes in providing core sales-force automation features for managing customers, contacts and sales pipelines.

The software runs and keeps a complete track of your data after it is downloaded or purchased and then installed on your server or web-host. Usually the CRM software runs on all significant platforms such as Unix, Linux, Windows, Mac OS X, Novell (6.5) and so forth. Since the software serves many purposes at the same time, it is quite expensive. However an incredible competition in the market has enabled the software seekers to exercise their choice to a certain extent.

In choosing a web-based CRM software it is important that the user should firstly analyze his or her budget or the budget of the organization. Secondly also check your organization's partner ecosystems. A user-friendly hosted CRM system, an on premise version or the combo of both should follow this and finally try to go for software that can fit any type of user, any size company and in any industry.

Mansi gupta recommends that you visit Web based CRM for more information

Mobile CRM - It's Here Now

Today?s workforce is truly mobile. Most of us now work at the office, from home and on the road. ?On demand access? to critical customer information from anywhere is becoming a ?must have? facility.

Now customers demand CRM access using a remote desktop or laptop accessing data through the Internet or on a handheld device. Suppliers are expected to have all the information at their fingertips at the moment of interaction. The same insight into their business and affairs are expected in a one-to-one meeting is expected when they phone into a call centre.

Remote access is a genuinely useful tool that can help your company to reduce duplicate entry, administration time, travelling time and costs for remote workers. It will also enable you to improve your customer service, and improve the quality and usefulness of data input.

Staff want the technology. Surveys have shown that sales management and field representatives both felt strongly that providing PDA access to CRM systems would drive increase productivity of the sales force. Eighty-three percent of sales representatives felt that a PDA sales solution would make them more productive in the field and 90% said they would use their CRM system more if they had handheld mobile access. Sales management agreed: 82% believe PDA access for sales representatives would drive field usage of CRM and 91% believe mobile CRM software on PDAs will become an important sales tool for their organization.

Two factors have stopped many companies from adopting mobile technology to improve their business functions. Firstly, companies are just inexperienced when it comes to applying mobile technologies. Secondly, even though it is not true, companies percieve the cost associated with mobile solutions to be greater than the benefits gained because they can't immediately identify how to apply mobile data to improve competitive capability. A mobile data delivery solution must be cost effective and allow organisations to experiment with mobile technologies and to gain insight on how to gain a competitive edge from the technology.

It should have the following:

* Access to information from any remote location covered by a mobile network.

* Low start-up costs allowing development of mobile strategies through experiments.

* Simplified user interface making it easy to administer data.

* Quick search and find.

Success can be measured by:

* Improved cycle times in providing a customer with accurate information.

* Efficiency increases for buyers and sales people free them to focus on developing key account relationships

* Empowered sales people and buyers with information when they enter negotiations through remote access to data

* Allowing management to be up to date with information where ever they are engaging with suppliers, customers, partners or shareholders.

* Experiments with mobile strategies to define ways of improving current business processes and prepare for new wireless technologies that will reshape the business environment.

Thanks to broadband and 3G technology this is no longer just the preserve of large companies. Now SMEs can also use the web and PDAs to access their CRM systems remotely giving benefits such as:

* Accessing important account contact and history information
* Updating account information
* Cultivating stronger sales relationships
* Improving customer service
* Scheduling activities and appointments

Richard Hill is a Director of E-CRM Solutions, that specialises in CRM, direct and internet marketing [http://www.e-crm.co.uk] for SMEs. He is non-executive Chairman of Innovantage [http://www.innovantage.co.uk] a business intelligence company and a non-executive director of Innovecom [http://www.innovecom.com] a computer networking company.

The Importance Of CRM

Competition in CRM, driven by globalization and the internet has turned things around.

Customers have a variety of choices and most importantly, they have become more knowledgeable and demanding.

It is no myth that they are King.

With this scenario, enterprises have realized that it is not just enough to satisfy and delight them but also build genuine relationships in a way that would benefit them.

Customer Relationship Management CRM initiatives are designed with the goal of meeting Customer expectations and needs in order to achieve maximum Customer lifetime value and return to the enterprise.

The use of Customer Relationship Management products, CRM software and CRM solutions will enhance the effective implementation of CRM in an organization.

There are CRM success stories, but success in a Customer Relationship Management CRM implementation may best be measured by the restraint an organization shows in its goals and expectations.

By understanding the roles and benefits of IT as a CRM enabler, you"ll learn best practices for deploying information technology in a controlled manner within a cohesive, enterprise-wide architecture.

By providing the means to manage and coordinate Customer interactions, Customer Relationship Management CRM technology helps enterprises maximize the value of every Customer interaction and in turn drive improved corporate performance.

Putting all Customer Relationship Management CRM facets into one coherent, organized presentation to the Customer could require the services of a systems integrator.

It would most certainly require training everyone from webmasters to call center workers to field sales technicians.

The need to better understand Customer behavior and focus on those Customers who can deliver long-term profits has changed how marketers view the world.

S. Maurer is a 53-years old college graduated IT professional, with 30 years of experience in the computer & technology business. Now is the Correspondence Courses Director of http://international-businesses.net. Other languages in http://tips-on-project-management-pm.business-technology.us

CRM On Budget: How To Develop and Stick To a Realistic Budget for CRM

It seems that having a project come in On-Budget is the holy-grail of project management, especially when it comes to CRM projects. With their 70% failure rate, CRM projects represent a significant risk to a small business' financial health and warrants more "measure twice, cut once" consideration before beginning.

Coming in On-Budget does not mean you managed to squeeze your project into whatever arbitrary budget you came up with when you first started. It also doesn't mean that you started with an overly generous budget.

It does mean that you develop a budget that takes into account an analysis of 4 critical areas:

1. PAYOFF. You need to know exactly how your CRM system is going to generate ROI. This will help you focus your project on the right areas. By knowing how you expect payoff to be achieved, you can plan to achieve it.

2 RISK. You need to figure out where the risk is in your project because "risk=expense". By figuring out what can go wrong, you can take measures to minimize and contain that risk.

3. SERVICES. Be sure to fully account for the variety of services that will be required. A few often overlooked areas that can increase your services bill significantly incoude: meetings, testing time, debugging time and "while you're here..." time.

4. TECHNOLOGY. Choosing the wrong technology is can be a huge waste of money. From the worst case scenario of a totally failed project to having to spend extra money to make the wrong software do things it wasn't intended to do.

What makes putting together a realistic budget so difficult for small businesses is that it's not what they do and they don't have the experience of having done several before. It's not what they do. So, they rely on the Sellers of CRM who have their own vested interest in not scaring off their customers with numbers that are perceived to be too expensive.

By putting together a realistic budget, you may very well find that the project is going to cost much more than you were intitally prepared to spend. It's best to find this out now and before you "sign on any dotted lines".

If you do find out the project is going to cost more, here are a few ideas of what to do:

- WAIT & SAVE. Perhaps you need to wait 6 months until you have a bigger budget. Use this time to get prepared for the project: learn more about the software choices, make sure you're business processes are as fine tuned as they can be, and focus on how CRM software will generate ROI.

- GO AHEAD. It may be more money than you were expecting, but may still be within your budget. If you're clear on how the CRM system is going to generate ROI and you're otherwise ready, go for it!

- SCALE DOWN. If you have a very clear idea of how the CRM software is going to achieve ROI and you can't afford the full project, focus in a smaller area to begin with that will have a payback. Use this payback to help fund future projects. It's always a good idea to start with smaller, high-payoff projects first.

- FIND MORE ROI. If you have a really clear and compelling business case for how a CRM system is going to improve your bottom-line, it's much easier to find the necessary funds to implement it.

- DOUBLE CHECK. Make sure you're choosing the right technology. Cheap software can often be expensive to implement. Double check to make sure you're basing your budget on the right CRM software. You may find that a software that costs more in licensing, ends up being an overall more affordable solution.

Coming in On-Budget means you started with a realistic budget. The Insider's CRM Success System goes into great detail on how to develop a realistic budget and provides the control forms and worksheets you'll need.

Scott Gingrich, founder of The CRM Coach (www.thecrmcoach.com) is the creator of "The Insider's CRM Success System", the world's most complete and only CRM Success System guaranteed to save thousands, developed specially for small business.

Microsoft Dynamics CRM Customization Or Third Party Product ? Overview For Consultant

With version 3.0 MS CRM will be more exposed to end-user tuning, software development, customizations. Microsoft CRM SDK is becoming more sophisticated with post-call-out technology reconsidering, deprecating a lot of 1.2 CRM SDK methods, replacing Crystal Reports Enterprise with MS SQL Server Reporting Services, changing MS CRM Exchange Connector functionality, etc. Microsoft itself has to be very flexible and freed up to change/adjust development standards if required. In such situation end customer should be very knowledgeable and savvy to predict the future, when he needs to deploy custom solutions/modules. In this small article we will consider pros and contras of deploying third parties or just go ahead with customer specific unique customization.

Third Party Product.

? Pros: The cost is normally controllable, because product is already developed and ready to be implemented. Plus it is possible to get references on the reliability of the product from all the kinds of user groups, product reviews, etc. Also ? sometimes it is referred as weakness but it might be considered as the plus ? if product is developed and supported by the known vendor ? you should believe that it will be upgraded and available for future MS CRM releases.

? Contras. The first minus we would like to mention is usually not described in the textbooks ? this is the problem when, say product A is purchased by Microsoft itself and inaugurated as from now on ?official? solutions, and if you historically selected product B ? coming from the competitor ? you are in a problem ? you will see you software vendor to be weakened and slowly phasing out alternative product B

Unique Customization.

? Pros. You will have so-called source code, if you negotiate it right with the custom developer or custom development company ? then you can transfer version upgrade or product modification to the market leader (who will be giving you better price and quality assurance in the future). Other pluses might be cost saving, due to the fact that you are paying for required functionality only, not for something you will never use.

? Contras. Cost might be crossing the budgeted line, because you might not be able to select reliable software developer (all of them might be in the learning curve, because MS CRM is relatively young product) ? this is very strong argument, when you have just purchased the CRM and yet not know the players on the customization market.

Production Environment Challenges. When you are already in production ? be sure that MS CRM needs testing, if you introduce custom logic. You should try to isolate custom logic, and test it in the isolated space ? again MS CRM doesn?t have parallel test company environment ? opposite to what you have in ERP system, such as Great Plains/Dynamics GP.

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx ) - Microsoft Business Solutions Great Plains, Navision, Axapta, MS CRM, Oracle Financials and IBM Lotus Domino Partner

Microsoft CRM Implementation: Employee Time & Billing ? notes for Consultant

Microsoft Dynamics CRM 1.2 and now 3.0 could be considered as extremely flexible platform, suitable for small, mid-size and corporate businesses, it is easily customizable via C# or VB.Net in MS VisualStudio, however you can deploy MS CRM as is for sophisticated task, such employee timecards, consultant billable hours tracking, contract management, etc.  Assuming that you as business owner have IT department or even Microsoft savvy consultant ? you are ready to launch employee timelog process right away, without annoying customization and custom reporting.

• Procedure.  MS CRM is flexible in the sense that you can create and attach activity to virtually any object ? Account, Contact, Lead, Quote, Order, Invoice, etc.  If you have your consultants do just that ? it will help (all the documents and info will be in CRM), however it would be no structure and you would be spending your time digging CRM in the search of historical information.  Remember Lotus Notes Domino?  Where you could also keep attaching and expanding lists and tree-like structure?  You need the procedure and the procedure will help you structurize the data in MS CRM
• Structure.  The structure, deployed for employee time management should be like this.  Customer (Account) should have Contracts.  Each Contract should have contract lines (where you can allocate the budget per line), then each line should have Cases (when you fulfill the contract ? you assign your consultants to the cases, such as install software, fix bugs, replace old server with the new one, etc.).  And finally, consultants should log cases, such as appointments (if the date and time is known) and tasks (if the date and time is now known, however you know the deadline)
• Scenario.  Customer ABC has ERP Implementation contract.  This contract has two lines: Software Installation (24 hours budget) and User Training (40 hours budget).  You activate contract, open two cases for Installation: SQL Installation and Client installation.  You assign SQL case to John and Client case to Bill.  You book John for Monday onsite visit (appointment, from 8am till 4pm) to install SQL, for bill you create task ? install clients for Nancy and Marilyn (you ask Bill to stop by next week, but you leave him to schedule and decide on the date).  When John finishes installation, he opens MS CRM, appointment (either web or outlook client), goes to the appointment->action->close appointment (action Close Appointment->Completed) and 8 hours are logged toward SQL Installation case.  When finally you close the case ? you decide on the number of billable hours (you will be shown the actual and budgeted time).
• Reporting.  You will probably need two reports: consultant/employee time, were you should be able to see budgeted, actual, written off time ? here you evaluate consultant performance.  The second report is Project status.

Feel free to call us in US & Canada: 1-866-528-0577, 1-630-961-5918, Latin America: S?o Paulo 55-11-3444-4949, Europe: Deutschland (0177) 8349 806, help@albaspectrum.com

Andrew Karasev is Chief Technology Office, Alba Spectrum Group ( http://www.albaspectrum.com ) serves corporate clients in the following industries: Oil & Gas, Healthcare, Manufacturing, Tools & Machinery, Pharmaceutical, Mining, Services, Non-Profit, Advertising & Publishing, Distribution & Logistics, Transportation, Consignment, Food & Beverages, Restaurants Supply Chain, Textile, Building & Construction, Real Estate, Engineering & Project Management.

Microsoft Dynamics GP/NAV/CRM implementation in South East Asia ? highlights

In this small article we will give you highlights on Microsoft Dynamics family of products implementation, customization, user training in South East Asia: Thailand, Indonesia, Philippines as well as in China and Taiwan.

Microsoft renamed its ERPs: Great Plains, Navision, Axapta, Solomon and MS CRM and now new names start with Microsoft Dynamics: Microsoft Dynamics GP, Microsoft Dynamics NAV, Microsoft Dynamics AX, Microsoft Dynamics SL, Microsoft Dynamics CRM.  In this small article we will give you highlights on Microsoft Dynamics family of products implementation, customization, user training in South East Asia: Thailand, Indonesia, Philippines as well as in China and Taiwan.

• English Language.  Considering such country as Philippines, where English is commonly used in business documentation, Microsoft Dynamics GP, or former Microsoft Great Plains/eEnterprise is a good choice.  At the same time Microsoft Dynamics NAV or former Microsoft Navision is also excellent option.  The situation is similar to what we have on the US ERP market, when Navision vs. Great Plains selection is based on the functionality comparison between GP and NAV.
• Chinese Language.  Microsoft Dynamics GP doesn?t support Unicode characters in its native interface ? Microsoft Dexterity (former Great Plains Software Dexterity).  If you are looking at the Microsoft Dynamics GP Business Portal ? you are free to customize it and have it support Chinese.  There is special utility, which allows you to intercept Chinese characters and enter them in Great Plains fat client/Dexterity forms.  The functionality is very popular among Chinese food distributors in the USA ? Chicago and Houston areas
• Taxes.  Both Great Plains and Navision support both tax systems: Sale Tax based and VAT (Value Added Tax)
• Manufacturing.  This is where you should compare two systems: Great Plains and Navision manufacturing module/granule.  Great Plains Manufacturing is good choice for Discrete Manufacturing type, if you have process manufacturing ? you should verify functionality and third party add-ons features.
• Localization.  If the conditions of your local country require localization (tax and language specifics ? very good example would be India), you should check with Microsoft Business Solutions in your country on the positioning of Microsoft ERPs.  In general, when localization requires non-English/Spanish/French Canadian language ? Navision is the recommended and usually localized.  Axapta also is very adaptable and localizable and you will see Axapta as the option in the majority of cases.
• Non-Microsoft ERPs.  In some cases and we know real life stories/examples international company, having Microsoft Great Plains implemented in the headquarters in the USA, decided to implement SAP Business One for its overseas manufacturing facility.
• Software Licenses Sale only.  In South East Asia we see very strong IT departments and IT consulting market.  When company is required to implement Microsoft Dynamics ? it can do it in-house and all you need is software licenses sale.
• Local ERP Solutions.  On the local markets, especially where government regulation takes place you can find local or regional ERP vendors.  There are pluses and minuses of such systems: plus would be government reporting side.  Minuses are from the control side ? international company should have ERP reasonably controllable and the option to rely on local specialists only is risky.

You can always have us help you with the implementation & customization.  Call us in US: 1-866-528-0577, internationally: 1-630-961-5918, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials, SAP Business One  and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing.
We serve international clients Worldwide.

Microsoft CRM or Siebel

Microsoft CRM or Siebel

Siebel is traditional CRM market leader, however and mostly due to recession 200-2003, Siebel lost sizable portion of CRM market to new tiger, such as Microsoft CRM. Microsoft CRM s recent (2001) CRM answer from Microsoft and attempt top get market share from traditional vendors: Siebel, Oracle, Onyx. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision (the last two in progress).

We would like to give you Microsoft CRM selection advise, based on our MS CRM consulting practice, going back to its inception in 1999. This article is written in FAQ style for beginner level

1. What is your industry how strange it may look close to 40% of our clients or so-called orphan clients who needs help with Microsoft CRM customization are freight forwarding, transportation companies, who needs either improvement in Exchange-CRM connector or MS CRM integration with their freight forwarding system, where they would like to see on the fly resent shipment info. And also to mention freight forwarding companies are usually large (more than 50 CRM users)

2. How comfortable you are with Microsoft technology in-house support The old-days idea of Apple computer was to make computer absolutely intuitive and working for housewife. Now we know that this is not realized so far. If you compare MS CRM with Siebel you will see that MS CRM requires y0u to have Microsoft Certified people in staff. Everyone knows that Microsoft is so innovative that each product requires daily service packs and patches

3. Do you have Great Plains, Solomon or Navision CRM is usually integrated with ERP system and if you are looking at MS CRM you should benefit if you have ERP from Microsoft Business Solutions (Great Plains, Solomon, Navision, Axapta or Small Business Manager - SBM)

4. Operating System Philosophy - Microsoft likes clients who have no UNIX/LINUX/IBM/Apple etc inclination and staked on Microsoft Windows 2003/2000/XP/Longhorn, preferably staying on Intel platform (No AMD Athlon 64)

Have fun in selection and decision. We are here to help you: 1-866-528-0577

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, with offices in Chicago, Phoenix, Los Angeles. San Francisco, San Diego, New York, Atlanta, Denver, Miami, Toronto, Montreal, Madrid, Moscow (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.akarasev@albaspectrum.com

Microsoft CRM Implementation & Remote Support overview for V.P. IT

Microsoft CRM Implementation & Remote Support overview for V.P. IT

 by: Andrew Karasev

Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision. Being relatively inexpensive in comparison to competitors, like Siebel, Oracle - Microsoft CRM opens you the door for worldwide operations automation.

We would like to give you pluses and minuses of Microsoft CRM.

1. Web and MS Outlook based client - this means that you don't need additional installations or training - everyone is using Outlook if you are on Windows XP/2000/2003

2. SQL Server database - just to mention

3. Integration with Microsoft Exchange 2003/2000 - this means that replies to CRM originated emails will be captured and store in CRM as activities for the Contact, Account or Lead.

4. Remote Support - I would say - this would be in the nature of MS CRM - you host it's database in your headquarter and users will connect to it worldwide via Internet Explorer

5. Integration with other MBS products - currently it has integration interface with Microsoft Great Plains

6. Microsoft technologies dependence - yes, this is true and maybe considered as minus, it doesn't work with Netscape or Mozilla browser.

7. New Product - it is relatively new on the market and may not have industry specific features yet

Also if you are considering some customization scenarios, we would suggest you to review the options below:

1. Microsoft CRM SDK this is software development kit with C# and partly VB.net code samples it is supported by Microsoft Business Solutions technical support. It is based on web service calls, if you are C# .NET developer you are excellently positioned to do this type of customizations. This is the preferred modification scenario and this should be easily upgradeable customization. VB.Net examples will be available soon.

2. Legacy SQL Data integration. This is also easy and safe. If you have SQL database, sitting on the same or linked SQL Server you can create ASPX .Net application and simply integrate it into CRM. You can place it on the navigation bar or menu in isv.config please refer to MS CRM SDK

3. Legacy ASP integration this is somewhat more sophisticated. You have to deploy HTTP handler to be a middle party between CRM which is .Net based and ASP which is legacy IIS. The trick is you have to have INI file with security settings to penetrate into MS CRM with proper credentials, calling web service.

4. Microsoft Exchange Programming. Microsoft CRM has Exchange connector which moves CRM incoming email to MS if it has GUID in its subject. You can alter this logic (for instance - move email to CRM if it doesnt have GUID but it is from the sender who is contact or account in MS CRM). Refer to MS Exchange SDK onsyncsave event handling. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience.

5. Direct SQL touch in #4 above I described you the scenario with MS Exchange handlers this would be ideal world if MS CRM SDK does the job. But in real world this is not always true you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc). This is not supported by MBS technical support but you can rescue to this technique if you have to get job done.

6. MS CRM Customization tool this is rather end-user tool and we dont describe it here read the manual. Weve described above the options to use when this tool doesnt do the job

7. Crystal Reports - feel free to create Crystal report - tables and views structure is self explanatory. Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it.

Happy selection, implementation and modification! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Dallas, Atlanta, and Miami and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.akarasev@albaspectrum.com

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System. Being VP IT or IT Director you need to foresee the positions to have in your IT department to do internal MS Great Plains and MS CRM support.

Let us give you the directions, based on our research and consulting practice.

1. Microsoft SQL Server Specialist we specially do not name this position as MS SQL DBA, because both Great Plains and MS CRM are not very complex from the database administration side, they do not use indexes optimization, referential integrity, probably do not require complex transaction log backup/recovery scenarios. On the other hand this position requires Great Plains and Microsoft CRM tables structure analysis and some primary Great Plains data fixing skills via SQL queries, described in MBS Customer source techknowledge database. The best candidate should have some accounting background - to be able to address ongoing issues to MBS technical support.

2. Network Administrator with good Microsoft Exchange and Active Directory skills. Microsoft CRM uses all the newest Microsoft technologies, and Exchange is a workhorse here. In order to install and upgrade MS CRM this guy needs to understand the under-laying Microsoft technology. In the best case - she/he should know Exchange security structure and probably program Exchange handlers, due to the fact that CRM/Exchange connector is not a perfect tool yet.

3. C# or VB.Net programmer with excellent SQL Skills if you are midsize or large company - you should have this position - you will need web publishing and MS CRM customization and its support. Currently Microsoft CRM SDK has C# examples - so C# programmer would be the best fit, it may have more VB code in the future, so the C# - VB balance maybe restored.

4. Crystal Reports Designer/Programmer - Crystal Reports is the best tool available on the market to address both Great Plains and MS CRM reporting needs. This position maybe merged with one of the above.

These people should be probably cross-trained in both Great Plains, Microsoft CRM, Crystal Reports, SQL and C# programming, so you do not depend on the unique skills of one person. In our opinion, which is based on our long term consulting practice - these skills will allow you to keep the cost of IT support reasonably low and avoid paying high consulting price to your Microsoft Business Solutions Partner.

Happy hiring and training! But in any case you need to select Microsoft Business Solutions Partner/Var/Reseller to be your official representative. This is how MBS has its channel working - it assures that Microsoft Business Solutions products are properly implemented. If you want us to be your Microsoft Business Solutions Partner - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Arizona, California, Taxes, New York, Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

akarasev@albaspectrum.com

Microsoft CRM Integration with Microsoft Retail Management System (RMS) overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server based applications, however historically Microsoft was purchasing industry leading software applications, such as QuickSell which is now Microsoft RMS.  So, RMS design fundamentals were minted a long time before Microsoft CRM.  But, still integration between the two is straightforward and what you need is consultant, who is familiar with both systems structures and customization scenarios

Microsoft CRM is currently integrated with Microsoft Great Plains and will be integrated with Microsoft Navision in the close future, RMS integration is not planned to our knowledge, so you should seek third party solutions or create your own integration.  We see the need for such the integration when you sell on account in RMS and have customer support call center automated with Microsoft CRM.  Let us give you highlights:

• Microsoft CRM custom lookup.  More likely you will nee lookup to your RMS headquarters or store records for the customer transactions from Account screen.  Microsoft CRM allows you to have custom navigation bar on Account screen by clicking on this bar you could call your custom web .Net application, which will call Microsoft RMS database and return you the grid of customer transactions
  
• RMS architecture excurse.  Microsoft RMS has Headquarters and Store databases.  The exchange between the two types of databases uses worksheet mechanism.  Most of the transaction types are initiated on the store level and transferred to the Headquarters database (with some global data exception, global customers for example are handled on HQ level and then propagated down to the stores). 
  
• Data Inquiry and Update.  The MS RMS architecture suggests you to query primarily Headquarters database and do not change data in HQ database.  If you need to change data on the store level from Microsoft CRM custom screen you should consider placing web service on the SQL Server hardware in the store to deal with the store-initiated transaction
  
• Microsoft CRM programming.  Microsoft CRM has MS CRM SDK (Software Development Kit).  This is open source tool, you can download it from Microsoft site and it is description of Microsoft CRM classes and methods with sample codes in C# and VB.Net.  Microsoft technical support encourages you to use Microsoft CRM SDK objects and discourages you from direct SQL server programming.  If you need to query MS CRM database you should create your custom database and place your objects: SQL views and stored procedures there.  Do not place custom object into MS CRM databases

Do your homework in integration and if you have issues or concerns we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM customization company, serving clients  in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

The new Customer Relationship Management CRM functions

 C.MeloPublishing Guidelines: You may publish my article in your newsletter, on your website or in your print publication provided you include the resource box at the end. Notification would be appreciated but is not required.

The new Customer Relationship Management CRM functions

By J.C.Melo

The Customer Relationship Management CRM system was born because of the need for a software to analyze customer's data - as for example its preferences - changing rough data that usually exists in any customer's database, into important information about the same customer. That is to say, a new modern sales & marketing tool.

In this first period the data of an online and real-time accounting & management system was analyzed by this stand-alone CRM software, and in the following period those accounting & management systems integrated this initial marketing & sales functions of a CRM.

Soon after, this new accounting & management system - now integrated with the CRM functions - included a Call Center system of the last generation with or without a voice processing system - input and output - through the telephone system usually so loved by us.

Soon after appeared an obvious question: If the CRM support my customers, why don't change it to support all the external functions of my company, as for example my suppliers, distributors, representatives, branches, affiliated companies, employees's families, etc., each one with different needs and processings?

This is the current Customer Relationship Management CRM system, for everything concerning the external world of a company, and consequently its original name no longer represents its current functions in spite to be widely used.

Today we should split the IT system of a company in two great sides but in the near future will be only one system:

1. Enterprise Resources Planning ERP, for the internal world of a company, on which we will write another article in the near future,

2. Customer Relationship Management CRM, for the external world of a company.

However it's absolutely necessary to understand that a CRM is not a software package that can be installed and immediately will be ready to work, but yes a system that obligatorily should be implemented by IT specialists together with the whole company in a continuous job, besides to be adapted to the specific needs of the company. And because the CRM was not interpreted correctly by a large amount of companies, recent research showed that 42% of purchased CRM systems are inoperative for been interpreted as a push-button software.

However if very well designed and installed, a CRM is a powerful tool for a company to grow on this digital business Century, certainly surpassing your competition and generating reasonable ROI Return on Investment.


The new Customer Relationship Management CRM functions

By J.C.Melo

The Customer Relationship Management CRM system was born because of the need for a software to analyze customer's data - as for example its preferences - changing rough data that usually exists in any customer's database, into important information about the same customer. That is to say, a new modern sales & marketing tool.

In this first period the data of an online and real-time accounting & management system was analyzed by this stand-alone CRM software, and in the following period those accounting & management systems integrated this initial marketing & sales functions of a CRM.

Soon after, this new accounting & management system - now integrated with the CRM functions - included a Call Center system of the last generation with or without a voice processing system - input and output - through the telephone system usually so loved by us.

Soon after appeared an obvious question: If the CRM support my customers, why don't change it to support all the external functions of my company, as for example my suppliers, distributors, representatives, branches, affiliated companies, employees's families, etc., each one with different needs and processings?

This is the current Customer Relationship Management CRM system, for everything concerning the external world of a company, and consequently its original name no longer represents its current functions in spite to be widely used.

Today we should split the IT system of a company in two great sides but in the near future will be only one system:

1. Enterprise Resources Planning ERP, for the internal world of a company, on which we will write another article in the near future,

2. Customer Relationship Management CRM, for the external world of a company.

However it's absolutely necessary to understand that a CRM is not a software package that can be installed and immediately will be ready to work, but yes a system that obligatorily should be implemented by IT specialists together with the whole company in a continuous job, besides to be adapted to the specific needs of the company. And because the CRM was not interpreted correctly by a large amount of companies, recent research showed that 42% of purchased CRM systems are inoperative for been interpreted as a push-button software.

However if very well designed and installed, a CRM is a powerful tool for a company to grow on this digital business Century, certainly surpassing your competition and generating reasonable ROI Return on Investment.

J.C.Melo is a 73-years old IT professional with 54 years of experience in computer science & technology entrepreneurship. He was the owner of the first minicomputer factory in South America and Consultant for the U.S. Government in several contracts. Now is the CEO of the organization
http://mba-open-university.net.

 

Microsoft CRM Conversation Gateway: VOIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the traditional CRM providers as Siebel, Saleslogix. In this article well show Microsoft Business Solutions CRM potential in the VoIP direction.

Microsoft CRM is winning market share step-by-step from such the traditional CRM providers as Siebel, Saleslogix. In this article well show Microsoft Business Solutions CRM potential in the VoIP direction.

Nowadays VOIP-based technologies and Instant Messaging Systems are getting wider and wider spread. Each work desk or each personal computer has one or another instrument of information exchange, belonging to the VOIP or instant messaging systems. Currently the mostly presented information exchange systems are:

Skype (http://www.skype.com). Revolution system of sound compression the tolerance to the bandwidth of the channel enabled VoIP amusement features to the general internet world-wide user with microphone and headset, Windows/Linux/Mac OS X operating systems, internet access and free registration with Skype. Plus Skype application has instant messenger between skype users. New features and services SkypeOut and SkypeIn allow you not only to call to the regular phones from your computers with very low rates, but also accept the calls on your skype phone number in the SkypeIn system.

MSN Messenger (http://messenger.msn.com). Quite successful attempt of the Microsoft open the door to the instant messengers market. MSN Messenger gained market with the speed of light, due to the tight integration with Microsoft Windows. Every new version adds new functionalities MSN Spaces integration, audio and video transfer etc.

Yahoo! Messenger (http://messenger.yahoo.com). IM system of the Yahoo! portal, has standard set of features for communication, including audio and video stream transfer.

AOL Instant Messenger (http://www.aim.com). This is one of the veterans of the IM system market. Considering the popularity of AOL as internet provider AOL instant messenger holds substantial market share.

ICQ (http://www.icq.com). Yes we do not have to give you additional comments, we are targeting this article to IT professionals who were working in the Clinton era of American internet miracle and booming. Let us just add that with the release of version 5 ICQ introduced new features of the audio and video conversation.

VoIP & IM systems are popular not only in the home office environment, but are gaining popularity in the corporate market. One of the proves is the release of Microsoft Live Communication Server, which allows messages streams coordination and control. Natural idea should we enable VoIP and IM conversation with automatic protocol? It is always good to have paper copy of the MSN conference, related to the project, product, in the form of MS CRM Activity. Or, from CRM interface to call your potential customer via Skype. Or accept the incoming call via SkypeIn and record the call to the CRM database to be accurate with the following negotiations. The usage is really unlimited and is currently restricted only by human conservative nature.

Now, lets consider the schema of MS CRM extensions to enable such a system:

The main component is Albaspectrum Media Core for MS CRM the module, providing media streams saving in the special database, interaction with the specializing connectors to IM/VoIP systems. Its function is also Activity creation in the Microsoft CRM system.

The second important component is modification to these forms: Contact, Account etc. Modification is adding phones, addresses, Skype, MSN, AOL, Yahoo identifiers. Also we have to add SkypeOut phone calls service. In the future we plan PBX/PSTN support via MS Office Communicator 2005

Planned addition - Answering Machine module, controlling incoming calls and messages from clients and saves them in Media Database. If manager is out of his desk, system will save the message and will create Activity in personal queue you will not miss no one customer call! Plus all the calls from non-registered clients/prospects might be associated with one or another Account, Contact, Lead, etc.

Lets consider the process of the phone call/receiving or message recording:

CRM User opens client form and reads telephone or skype ID to place the call. If she/he would like to talk to skype user Skype application must be installed of the local machine and she/he needs to be skype online user. If she/he calls to another Skype user, then we dont have additional requirements. In the case when call is placed on PSTN number, CRM user needs to have SkypeOut active account. In both cases when user picks up the phone or is absent CRM activity will be created with the relevant status. If the call was accepted, automatic call recording will be switched on, activity will be created with the indication on the phone duration. For MSN, Yahoo!, ICQ audio conversations all the mentioned above is relevant, except PSTN support (currently skype only).

The above described process is similar for instant messenger conversations, recorded by MSN Messenger, ICQ, Yahoo! Messenger, AOL Instant Messenger.

CRM User could appeal to Full-Text Search upon the saving to Media Database of text talks directly from the MS CRM interface.

For the users, who are accessing CRM over the internet we envision IM system support (as http://webmessenger.msn.com) in the MS CRM forms.

Good luck with integration! If you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com Andrew is Software Developer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, Denver, UK, Australia, Canada, Europe ( http://www.albaspectrum.com )

Microsoft CRM Integration with IBM Lotus Notes Domino machinery dealership example

IBM Lotus Notes with Domino email server is traditional document workflow management solution for large corporate business, where you need audit trail on approval cycle and decision making. Microsoft Business Solutions CRM is very cost efficient solution to automate sales process. It might be surprising, but we see good strata of clients who are willing to deploy and integrate both systems: MS CRM and Lotus Domino. In our opinion these clients are balancing ERP platform risks and trying to protect and deploy investments into Lotus licenses, while deploying new and already leading CRM solution Microsoft CRM. In this small article well give you the integration example European division of one of the well known machinery manufacturer dealership network.

Custom Lotus Database. In our case client had custom database, which was designed back in the beginning of 1990th. Some dealers had Lotus Notes Domino 4.0 and some of them had 6.0 and 6.5. Technical excurse in Lotus Notes Domino 6.0 you can use Java 2 agents, and it seems to be platform independent (Microsoft Windows Server, IBM AS/400). To synch all the dealerships the decision was made to upgrade across the network to Lotus Notes Domino 6.0 (to be a bit conservative)

Domino Messaging. Obviously you have to have just one email server assigned to your url domain, and as traditionally Lotus Domino was the email server the replacement with Microsoft Exchange 2003 (which is natural choice if you purchase Microsoft CRM) was not an option. With Alba Spectrum Technologies MS CMR Lotus Notes Domino connector you can switch email messaging to Lotus Domino

Lotus & MS CRM events synchronization. IBM and Microsoft software designers designed CRM & Lotus events differently. Second phase of the project implementation will synchronize appointments, calendar events, etc. between Lotus and MS CRM.

MS CRM ODBC lookups to Lotus database. As the second phase we plan to implement lookups from MS CRM Account to cases with custom fields and Lotus notes lookup tab. This tab will be realized as web .net application, integrated into MS CRM web interface. This web application will have machine serial number, warranty & service info. As you probably know in MS CRM 3.0 you can deploy custom table in link it to MS CRM object as one-to-many. The most important is that it will be synchronized by MS Outlook and will allow you as a salesperson to work offline.

You can always have us help you with MS CRM customization, implementation, support & MS CRM SDK data conversion. Give us a call: 866.528.0577 or 1.630.961.598, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.

help@albaspectrum.comMicrosoft CRM Lotus Notes Domino Connector FAQAndrew Karasev

Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being two groupware products from competing software development leaders, however could coexist within one organization computer network and even work together in collaboration. There maybe multiple reason why corporation would use both products: licensing, commitment to IBM Lotus Notes as legacy product, risk balancing staking on both Microsoft and Java/EJB/J2EE platforms, deploying Lotus advanced workflow to automate document management, etc. The need to synchronize MS CRM and Lotus Notes Domino databases is dictated by the ERP market and the connector is available. In this small article well answer on the frequently asked questions.

Messaging. Can MS CRM use Lotus Domino instead of Microsoft Exchange? Yes. MS CRM Lotus Domino connector allows you send messages from MS CRM objects: Lead, Account, Contact and all the future object, including Sales and Service modules

Outgoing Messaging. When Microsoft CRM send email from Account, Contact, Lead connector takes control over and sends email through Lotus Domino server. It has Java Agent at the Lotus side and MS CRM SDK custom piece at the MS CRM side. If you compare outgoing messaging with standard MS CRM Exchange connector, then mechanism is slightly different. Microsoft CRM Exchange connector places GUID in the message header and uses this GUID to identify the object in the responding email to push it back to CRM and attach. MS CRM Lotus connector doesnt use GUID instead it scans MS CRM objects (Accounts, Contacts, Leads) in smart cached way

Incoming Messages. When Lotus Domino server receives email Java Agent side of the connector triggers checking with MS CRM if addressor email matches with any Contact, Lead or Account email. In the case of the match email is transferred into MS CRM in the form of activity of email type. Again please note that connector doesnt use GUID mechanism. We found that matching is better approach and we have Microsoft CRM Exchange advanced connector which works with matching, without standard GUID mechanism.

Microsoft CRM & Lotus Notes Events synchronization. Future version of the connector will synchronize MS CRM and Lotus Notes objects: Calendar, Appointment, Fax, Phone Call, etc. Please, note that Lotus has different objects we have the matching table, please check with us.

Lotus & MS CRM Versions. Lotus should be version 6.0 or higher. The reason for this is simple version 6.0 supports Java Agent technology. MS CRM should be 1.2 or 3.0. Lotus could work in multiple hardware & OS platforms, such as Windows Server, AS/400, etc.

Product Pricing. It is US$3k basic pack, including 30 users and then $75 each additional user. In Europe price is proportional in Euro.

Support. Product is installed Worldwide and supported in Europe from German office, in the USA and Canada from Houston and Chicago, in South America, Africa, Australia, Asia, New Zealand from office in Sao Paulo Brazil.

Please give us a call if you have additional questions 866-528-0577 or 630-961-5918! help@albaspectrum.com

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia. Alba Spectrum serves corporate clients in Aerospace & Defense, Oil & Gas, Chemicals, Manufacturing, Transportation & Logistics, Pharmaceutical, Food Processing, Placement, Healthcare & Medicine, Beverages, Agriculture, Non-profit, Distribution & Supply Chain Management, Financial Services, Furniture, Textile, Apparels, Conglomerates, Wholesale & Retail.help@albaspectrum.com

Microsoft CRM Typical Customizations

 Microsoft CRM was designed to be easily customizable. Microsoft CRM Software Development Kit (MS CRM SDK) which you can download from Microsoft website contains descriptions of the objects or classes, exposed for customization. It has sample code in C# and partially in VB.Net. In Visual Studio.Net you can analyze all the classes, used by Microsoft developers to create MS CRM - you will discover that most of them are not documented in MS CRM SDK. Microsoft will not support your customization if you use undocumented class or do direct SQL access to CRM database.

Let us describe you - programmer, software developer typical cases of MS CRM Customizations.

1. Integration with SQL Server application. If you have legacy system on MS SQL Server - let's say you are transportation company and have in-house developed cargo tracking database. Now in MS CRM you want lookup the shipments for the customer (or account in CRM). This is SDK programming and calling SQL stored proc to retrieve cargo info. Instead of SQL Server you can have other database (ORACLE, MS Access, PervasiveSQL to name a few) - you can access multiple Database platforms via ADO.Net connection from your .Net application, which is easily integrated into MS CRM Account screen.

2. Email capturing in MS CRM. You have customer with email Bill@customer.com. Now you want all the emails that you receive from customer.com domain to be attached to Bill who is account in CRM. This is more difficult customization - you have to create MS CRM SDK web service, that one will be creating email activity and call it from COM+ application - Microsoft Exchange event handler (ONSYNCSAVE database event sink). This example maybe complicated with the following requirement. Imagine that Bill, instead of answering to your email (sent from CRM and processed by CRM-Exchange connector) sends you new message from MS Outlook. Then this email will not follow into MS CRM (because it doesn't have GUID in the header and so is ignored by CRM Exchange connector). If you want to capture these emails - you have to do it in Microsoft Exchange event sink. There maybe scenario when you want to capture and analyze in the sink all the outgoing emails - this is even more complex - y!

ou have to place the sink on transport event.

3. ASP Application integration. You have legacy ASP application, where you capture orders from your customers and you want these orders be transferred to the CRM as activity. Here you understand that ASP doesn't deploy Active Directory security - and the best way is to create HTTP handler and call it from your ASP page. This HTTP handler in turn will call MS CRM SDK web service with predefined (web.config) Active Directory credentials.

Some cautions. Never create your custom SQL objects (like stored procedure, SQL view, table) in MS CRM database. Instead, create your own database and place your objects there. When you see the first caution - you will never try to alter existing CRM objects, like adding new field to the table.

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, New York, Florida, Georgia, Minnesota, Oregon, Arizona, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Microsoft CRM SDK, Great Plains Dexterity, SQL, C#/VB.Net and Crystal Reports developer.

akarasev@albaspectrum.com