Microsoft Dynamics AX-GP-NAV-CRM: Trends and International Recommendations

Microsoft Dynamics project ? or formerly referred as Project Green should unify and modulate all Microsoft Business Solutions ERP applications: Microsoft Great Plains/Microsoft Dynamics GP, Microsoft Navision (former Attain) Microsoft Dynamics NAV, Microsoft (Navision) Axapta/Microsoft Dynamics AX. The challenge of unification probably will result in quality change for the unified interface, such as Web/Business portal/Microsoft Outlook & MS Office integration, Deployment of new technologies, such as Microsoft Sharepoint with workflow automation. Plus the development platform for Microsoft Dynamics products should shift from proprietary tools, such as Microsoft Dexterity, C/SIDE, MorphX (no confirmation for Axapta yet ? but we guess it should follow) to C# and VB.Net with VisualStudio. In this small article we will try to orient IT managers in Microsoft Business Solutions MRP products selection for international and regional markets.

? Microsoft Dynamics GP. The regional markets for Great Plains 9.0 and following Microsoft Dynamics GP 10.0 version will narrow: United States, United Kingdom, Canada: both English and French speaking, Australia, New Zealand, South Africa and other English speaking countries in Asia, Africa and Worldwide, plus Spanish Speaking Latin America. Microsoft Dynamics GP 10 will not be available for Germany, France, Belgium, Netherlands, Poland ? the last version localized for these European countries will be 9.0 ? June 2006

? Microsoft Dynamics NAV. Currently Navision has very good presence in Europe, including East Europe: Poland, Russia, Ukraine, Czech Republic, Slovakia. Microsoft also localized Navision for new markets, where it just moved in: Brazil for example ? it was interesting development in Brazil ? first Microsoft probed Solomon, then Microsoft Great Plains 7.5 and in 2004 replaced it with localized Navision

? Microsoft Dynamics AX. Microsoft Axapta, opposite to Navision or Great Plains where market shares are gained/divided and competition is based on renovations and product improvements, Axapta has great potential yet to be deployed, coming from its modern and very futuristic system design and architecture. Being targeted to upper mid-market and corporate clients Axapta shows very good progress on emerging markets: in Russia for example the number of Axapta installation is similar and comparable with the number of Navision installations. Plus, in 2005 large number of Microsoft Business Solutions gold certified partners rushed into Axapta consulting arena ? this is seen in the USA, UK, Australia and continental Europe. In Brazil currently MBS in local Portuguese Axapta launching mode ? localized for Brazilian tax code

? Microsoft Dynamics CRM. Is planned as front CRM solution for the majority of Microsoft Dynamics ERP system: integration with Microsoft Dynamics GP is available for GP 7.5, 8.0, 9.0 and CRM 1.2 and 3.0, Microsoft Navision ? through third party integrations, Axapta integration is planned. Microsoft has Microsoft CRM as worldwide product, so you should not have any doubts regarding your regional market.

? Competition. Oracle is on the way with Oracle Fusion project, aiming on Oracle Financials/Applications/E-Business Suite, PeopleSoft, JDEdwards and potentially Siebel integration. SAP with the purchase of new mid and small market ERP: SAP Business One and Mendocino ? for SAP R/3 is catching up

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner. Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com

Microsoft Dynamics ERP: GP, AX, NAV, CRM ? which one to select

Being in MRP implementation, customization, integration, data migration/conversion business for many years, we would like to give you some orientation, in the case if you are on the way of ERP selection for your company. 

Being in MRP implementation, customization, integration, data migration/conversion business for many years, we would like to give you some orientation, in the case if you are on the way of ERP selection for your company.  In this small article we will be talking about Microsoft Business Solutions ERP brands only, you can check our future publication to get similar orientation on Oracle and SAP ERP products.

