Microsoft Dynamics CRM 3.0 Lotus Notes Domino Connector ? Overview For Consultant

We have reworked the original material, dedicated to Microsoft CRM 1.2 and first version of the Connector, now we are very close to make it work with Lotus Calendar events and support Microsoft Dynamics CRM 3.0.

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 we?ll 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 doesn?t 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 doesn?t 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.

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.enterlogix.com.br http://www.greatplains.com.mx ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, Texas.

CRM Budget: How To Bring Your CRM Project In On-Budget

It seems that having a project come in On-Budget is the and 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 include: 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.

About the Author

Scott Gingrich is the creator of The Insider's CRM Success Toolkit, the world's most complete and only guaranteed approach to successful CRM projects.www.thecrmcoach.com.

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 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 Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports overview for programmer

Microsoft CRM is new player on the CRM software market. The whole conception behind CRM seems to be different. In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind. Microsoft CRM is dedicated to Microsoft technology and so deploys all the Microsoft tools: Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc.
If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM we are giving you directions in this article.
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 customizing, modifying and developing! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM we are giving you directions in this article.
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 customizing, modifying and developing! 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, Los Angeles, San Diego, San Francisco, Denver, Houston, Dallas, New York, Boston, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally ( www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

Microsoft Business Solutions Great Plains, Navision, Solomon, CRM & RMS: serving international clien

Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Microsoft CRM, Microsoft RMS are now serving not only to small and mid-size, but also large clients, plus they maybe reasonably priced solution for the branch of multi-national corporation.

Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Microsoft CRM, Microsoft RMS are now serving not only to small and mid-size, but also large clients, plus they maybe reasonably priced solution for the branch of multi-national corporation.

Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Microsoft CRM, Microsoft RMS are now serving not only to small and mid-size, but also large clients, plus they maybe reasonably priced solution for the branch of multi-national corporation.  This raises question of supporting Microsoft Business Solutions product installation remotely and internationally.  We do not question local Microsoft partners service quality, the question maybe different local partners may not be authorized to sell and service specific MBS product, the example in France MBS promotes Navision, but there are multiple cases when branch of the US-based company in France needs users training and support for Microsoft Great Plains system.

In this small article we are trying to give you the best system selection idea, depending on your country and business type.

Microsoft has two major mid-market ERP packages: Microsoft Great Plains and Navision (Solomon is the one to consider for Project oriented company this would deserve dedicated publication).

• Microsoft Great Plains this application serves the markets, formerly targeted and gained by Great Plains Software (Great Plains Dynamics/eEnterprise or Great Plains Accounting), later on GPS was purchased by Microsoft.  These markets are: USA, Canada, Spanish Speaking South and Central America (except Brazil), South Africa, Middle East, Australia, New Zealand and Oceania.  If you are in these regions you should probably consider Microsoft Great Plains
• Navision we believe that Microsoft bought Navision Software Denmark based software development company few years ago in order to get European market share.  However Navision Software itself had long history of penetration to US market.  This is why we see Navision clients in both Europe and US. Now Microsoft seems to appreciate Navision accommodation to former European tax and language specifics and it promotes Navision on emerging markets: Russia, East Europe, Africa, Asia.  In Brazil situation is more complex Microsoft have not decided yet and you can have either Navision or Great Plains (our subdivision Enterlogix.com.br is exclusive Great Plains reseller in Brazil).  It is very delicate question for MBS - but what you can see - Great Plains version 8.0 has fewer number of languages support and at the same time Navision has more with new releases.
• Microsoft CRM Microsoft promotes its CRM worldwide and it is web based so it naturally automates your worldwide operations or serves you in your local country.  Microsoft CRM has C# and VB.Net based SDK, BizTalk server based integration to Great Plains and Microsoft SQL Server database.  Plus it deploys all the spectrum of Microsoft technologies: MS Exchange, Message Queuing, Active Directory.
• Solomon - this ERP application was formerly bought by Great Plains Software (before GPS was bought it its turn by Microsoft) - Solomon is very good fit for project-driven organization. 
• Microsoft RMS you should probably stay with Navision Retail module if you are in the region where MBS promotes Navision.  In all other places consider Microsoft Retail Management System: RMS Store Operations and POS.  If you have multiple stores you may manage and control them via Microsoft RMS Headquarters.  RMS has several integration options to Microsoft Great Plains.
• Remote Support Technology it gives you cheaper consulting rates, because consultant doesnt have to travel to you and can serve several remote clients per day.  Microsoft VPN and Remote desktop solution is usually free for the client and in the case of sophisticated firewall Web Session could be another way to serve.  We do voice training, based on Internet telephony solutions, such as Skype enable you free voice over the internet.
• Customization it is always better to avoid it however if you really need it, you should consider MBS customization partner who specializes in custom development and has experienced programmer.  In such a case we do not recommend to stick to local programmers in our experience local markets may not provide enough clientele for local developers to specialize in your product customization.  Also we do not recommend choosing generic offshore software developer.  MBS products require dedication in their customizations and integrations.

You can always have us help you internationally, give us a call: 1-630-961-5918 or 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, serving clients in Chicago, Arizona, Colorado, California, Texas, New York, Georgia, Florida, Minnesota( http://www.albaspectrum.com )

Microsoft CRM in Latin America: implementation, customization, support overview for consultant

Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe.  We expect substantial number growth of Microsoft CRM implementations across South and Central AmericaMicrosoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe.  We expect substantial number growth of Microsoft CRM implementations across South and Central America

 

Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe.  We expect substantial number growth of Microsoft CRM implementations across South and Central America and the need for Microsoft CRM implementation, support, tuning, reporting, training services, especially in such countries as Mexico, Columbia, Venezuela, Argentina, Peru, Uruguay, Chili, Costa Rica.  In this small article we try to project US market lessons on Latin American business climate.

• Sales.  Microsoft CRM in opposite to former CRM leaders, such as Siebel, Onyx, Saleslogix doesnt need hard pushing sales efforts.  It also should probably not be sold to the company top management, but rather to IT department enthusiasts, who are in charge for specific legacy business system support and data fixing.  Microsoft CRM is very simple from business logic and intuitively understood by IT group.  It is rather very simplified version of full-featured CRM, such as again Siebel.
• Installation.  Microsoft CRM should be either hosted or installed by in-house IT group.  And this is due to the fact, that MS CRM utilizes all the resent Microsoft technologies: MS Exchange Server 2003/2000, Active Directory, MS SQL Server, Crystal Reports Enterprise, MS Outlook client, Microsoft IIS, .Net components, etc.  This makes installation sensitive to existing setup of the above components
• Implementation.  The crucial in the implementation is Workflow design, which should be probably done by consultant with IT in-house specialist.  This process doesnt require a lot of business consulting knowledge and in our experience company middle management actually makes suggestions in the time of initial presentation.  In the case of MS CRM Sales module the workflow should organize leads processing up to the point of closing the deal and following invoicing.  When workflow is realized sales team works as excellent orchestra.
• Customization.  Usually MS CRM ties together existing legacy business systems and replaces large portion of them.  Typical case if you are freight forwarding client and have cargo tracking system you should more likely have lookup from the MS CRM account screen to the customer current shipments statuses.  This is usually made as small web application, created in Visual Studio.Net with MS CRM SDK and SQL queries to legacy database.
• Support.  Because MS CRM is web application it can be used by remote users and automate operations across the whole South America and even Worldwide.  The same should be said about MS CRM support your Microsoft Business Solutions CRM Partner can support your installation remotely from say office in San Pablo as if it is located across the street.

Good luck implementing, customizing and reports designing and if you have issues or concerns we are here to help!  If you want us to do the job - give us a call in San Pablo: 55-11-3826-3449, 55-113825-2586! help@albaspectrum.com

Author is MS CRM Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies ( http://www.albaspectrum.com ) Navision, Great Plains, Microsoft CRM customization company, serving client in Mexico-city, Buenos Aires, Montevideo, Bogota, Caracas, Panama, San Jose, Lima, Quito, Madrid, Barcelona

Microsoft CRM and Great Plains implementation: freight forwarding business automation example

In this small article well show you business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes

In this small article well show you business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision, Solomon and its own CRM solution Microsoft CRM.  Targeting to automate all business operations, Microsoft CRM is now integrated with Microsoft Great Plains and in the close future it should have integration with Microsoft Navision.  In this small article well show you business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes.

• CRM.  Central Customer and Vendor records place.  Assuming you have agents across the USA and internationally CRM, being web-interface application and so, could be used across the globe with good internet connection.  The nice features of this product are central emailing you send email from MS CRM and receive responses from your clients back in CRM, where they are permanently stored and documented.  You can issue Quote and Sales Order directly in CRM if needed or could have them issues in Microsoft Great Plains with propagation to Microsoft CRM (deploying MS CRM-Great Plains integration tool BizTalk based connector).
  
• Accounting/ERP.  Microsoft Great Plains could play this role, being integrated with Microsoft CRM and with industry-specific business system.  In the case of Freight Forwarding/Transportation this business system could calculate fees and charged, associated with MBL/HBL and posted against agent accounts.  You could deploy SQL triggers for instant integration or stored procs for scheduled batches.
  
• Great Plains Customizations.  Freight Forwarding specifics require Shipment tracking with SOP and POP invoices posted and tracked against the shipment and probably regular/monthly Agent Settlement report, where you match customer and vendor invoices, associated with the agent shipments and create AR or AP document, depending on positive or negative balance.  This is Great Plains Dexterity customization or web-development (if you need your agents lookup features from remote locations)
  
• Microsoft CRM Customization.  Assuming that you have Shipment Tracking system, which might be SQL or Oracle based you need shipment lookups for your order takers and customer support personnel from Microsoft CRM screens.  Being designed for easy web customization Microsoft CRM allows you to incorporate .Net web application into its screens, such as Account, Contact, Lead, Opportunity, etc.  You use Web Forms and Microsoft CRM SDK to penetrate into MS CRM security realm and then ADO.Net to call third party MS SQL Server or Oracle data
  
• Implementation Advices.  Microsoft CRM should be probably tried as in-house pilot implementation with 5 users license and then you can purchase additional license as you have your users trained.  If you need MS CRM SDK C# or VB.Net programming you could subcontract.  Great Plains requires consultant help to be implemented and integrated, because it has sophisticated tables structure and documents flow mechanism.
  
• Data Conversion.  We recommend you to deploy Great Plains Integration manager to import Vendor and Customers plus open documents.  Historical transactions, if needed should be moved by outside consultant.  Microsoft CRM has import tool try it first and subcontract more complex attachments, for example.

Good luck with implementation and customization 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

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 )

Some Of The Benefits Of A Microsoft Customer Relationship Management System

Customer Relationship Management (CRM) systems provide a formalized system gathering, organizing, maintaining and manipulating customer and contact information. With an effective Microsoft Dynamics CRM in place, business owners are provided with a powerful tool to successfully manage and develop their business.

Why a business should adopt and implement a Microsoft Dynamics CRM can be readily appreciated by considering some of the benefits provided. An effective Dynamics CRM, properly implemented and adopted will greatly help to maximize sales and reduce costs and time while management who have a better view of what is actually going on a lot faster than without a Dynamics CRM, are far better placed to manage the risk to their business.

Managing the sales cycle is expensive and time-consuming, so knowing where you are with a contact or set of customers is important if you intend to maximize the results of your business generation activities. A Microsoft Dynamics CRM will provide accessible information at your fingertips which means that a business owner can look at the ?Big Picture? or macroscopic view while at the same time break business performance down to see what activities and customers are contributing to the bottom line. This allows business owners and managers to see where to concentrate their efforts to maximize sales and minimize costs.

Generating new business is the most expensive part of the sales cycle, and because a Microsoft Dynamics CRM system provides the ability to categorize contacts and identify which are suitable prospects for a particular sales and marketing campaign, a business can most effectively deploy resources. Knowing which prospects are likely to buy, when they are likely to do so and where the prospects are geographically will help your sales team to maximize their efforts, reduce wasted time and money, and provide a greater return on the investment of time and money in acquiring that customer base.

Existing customers are most likely to buy from you again, and because a Microsoft Dynamics CRM system will provide a business manager with the ability to manage, maintain and develop the client relationship this means that a business is likely to generate greater revenues from understanding a customers requirements better and produce overall cost savings as a result of improved customer retention rather than chasing new ones.

As a Microsoft Dynamics CRM software solution provides a repository for all your client information, including sales history, seasonal variations in sales, and improved ability to forecast turnover from repeat sales, business planning and goal setting is simplified and there is an additional benefit in saving staff and management time searching for information which is readily available. Reducing the time required planning your business activity and development allows more time to be spent on generating business and managing activity where the sales revenue is actually created - with your customers.

A Microsoft Dynamics CRM will provide a business owner with the ability to see at a glance what is happening with their sales and customers. We live and operate in a fast changing world where trends and tastes change, sometimes overnight, and the ability to see how these variations affect our overall business performance allows management to quickly adapt to changes in trading conditions which under more traditional reporting methods may not be observed for some time. With a Microsoft Dynamics CRM providing accurate and up-to-date business information on results and activity, business management is better placed to take advantage of trading opportunities while also minimizing business risk by alerting management of adverse trading conditions.

Finally, an often overlooked benefit of all Customer Relationship Software is found when looking at implementing such a solution to begin with.

Implementation of a Microsoft Dynamics CRM solution invariably forces business owners and management to reconsider their business and how they are managing it, not to mention the benefit that is derived from a thorough review of the overall business goals and objectives. Often this has not been done for some time, if at all, and considering how a solution will be tailored to fit the business frequently breeds the realization that things could be managed better.

This doesn?t derive from the customer relationship software itself, but from planning how to implement and adopt such a solution; owners and management are compelled to confront their current business practices and perhaps revise them. This is probably the greatest insidious benefit to be derived from a Customer Relationship Management solution for a business.

Syed Ali, is the lead CRM consultant for a Toronto based company. His company offers, Microsoft CRM 3.0 Syed can be reached at Tel : (905) 815- 1995 ext 22, email: asyed@cqsolutions.com

Real Estate Customer Relationship Management - Ways for Agents to Increase Their Business

In 2005, The National Association of Realtors reported that its membership increased by 13 percent over the previous year, reaching 1.2 million. With this many people trying to get a share of the pie, Realtors need to find ways to differentiate themselves and stay ahead of the competition. Customer Relationship Management (CRM) can help them do exactly that, and even more.

CRM comes from the observation that developing good relationships with your customers helps you deliver superior service to your clients, thereby helping your business thrive. Developing a CRM-focused business is not especially hard. It starts with basic guiding rules.

In the marketing lingo, the many ways a business interacts with its clients are called points of contact. By developing the quantity and the quality of these points of contact, a real estate agent will gain more customers.

Of all the existing points of contact, the Internet should receive special attention. In just 10 years, the Web has become an essential marketing venue for today's agents. According to the NAR, 77 percent of home buyers used the Internet to search for a home in 2005. When people think about buying a home the first place they go is often the Web. It is therefore a good place for agents to capture consumers' attention and gain their confidence.

However, many agents are still missing the point: they now have their own Web sites because they know people are looking for them, but they haven't quite figured out how to use the Web as a good lead generator. Here are ways agents can improve their online points of contact.

The layout of your site is key to retain surfers. It should be flawless, and the navigation should also be easy.

E-mails are another critical point of contact. Many agents provide their e-mail address on their Web sites, but an article in Realty Times reported that one of home buyers' main complaints about Realtors online is that they don't answer their e-mails in a timely manner. Decide now about a reasonable e-mail reply policy for your business. A 24- or 48-hour reply policy is probably what most people expect. You need to state this reply policy on your Web site and stick to it. People will appreciate it.

Another option is to allow people to schedule a tour directly from your Web site. This option is a great way to get people to meet with you.

Most people start looking for homes on the Internet a few months before they actually make a decision. It is therefore important for a real estate agent to keep in touch with future home buyers. A good way to maintain that contact is to send out a monthly newsletter, which would give the latest information about the town or area. It would also provide future home buyers with the latest listings that meet their criteria. An agent who sends out this kind of newsletters will find that many of these people remember this agent when they are ready to buy.

The key with CRM is to regularly evaluate existing points of contact to fine tune them in order to better serve customers. This in turn will ensure that agents have a successful business.

Content provided by 10x Media. Established in 2003, 10x Media provides innovative online marketing tools.It has expanded its online presence through networks such as Inside Real state, Inside Finances and Grab Real Estate, which contain thousands of pages for city and state specific real estate information across the nation.

How to Build Customer Relationships

Building a lasting relationship with your customers is a vital marketing strategy in ensuring the existence of your business. Making your customers unhappy even once can impact their likelihood of ever revisiting.

Small, local stores, retailers, and companies, can sometimes offer more personable service because of their focus on the quality and uniqueness of their products not sold anywhere else. Honoring the customers' needs is what brings them back for more. The customers who approach you will not necessarily be a part of the local crowd--therefore it is important that you take the time to make a good impression to improve business. Running a small or local venture can be mixed with challenges all in its own, but with effective marketing you can overcome all the odds. What better place to promote that concept than on your web site?

Before you have your web site up and running, first develop a marketing plan as to what you would like to achieve through it. As an extension of your philosophies and style, you will want a web site that reaches out to your customers and lets them learn about you at the same time. Once you have that together, then you can plot out the components of your site. Here are some tried-and-true ways to offer optimum results:

* List sales dates, and offer deals, discounts, or coupons/vouchers for customers to print off and use. * Use your web site to offer email or postal mail updates to all customers who choose to be on your mailing list to which they can subscribe online. * Offer free or discounted shipping on orders processed via your specifications. * Offer to include a small free gift as a thank you to customers for their business. * Suggested features to include on your web site for customers to view are a pictorial catalogue, biographies of key contacts, employees, or owners/managers, and map and pictures of your business. * Include a Frequently-Asked-Questions (FAQ) section for self-help in case customers are experiencing trouble browsing or shopping online. * Clearly explain your products or services, including all applicable fees so customers are not unpleasantly surprised when they obtain a quote or make a purchase with your business. * State your policy of returns, damaged goods, or refunds where applicable. * Vary your selections by season, holiday, or event. Marketing yourself as a novelty producer in your industry will help you come out on top. * Make sure your web site is well-maintained at all times, where technical difficulties experienced on your web site are kept to a minimum to avoid losing impatient customers. A small, local business that is not prepared to handle an influx of customers will lose to a larger competitor. * Provide a feedback section for customers to offer suggestions and rate their overall satisfaction. You can also opt to email a survey to customers who shop online with you.

With careful planning, your small business can be well on its way to surpassing local recognition and make its way to the top of the list for successful ventures!

Jennifer McGroary is a WAHM who has been operating her own home-based web design and consulting business since 1999. Jennifer helps local small businesses, family-owned, & home-based businesses maximize their profits without spending money on advertising. To learn more, visit http://www.cssites.com

How To Build Customer Relationships Online

Marketing is not just about getting an order, it's about getting a customer and keeping them. Nurture your customer relationships with regular e-mails.
Marketing is not just about getting an order, it's about getting a customer and keeping them. Nurture your customer relationships with regular e-mails.

With regular e-mails you can build relationships and gather market intelligence. Send regular e-mails to your online prospect list containing special offers, useful information, resources and links, product or service updates, new offers or free reports and surveys.

You can also establish yourself as an expert, as a resource for invaluable information. At the same time, you can find out what offers your audience responds to best, and what they want to gain or achieve.

Build Your Own Prospect List On your Web site, build an opt-in e-mail prospect list by capturing your visitors' e-mail addresses and asking them to "opt-in" to receive more information. They are giving you permission to send information; keep them updated; announce special offers and so on. They want your information, so they are good prospects. You can sufficiently build your list by offering a free e-zine, articles or reports. (For those who don't have good writing skills, some companies (such as http://www.webcritique.co.uk) write an article or report for you with your byline and ad at the bottom.

Opt-in e-mail allows you to qualify your online prospects, and ensure they are interested in the topic your site covers, your products and your services. Only those interested will opt-in or register. And, once they've permitted you to send them regular e-mails, you can use e-mail as a tool for getting your message across, gaining credibility, and building your relationships with them.

For example, your opt-in box text might say: "Enter your name and e-mail address below and we'll keep you posted about the latest ideas on Internet marketing." The Web site visitor simply enters his or her details and clicks a button. They've then opted-in to receive further information from you.

Another way to build your prospect list is to establish your credibility and get involved in relevant online discussions. You can position yourself as an expert in your field by visiting forums and discussion boards and answering questions on hot topics. By advising and offering help you can build trust, confidence and loyalty, and attract people to your site, therefore building your prospect list.

Gather Market Research Information Send out online questionnaires to your e-mail list to find out how they learn and what they read. Find out what magazines and e-zines they subscribe to, what their favorite Web sites are and which sites they have bookmarked. You can then use this information to amend your promotional campaign accordingly.

You can also ask prospects and customers what they like or dislike about your product, service, Web site or offer. Get feedback. Find out what they want or need to gain, learn or achieve. If you know exactly who your market is, where they go and what they want or buy the most, you can position and structure your e-mails, marketing messages and Web site offers, to appeal to those wants.

Limit online surveys to 10 questions. Yes/no and multiple choice answers are the easiest to analyze, but you might also want to leave space for people to elaborate with comments. Always make the survey quick and easy to complete. You might even reward those who complete your survey by offering a free booklet or report. You might also use a guestbook on your site, which invites visitors to make comments. Reward those who enter their details with a gift certificate or discounted product.

Once you've researched your target audience, and know as much as you can about your online customers, you can prepare a profile. This will help you aim your online marketing at an accurately defined group of people, and appeal directly to their primary wants and needs. Remember, the secret to success online and offline, is to find out what people want and give it to them.

Getting your website right

www.applythis.com/browsersizer Check how your web pages appear on various screen resolutions.

http://www.webcritique.co.uk Have your website professionally appraised by an expert. You get a 40+ page in-depth report with recommendations to improve navigation, usability, copy, content, appearance and search engine readiness, with revamped copy, site layout suggestions, analysis of your site's key strengths and weaknesses and content idea generator and accessibility guidelines. A quick and easy way to improve your website without spending a fortune, and attract/retain more visitors.

http://www.webdesignclinic.com This site offers information on colour theory and how to get your website design right.

http://www.webtrends.com This site offers one of the most popular analysis products available. Provides info on site visitor numbers, how they find you, where they go and where they exit. This allows you to get a better idea of your target audience and tweak your site and content accordingly.

http://www.siteconfidence.co.uk Site Confidence offers a free trial of the website monitoring package. This reports any site downtime, and is a great way to monitor when your site goes down - it may happen more often than you are aware of.

Cheryl Rickman is author of 111 winning ways to promote your website successfully and runs http://www.webcritique.co.uk where she offers in-depth website appraisals and personalized web marketing plans, plus web copywriting services, a free e-bulletin on web promotion and links to useful resources.

Cheryl Rickman is author of '111 winning ways to promote your website successfully' and contributes regularly to Better Business magazine, Digitrends.com and Internet.com. She offers website appraisals, copywriting and marketing via http://www.webcritique.co.uk