• ?Legacy? vs. ?Modern? ERP.  It might not be the focusing question, however we?d like you to look at the ERP products from this perspective: Java/EJB Sun Microsystems conception is less then 10 years old, and now Microsoft .Net/C# construction is in the process of getting market from Java.  Similar time test should be given to ERP system ? if the system has legacy architecture ? it might be candidate for replacement or be seriously re-written/renovated.
• International aspect.  If you think your company is and always be focusing on the US market and will do business with local folks only ? this paragraph might be skipped.  For the rest of us ? and we are in this cohort ? we should watch closes Microsoft Business Solutions international policies.  When Great Plains Software and Navision Software were independent software vendor and being forming their international policies completely independently from one another ? both had intentions to expand to all the world markets: USA, Europe, Australia, Asia, Africa, South and Central America.  Now, when Microsoft sells all former GPS and Navision ERP products ? it can choose one product over the other to promote on the regional market ? simply due to the fact that it has to invest into ERP localization.
• Microsoft Dynamics GP - Great Plains.  Great Plains Software pioneered in the earlier 1990^th with its graphical and DB platform independent product for Mac and Windows: Great Plains Dynamics.  The shell was written on C programming language and was named Great Plains Dexterity.  Currently with Microsoft Dynamics project initiative ? Microsoft renovated Dexterity ? it supports now COM object calls and so XML web services, but it is not pure .net application/shell ? Microsoft is investing in web interfaces for Microsoft Dynamics GP ? Microsoft Business Portal for GP is very good example.  Microsoft Dynamics GP incorporated all the best technologies from Microsoft Office to .Net, but its design was done more then 10 years ago.  Microsoft Dynamics GP 9.0 is available in English, Latim Americal Spanish and Canadian French, plus German, Dutch and French/France versions will be available for version 9.0 only ? they will not be supported for future version of Dynamics GP.
• Microsoft Dynamics NAV ? Microsoft Navision - Navision Attain.  Navision Software was established in 1994 and since then it gained European ERP mid-size and portion of USA market, especially for light manufacturing.  Navision success should be attributed to Denmark software development market miracle of earlier 1990^th.  Navision went even further into graphical and DB platform independence ? it designed its own database platform ? C/SIDE ? Navision separated SQL coding from the database itself.  Currently MBS promotes Navision on MS SQL Server platform and its database independence is losing its actuality.  Navision was localized by MBS to the majority of East European, South American and other emerging markets ? if you are in Europe, South America, Asia and looking for supported reliable solution on your regional market ? you should look at Navision first.
• Microsoft Dynamics AX ? Axapta.  Axapta was the newest ERP designed by Navision Software prior to its acquisition by Microsoft.  The architecture is dated at the end of 20^th century.  Axapta needed some time for Microsoft to get upper mid-market ground ? traditionally occupied by SAP, Oracle, PeopleSoft, JDEdwards.  Currently Microsoft is localizing Axapta to Brazilian market ? due in April 2006.  Very good chances are in East and Continental Europe, including UK.  In 2005 US Microsoft Business Solutions regional and nation-wide VARs invested into Axapta consulting practice ? training and certifying consultants, marketing campaign, etc.  Very good chances for Axapta for US mid-market and and upper mid-market clientele and prospects
• Microsoft Dynamics CRM.  Microsoft Dynamics CRM 3.0 or simply Microsoft CRM 3.0 is promoted by Microsoft Worldwide.  So, do not question it from the international perspective ? you will have integration with Microsoft Dynamics GP, Navision (through third party integration), Axapta ? in progress, plus with IBM Lotus Notes Domino ? via Alba Spectrum Lotus Notes integration.

Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br ) - 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.
We are serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM, MN

Microsoft Dynamics AX-GP-NAV-CRM: trends & international recommendations

Microsoft Dynamics project ? or formerly referred as Project Green should unify and modulate all Microsoft Business Solutions ERP applications: Microsoft Great Plains/Microsoft Dynamics GP, Microsoft Navision (former Attain) Microsoft Dynamics NAV, Microsoft (Navision) Axapta/Microsoft Dynamics AX. 

Microsoft Dynamics project ? or formerly referred as Project Green should unify and modulate all Microsoft Business Solutions ERP applications: Microsoft Great Plains/Microsoft Dynamics GP, Microsoft Navision (former Attain) Microsoft Dynamics NAV, Microsoft (Navision) Axapta/Microsoft Dynamics AX.  The challenge of unification probably will result in quality change for the unified interface, such as Web/Business portal/Microsoft Outlook & MS Office integration, Deployment of new technologies, such as Microsoft Sharepoint with workflow automation.  Plus the development platform for Microsoft Dynamics products should shift from proprietary tools, such as Microsoft Dexterity, C/SIDE, MorphX (no confirmation for Axapta yet ? but we guess it should follow) to C# and VB.Net with VisualStudio.  In this small article we will try to orient IT managers in Microsoft Business Solutions MRP products selection for international and regional markets.

• Microsoft Dynamics GP.  The regional markets for Great Plains 9.0 and following Microsoft Dynamics GP 10.0 version will narrow: United States, United Kingdom, Canada: both English and French speaking, Australia, New Zealand, South Africa and other English speaking countries in Asia, Africa and Worldwide, plus Spanish Speaking Latin America.  Microsoft Dynamics GP 10 will not be available for Germany, France, Belgium, Netherlands, Poland ? the last version localized for these European countries will be 9.0 ? June 2006
• Microsoft Dynamics NAV.  Currently Navision has very good presence in Europe, including East Europe: Poland, Russia, Ukraine, Czech Republic, Slovakia.  Microsoft also localized Navision for new markets, where it just moved in: Brazil for example ? it was interesting development in Brazil ? first Microsoft probed Solomon, then Microsoft Great Plains 7.5 and in 2004 replaced it with localized Navision
• Microsoft Dynamics AX.  Microsoft Axapta, opposite to Navision or Great Plains where market shares are gained/divided and competition is based on renovations and product improvements, Axapta has great potential yet to be deployed, coming from its modern and very futuristic system design and architecture.  Being targeted to upper mid-market and corporate clients Axapta shows very good progress on emerging markets: in Russia for example the number of Axapta installation is similar and comparable with the number of Navision installations.  Plus, in 2005 large number of Microsoft Business Solutions gold certified partners rushed into Axapta consulting arena ? this is seen in the USA, UK, Australia and continental Europe.  In Brazil currently MBS in local Portuguese Axapta launching mode ? localized for Brazilian tax code
• Microsoft Dynamics CRM.  Is planned as front CRM solution for the majority of Microsoft Dynamics ERP system: integration with Microsoft Dynamics GP is available for GP 7.5, 8.0, 9.0 and CRM 1.2 and 3.0, Microsoft Navision ? through third party integrations, Axapta integration is planned.  Microsoft has Microsoft CRM as worldwide product, so you should not have any doubts regarding your regional market.
• Competition. Oracle is on the way with Oracle Fusion project, aiming on Oracle Financials/Applications/E-Business Suite, PeopleSoft, JDEdwards and potentially Siebel integration.  SAP with the purchase of new mid and small market ERP: SAP Business One and Mendocino ? for SAP R/3 is catching up

Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br ) - 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.

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.

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.

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 Modification overview for IT specialist

Microsoft CRM Modification overview for IT specialist

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.

If you are programmer or database administrator who is asked: how do we modify Microsoft CRM read this article and you will have the clues for further research.

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 modifying! 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, Los Angeles, Houston, 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

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

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

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, Los Angeles, Houston, 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

Microsoft CRM Customization: MS Exchange Transport SMTP Event Sink

Microsoft CRM has variety of customizations options and tools. The official and the most popular is Microsoft CRM SDK: collection of C#.Net and partially VB.Net classes, methods and code samples. Here we would like to give you more complex case, when you call CRM SDK customization from custom MS Exchange event handler we are improving the functionality of MS Exchange MS CRM connector.

Imagine the case when you want outgoing email to be captured and placed into CRM, attached to Contact, Account or Lead they should belong to. If this is realized your salespeople can use any email tool to send their messages, they do not have to do it in CRM or Outlook Client for CRM.

MS Exchange OnSyncSave database event cant work with Sent folder it doesnt fire when message goes to Sent folder. The reason is described here:

PRB: Store Events Do Not Fire on the Outbox or Sent Item Folders

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q297274

Please, see SMTP Event Sink example in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;317327. Event handler works OnArrival event:

void ISMTPOnArrival.OnArrival(CDO.IMessage msg, ref CDO.CdoEventStatus EventStatus)

{

log = LogManager.GetLogger(typeof(ShieldsUp));

DOMConfigurator.Configure(new FileInfo(Environment.SystemDirectory + "/CustomerApp/log.config"));

try {

ProcessMessage(msg);

}

catch (Exception ex) {

log.Debug(ex.Message + " " + ex.StackTrace);

}

finally {

LogManager.Shutdown();

}

}

The class:

// ComVisible enables COM visibility of this class. The default is true.

// Explicitly setting this attribute to true, as shown below, is useful

// if ComVisible is set to false for the namespace and you want the

// classes to be accessible individually.

[ComVisible(true)]

public class ShieldsUp: CDO.ISMTPOnArrival

{

Next the handling works similar to SyncSave handler:

private void ProcessMessage(CDO.IMessage msg)

{

string sFrom;

string sTo;

string sSubject;

string sBody;

string sSensitivity;

try

{

log.Debug("Firing Up ProcessMessage()");

sSubject = msg.Subject;

sBody = msg.TextBody;

sFrom = msg.From;

sTo = msg.To;

if (msg.Fields["urn:schemas:mailheader:sensitivity"].Value != null)

sSensitivity = msg.Fields["urn:schemas:mailheader:sensitivity"].Value.ToString();

else

sSensitivity = "Normal";

log.Debug("Message From: " + sFrom);

log.Debug("Message To: " + sTo);

log.Debug("Subject: " + sSubject);

log.Debug("Sensitivity: " + sSensitivity);

log.Debug("Body: " + sBody);

In deployment you should consider the following the handler will work only in the case of SMTP protocol delivery. If you use Outlook or Outlook Web Access, then delivery uses MAPI and OnArrival doesnt fire. Please see this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;273233

The elegant fix is two SMTP gateways, find it here http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288756

Boris Makushkin is Lead Developer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Colorado, Arizona, New York, Texas, Florida, Georgia and having locations in multiple states and internationally (www.albaspectrum.com), he is Microsoft CRM SDK, Transact SQL, C#.Net, Crystal Reports and VB.Net developer. Boris can be reached: 1-866-528-0577, borism@albaspectrum.com.

Microsoft CRM Customization: Integration with third party SQL Application/Database

Microsoft CRM Client Relationship Management package from Microsoft Business Solutions was initially designed to be customizable with Microsoft Visual Studio.Net and one of its programming languages C#.Net or VB.Net. You can use ADO.Net, Web Service, Transact SQL scripting and stored procedures, deploy such SQL Server tools as Linked Server to all ODBC/OLEDB compliant database, including ORACLE, Sybase, Ingress, DB2, Unidata, Pervasive SQL, Ctree and even Lotus Notes/Domino. In this small article we would like to give you the clue on programming the integration with SQL third party Database.

First use Microsoft CRM SDK to initiate communication with Microsoft CRM, we have it in C#:

String[] arr1 = coll.AllKeys;

int loop1, loop2;

for (loop1 = 0; loop1 0?1:arr1.Length); loop1++)

{

String[] arr2 = coll.GetValues(arr1[loop1]);

for (loop2 = 0; loop2 < arr2.Length; loop2++)

{

strAccountId = arr2[loop2].Replace("}",null);

strAccountId = strAccountId.Replace("{",null);

}

}

if (Page.IsPostBack==false)

{

// Server should be set with the name of the platform Web server

string Server = ConfigurationSettings.AppSettings["ServerName"];

// VirtualDirectory should be set with the name of the Microsoft

// CRM Virtual Directory on the platform Web server

string VirtualDirectory = "mscrmservices";

string strDir = "http://" + Server + "/" + VirtualDirectory + "/";

// BizUser proxy object

Microsoft.CRM.Proxy.BizUser oBizUser = new Microsoft.CRM.Proxy.BizUser ();

oBizUser.Credentials = System.Net.CredentialCache.DefaultCredentials;

oBizUser.Url = strDir + "BizUser.srf";

// CRMAccount proxy object

Microsoft.CRM.Proxy.CRMAccount account = new Microsoft.CRM.Proxy.CRMAccount ();

account.Credentials = System.Net.CredentialCache.DefaultCredentials;

account.Url = strDir + "CRMAccount.srf";

Then you use ADO.Net for calling stored procedure with parameters to do the integration job:

try

{

string SQLStatement="ICS_UpdateAccountPrivate '"+

strAccountId +"' , '" + this.TextBoxWorkPerformed.Text +

"' , "+doubleEncode(System.Double.Parse(this.TextBoxAnnualRevenue.Text))+" , "+

intEncode(System.Int32.Parse(this.TextBoxNumberOfEmployees.Text.Replace(",","")))+" , "+

doubleEncode(System.Double.Parse(this.TextBoxAverageGrowthRate.Text))+" , "+

"'"+this.DropDownListOwnership.SelectedItem.Text +"' , "+

intEncode(System.Int32.Parse(this.RadioButtonList.SelectedItem.Value))+" , "+

intEncode(System.Int32.Parse(this.TextBoxCredit.Text.Replace(",","")))+" , '"+

this.TextBoxComments.Text+"'";

System.Data.SqlClient.SqlConnection tmpConnection =

new System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings["ConnectionStringICS"]

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Colorado, Oregon, Washington, Canada, UK, Australia and having locations in multiple states and internationally (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: 1-866-528-0577 andrewk@albaspectrum.com.

akarasev@albaspectrum.com

Microsoft CRM Customization - processing in/out-going email messages

We would like to give you several situations, when you may need custom development and programming to improve Microsoft CRM functionality. This overview is for programmer, software developer, IT specialist, database administrator.

Microsoft CRM, the CRM application from Microsoft Business Solutions utilizes almost all the recent Microsoft technologies: .Net (it is actually written in C#.Net with HTML and Javascript at the web client side plus has Microsoft CRM SDK with C# and partially VB.Net samples), Microsoft SQL Server, Microsoft Exchange 2003/2000 and others. Now to give you brief review from the workflow and messages - you can send email directly from Account, Contact or Lead and it will be processed by Microsoft CRM-Exchange connector. This email will have GUID in the message header. When addressee answers the email - it will be processed by the connector - it will recognize the GUID and will find the original activity and will attach this email as closed activity to the original object: contact, account or lead. This is very nice feature, but in the real world you may have these situations:

1. CRM user will not use CRM interface and will send email from his/her Outlook. Addressee will receive and respond and these emails will not be handled by Microsoft CRM-Exchange connector. They will not have GUID and connector has no idea on what to do with them.

2. Imagine, that you have Account Best Corporation, with contact person John john@bestcorporation.com. Now new person in Best Corporation, Susan sends you message from susan@bestcorporation.com - and her email will not be connected to your Best Corporation account, because this email doesn't have GUID and it also doesn't have matching email in the contact person. So - it is probably nice to catch emails by domain name as well, say - all the emails, coming from www.bestcorporation.com should be attached to Best Corporation account.

3. Now - your sales rep initiated the first email to the client from Microsoft CRM and got response, transferred back into CRM account. Then he occasionally replied on the reply from outlook - this reply, having GUID will be replied back and not transferred into MS CRM, because MS Exchange connector "thinks" that this message was already replied by the first reply.

4. To decrease the possibility that users will use outlook to send new messages and answer the messages from there - you would probably like the idea to delete them from MS Exchange database when they are transferred to the CRM. In this case they will not be seen in MS Outlook (We are not talking about Microsoft CRM Outlook client, where you actually see CRM data and objects)

If you are programmer or software developer - you can actually program these advancements and we'll give you the direction.

This technique is COM+ applications, registered as Microsoft Exchange sinks or handlers. You can use VisualStudio.Net, but you will not have debugging available, because these applications will work as event handlers. Microsoft Exchange allows you to alter it's logic in the events, exposed for custom handling. Incoming emails should be handled, when ONSYNCSAVE Microsoft Exchange Database event is fired before the commitment. You use Microsoft CRM SDK to create the email activity. You should use direct SQL update to flag the activity as closed (however not recommended by Microsoft - but Microsoft CRM SDK doesn't have the method to close the activity - so you really don't have an option from SDK side). Outgoing emails should be handled with so-called transport events firing, which is more complex and less documented part of Microsoft Exchange SDK.

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 Microsoft CRM, Microsoft Great Plains customization partner, based in Chicago, California, Colorado, Arizona, Texas, Minnesota, New York, Georgia and Florida, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Great Plains Dexterity, SQL, C# and VB.Net, Crystal Reports and Microsoft CRM SDK developer.

akarasev@albaspectrum.com

Microsoft CRM Customization

Microsoft CRM customization techniques are very diversified and based on the whole spectrum of recent Microsoft technologies. The main terms you should know are: Microsoft CRM SDK 1.2 and Visual Studio.Net 2003. And of course you should be familiar with all the legacy internet technologies, such as HTML, XML, XSLT, JavaScript and be good C#/VB/Net developer.

If you are developer who is asked: how do we customize Microsoft CRM read this and you will have the clues on where to look further.

1. Microsoft CRM SDK this is software development kit with C# and partly VB.net examples it is supported by Microsoft Business Solutions technical support. It is all web services based calls, if you are C# .NET developer you are excellently positioned to do this type of customizations. This is the preferred customization scenarios and this should be easily upgradeable customization.

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

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 make job done.

6. MS CRM Customization tool you can feel free to use this 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

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 Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Colorado, Texas, New York, Georgia and Florida, Canada, UK, Australia, Brazil, Mexico (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

akarasev@albaspectrum.com

Microsoft CRM Selection

Microsoft CRM is 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 you 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, based in Chicago, Arizona, Colorado, California, Texas, New York, Georgia and 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

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