Corporate Accounting: Microsoft Dynamics CRM 3.0 Implementation for large corporation ? overview

Since December 2005 we are talking about Microsoft CRM version 3.0.  In the case of established corporate business we usually deal with such legacy environment as IBM Lotus Notes Domino

Since December 2005 we are talking about Microsoft CRM version 3.0.  In the case of established corporate business we usually deal with such legacy environment as IBM Lotus Notes Domino (predecessor of all the modern CRM applications as well as legitimate generic CRM platform), integration with Microsoft (such as MS SQL Server) and non-Microsoft database platforms and applications: Oracle E-Business Suite, Oracle Financials and custom Oracle databases, IBM AS/400 and RS6000 DB2 applications, SUN Java II EJB (as eCommerce front and back ends).  Microsoft CRM should be integrated with existing applications and there is no way to simply switch all the corporate ERP to become Microsoft Windows workshop.  Let?s look at Corporate MRP for large corporation and how Microsoft CRM 3.0 could contribute and be a part of its computer environment.

• Sales Module.  You should probably begin with simple.  If you are facing sales department reshaping (from computerization standpoint) ? you can apply all your MCSE skills and knowledge to install, integrate (with MS Exchange, Active Directory, custom MS SQL databases) and train Sales people to use MS CRM as their sales automation software.  It is pretty intuitive: you register Sales Lead, then move it to the Opportunity (where you can create a quote), then move it to Account/Customer and then you can use MS CRM Outlook client to print Sales Quote with Microsoft Mail Merge technology (MS Word format template with your company logo and quotation lines).  If you start with Sales module ? the investment (MS CRM software license cost) will be optimized/minimized ? all the other departments will be working with their ?legacy? CRM applications, such as Siebel, SalesLogix, Lotus Notes Domino, custom CRM systems, etc.
• MS CRM Security.  Security comes one of the firsts when we are talking about corporate environment.  In MS CRM you have two conceptions: Owning and Sharing CRM objects.  You can share object with unlimited number of groups, the drawback of sharing ? shared object (Lead, Opportunity, Account, Contact) doesn?t show in my Leads, my Opportunities, my Accounts, etc. as well as in MS CRM Outlook client calendar
• Integration with Microsoft Dynamics GP 9.0/Microsoft Great Plains.  Microsoft CRM 1.2 had Microsoft Great Plains CRM integration tool, utilizing BizTalk behind the scenes and our company used it to move MS CRM Customers and Orders into our Accounting ? Microsoft Great Plains 8.0.  With the version 3.0 of Microsoft CRM and Microsoft Dynamics GP 9.0 we see that Scribe Software is the champion with the integration between the two ? however Scribe Software dictates the price for its integration tool
• Integration with IBM Lotus Notes Domino.  This was relatively long story.  Both Microsoft Business Solutions and Lotus Software were reluctant to recognize and support Microsoft CRM Lotus Notes Domino connector, written and supported by Alba Spectrum Technologies, beginning with MS CRM 1.2 and Lotus Notes 6.0 (when Java agents were introduced for IBM Lotus Domino).  Then, when Microsoft Business Solutions lost Microsoft CRM sales to such client as Caterpillar in LATAM to Saleslogix CRM ? Microsoft in Sao Paulo changed its position.  Now Alba Spectrum connector is recognized by Microsoft and is on the way to be recognized and recommended by IBM as well.  One of the main reasons to keep utilizing both CRM solutions: Lotus and Microsoft ? to optimize software licenses cost ? IBM Lotus licenses (used in Legal, Production/Manufacturing, Customer Support) and Microsoft CRM licenses (used in Sales & Marketing departments)
• International Considerations.  Microsoft Dynamics CRM is preferred Microsoft Business Solutions CRM worldwide, however Microsoft Dynamics AX (Microsoft Axapta) and Microsoft Dynamics NAV (Microsoft Navision/Navision Attain) have their own CRM modules.  Integration between Microsoft Great Plains exists, plus integration with Navision and Axapta is and will be available through third parties.  If you are Multinational corporation with manufacturing facilities in Latin America, Brazil, Africa, Asia, Australia ? and you would like to use one of MBS ERP products in your headquarters: Axapta, Navision, Great Plains or Solomon (Microsoft Dynamics SL).  Localization question is relatively simple for Microsoft CRM 3.0 ? it is easily translated to Portuguese, Spanish, Italian, German, French, Russian, Polish, Chinese, Dutch, Japanese, etc.
• Competition.  We already mentioned Oracle E-Business Suite.  From SAP ? you should consider SAP Business One with its CRM module and integration with Microsoft Office/Outlook (this is not related to Mendocino SAP mySAP SAP R/3 or SAP all-in-One project with Microsoft ? SAP Business One has its own original integration with MS Office)

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.

Microsoft CRM Data Migration ? Overview For Consultant Developer

Microsoft Dynamics CRM 3.0 is now parading and triggering Microsoft CRM installation, implementation, customization, data conversion, upgrade and migration interest. We often see the questions on data import and massage options to Microsoft CRM from such systems as ACT!, custom Oracle, DB2, MS SQL Server databases, in all these cases IT departments should do their homework and understand their options, up to the point of making data massaging through Microsoft CRM SDK C# or VB.Net programming (if they have resources or could afford contract programmers)

? Built-in Migration tool. You can only import master records, such as leads and contacts. Please, be advised not to rely on this migration, if you are looking to migrate your ACT! history (activities, transactions, etc.)

? Scribe. Well ? we have to admit that these folks are experts and their tools are excellent (the best you could find). Scribe itself however may require to have experienced IT people in staff. In our experience ? customers are asking for help in deploying scribe migration, especially integration with Microsoft Great Plains/Dynamics GP 9.0 or 8.0. Scribe is catching up with migration tool, you may see natural delays with such features as duplication recognition (when you already have the lead, account, contact with similar phone number, email, contact name, etc.)

? Microsoft CRM SDK Programming. Technically ? this way can resolve all your issues, however the price and learning curve may be negative factor. Typically, as our experience indicates ? developer should have 2-3 MS CRM SDK mid-size customization projects under his/her belt to do the job seamlessly.

? ACT! SDK Programming. Normally Scribe can do the job, however in some exotic cases when customer is using newest version of ACT! (and Scribe is not ready with its scripts) ? you can deploy ACT! SDK to get access to ACT data and create automatic migration script (in concert with MS CRM 3.0/1.2 SDK Programming)

? Microsoft CRM Upgrade. Usually from 1.0 or 1.2 to 3.0. Please check with us if you have issues. Microsoft CRM 3.0 has multiple redesigned structures. We plan to publish dedicated to MS Dynamics CRM 3.0 upgrade article

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

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

Microsoft CRM messaging through Lotus Domino email server - balanced solution

Microsoft CRM and IBM Lotus Notes Domino seem to be taking completely different paths and if company is Microsoft oriented - we see MS CRM, MS Exchange, MS SQL Server, SharePoint, etc. In the case of Lotus Domino - it is opposite - Lotus is corporate Information Media and could technically play CRM role with internal messaging coming through Lotus Domino server. However realities of modern corporation give us multiple examples when Microsoft CRM and Lotus Domino should coexist in compromise. There are several reasons why corporation doesn't like to stick to one platform:
1. Balancing several platforms not to be trapped to the one-vendor solution. Imagine, that you placed all the eggs into one basket and then this basket went into the trouble (lawsuit, bankruptcy, mismanagement, hostile takeover - to name a few in the life of the modern American corporation)
2. Legacy-dependence. If your corporation uses such product as Lotus Notes/Domino for 10 plus years - you can expect that majority of documents are stored in the Lotus databases. Just conversion of this legacy database is multi-million dollars project. And again - we could not predict the future accurately - who will win or lose - IBM or Microsoft - or maybe they will merge
3. Procedures and flowcharts. Nowadays corporation works and builds its business model around computer business system, consider things like users training, functional flowcharts/diagrams, reporting to investors, IDE with company vendors and customer. And we'd dare to say that these things are computer application platform dependent (even being designed in the heads of corporation founding leaders as abstract business processes - then they were placed into the computer platform and had to fit to its pluses and minuses)
Considering these arguments and having multiple requests from Microsoft Business Solutions and directly from our prospects and customer, we have realized the connector, which allows Microsoft CRM use Lotus Domino email server with similar messaging functionality as Microsoft Exchange 2003/2000
Microsoft CRM Exchange connector needs to be installed and its DLL based functionality is superceded by our own DLL, which communicates with Lotus Domino server via Java Agents
You can always have us help you with the integration and customization. Call us: 1-866-528-0577, 1-630-961-5918.

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

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

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

Boris is Lead 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 and having locations in multiple states and internationally ( http://www.albaspectrum.com)

Small Business CRM Is Here To Stay

If you ask most small business owners what priority CRM has in their short-term business plans, chances are youll get more than one blank stare. The fact is that most small business owners dont even know what CRM is not to mention how significantly it can benefit their growing company. This prevailing ignorance of small business CRM (customer relationship management) usually stems from just a few basic causes.

Excuses not to invest in small business CRM
The first and most common reason for disinterest in small business CRM is the very nature of small business. With limited financial and personnel resources at their disposal, business owners believe they cant afford the money or time that a small business CRM system would require to show a significant ROI. Often times the chief concern is just staying afloat long enough to sign that big contract or receive a large product order.

Still other owners of new businesses believe that they can build and maintain quality customer relations simply by the virtue of the their cordial personality or particular market niche. They see small business CRM as an unessential luxury to be enjoyed exclusively by their larger competitors. What these owners often find is that without sufficient small business CRM support their business will never expand beyond the number of customer names they can remember. The problem is compounded when the company expands into internet sales (an essential move by any growing company) and suddenly finds its present customer tracking system overwhelmed by the sheer amount of incoming customer information.

The Bottom Line
The bottom line, as all successful small business owners have learned, is that it takes more than one good idea to build long-term business growth and stability. You may be great at attracting new customers to your business, but if you fail to care for, track, and understand your customer base, not only will you hemorrhage your hard-won clientele, you will also fail to capitalize on future opportunities by not anticipating future market trends.

The Solution
The good news about small business CRM is that there is an increasing number of automated systems available at prices that most smaller companies can afford without too much difficulty, usually around $2000 a year. Some CRM companies, effectively eliminating the need for small business owners to micromanage their CRM system, largely manage newer small business CRM systems. Now small business owners can reap the benefits of a smooth running CRM system with a minimal time/financial investment.

Features to look for in a small business CRM system
There are many features available to small business CRM users designed to not only track sales, but also cause sales. Here are some features to look for.
Power Dialing-This feature allows your outbound sales agents to place 300%-400% as many sales calls, effectively quadrupling your workforce.
Voice Messaging System-Allows you to automatically record and send sales calls designed to elicit a customer call back.
Custom Fax and Email-Following up on leads with timely fax and email can mean the difference between closing sales and missing out on potential revenue.

Other must-have features include:

Calendaring
Marketing management
Sales management
Order and quote management
Service management

With the ability to outsource these business functions, small business owners can concentrate on implementing strategies that theyve had to hold off on due to lack of customer information and/or time.

Cameron Brown is an internet marketer specializing in phone sales. For more information on small business CRM, please visit Inside Sales.

Microsoft CRM Customization programming Closed Email Activity

 Microsoft CRM is CRM answer from Microsoft and attempt to get market share from Siebel, Oracle and others traditional Client Relationship Management System vendors. Microsoft CRM uses all the spectrum of Microsoft recent technologies: .Net, MS Exchange, MS Outlook, MS SQL Server, Replication, Indexing, Active Directory, Windows 2000/2003 security model, C#, VB.Net, HTML, XML Web Service, XLTP, Javascript to name a few.

Today's topic is Activity of email type programming - you usually deal with these customizations when you improve Microsoft Exchange CRM connector. How do you create closed activity - this is the main discussion topic. Well use C#.Net coding

One of the roles of our Exchange Event Handler/Sink is creation MS CRM Closed Activity in handling incoming and outgoing email messages. The interaction with Microsoft CRM uses two approached using MS CRM SDK (handling inbound and outbound XML messages) and via direct access to MS CRM Database. Lets first look at the Closed Activity creation algorithm:

1. First we need to understand the entity we need to create activity for: Account, Lead or Contact. The selection should use specific criteria in our case this is email address:

if ((crmAccount = crmConnector.GetAccount(mailboxFrom)) != null) {

}

else if ((crmContact = crmConnector.GetContact(mailboxFrom)) != null) {

}

else if ((crmLead = crmConnector.GetLead(mailboxFrom)) != null) {

}

2. Then we have to get GUID of MS CRM user, who owns this entity, C# code like this:

crmUser = crmConnector.GetUser(crmAccount.GetOwnerId());

3. Next step is closed Activity creation:

emailId = crmConnector.CreateEmailActivity(

crmUser.GetId(),

Microsoft.Crm.Platform.Types.ObjectType.otAccount, crmAccount.GetId(),

Microsoft.Crm.Platform.Types.ObjectType.otSystemUser, crmUser.GetId(),

crmAccount.GetEmailAddress(), crmUser.GetEmailAddress(), sSubject, sBody);

4. The method to create closed activity:

public Guid CreateEmailActivity(Guid userId, int fromObjectType, Guid fromObjectId, int toObjectType, Guid toObjectId, string mailFrom, string mailTo, string subject, string body) {

try {

log.Debug("Prepare for Mail Activity Creating");

// BizUser proxy object

Microsoft.Crm.Platform.Proxy.BizUser bizUser = new Microsoft.Crm.Platform.Proxy.BizUser();

ICredentials credentials = new NetworkCredential(sysUserId, sysPassword, sysDomain);

bizUser.Url = crmDir + "BizUser.srf";

bizUser.Credentials = credentials;

Microsoft.Crm.Platform.Proxy.CUserAuth userAuth = bizUser.WhoAmI();

// CRMEmail proxy object

Microsoft.Crm.Platform.Proxy.CRMEmail email = new Microsoft.Crm.Platform.Proxy.CRMEmail();

email.Credentials = credentials;

email.Url = crmDir + "CRMEmail.srf";

// Set up the XML string for the activity

string strActivityXml = "";

strActivityXml += "";

strActivityXml += "") + "]]>";

strActivityXml += "";

strActivityXml += userId.ToString("B") + "";

strActivityXml += "";

// Set up the XML string for the activity parties

string strPartiesXml = "";

strPartiesXml += "";

strPartiesXml += "" + mailTo + "";

if (toObjectType == Microsoft.Crm.Platform.Types.ObjectType.otSystemUser) {

strPartiesXml += "" + Microsoft.Crm.Platform.Types.ObjectType.otSystemUser.ToString() + "";

}

else if (toObjectType == Microsoft.Crm.Platform.Types.ObjectType.otAccount) {

strPartiesXml += "" + Microsoft.Crm.Platform.Types.ObjectType.otAccount.ToString() + "";

}

else if (toObjectType == Microsoft.Crm.Platform.Types.ObjectType.otContact) {

strPartiesXml += "" + Microsoft.Crm.Platform.Types.ObjectType.otContact.ToString() + "";

}

else if (toObjectType == Microsoft.Crm.Platform.Types.ObjectType.otLead) {

strPartiesXml += "" + Microsoft.Crm.Platform.Types.ObjectType.otLead.ToString() + "";

}

strPartiesXml += ""+ toObjectId.ToString("B") + "";

strPartiesXml += "";

strPartiesXml += Microsoft.Crm.Platform.Types.ACTIVITY_PARTY_TYPE.ACTIVITY_PARTY_TO_RECIPIENT.ToString();

strPartiesXml += "";

strPartiesXml += "";

strPartiesXml += "";

strPartiesXml += "" + mailFrom + "";

if (fromObjectType == Microsoft.Crm.Platform.Types.ObjectType.otSystemUser) {

strPartiesXml += "" + Microsoft.Crm.Platform.Types.ObjectType.otSystemUser.ToString() + "";

}

else if (fromObjectType == Microsoft.Crm.Platform.Types.ObjectType.otAccount) {

strPartiesXml += "" + Microsoft.Crm.Platform.Types.ObjectType.otAccount.ToString() + "";

}

else if (fromObjectType == Microsoft.Crm.Platform.Types.ObjectType.otContact) {

strPartiesXml += "" + Microsoft.Crm.Platform.Types.ObjectType.otContact.ToString() + "";

}

else if (fromObjectType == Microsoft.Crm.Platform.Types.ObjectType.otLead) {

strPartiesXml += "" + Microsoft.Crm.Platform.Types.ObjectType.otLead.ToString() + "";

}

strPartiesXml += ""+ fromObjectId.ToString("B") + "";

strPartiesXml += "";

strPartiesXml += Microsoft.Crm.Platform.Types.ACTIVITY_PARTY_TYPE.ACTIVITY_PARTY_SENDER.ToString();

strPartiesXml += "";

strPartiesXml += "";

strPartiesXml += "";

log.Debug(strPartiesXml);

// Create the e-mail object

Guid emailId = new Guid(email.Create(userAuth, strActivityXml, strPartiesXml));

return emailId;

}

catch (System.Web.Services.Protocols.SoapException e) {

log.Debug("ErrorMessage: " + e.Message + " " + e.Detail.OuterXml + " Source: " + e.Source);

}

catch (Exception e) {

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

}

return new Guid();

}

5. To make the activity just created be shown correctly you need to setup its flags according to MS CRM standards:

public void UpdateActivityCodes(Guid emailId) {

try {

OleDbCommand command = conn.CreateCommand();

command.CommandText = "UPDATE ActivityBase SET DirectionCode = (?), StateCode = (?), PriorityCode = (?) WHERE ActivityId = (?)";

command.Prepare();

command.Parameters.Add(new OleDbParameter("DirectionCode", Microsoft.Crm.Platform.Types.EVENT_DIRECTION.ED_INCOMING));

command.Parameters.Add(new OleDbParameter("StateCode", Microsoft.Crm.Platform.Types.ACTIVITY_STATE.ACTS_CLOSED));

command.Parameters.Add(new OleDbParameter("PriorityCode", Microsoft.Crm.Platform.Types.PRIORITY_CODE.PC_MEDIUM));

command.Parameters.Add(new OleDbParameter("ActivityId", emailId));

log.Debug("Prepare to update activity code " + emailId.ToString("B") + " in ActivityBase");

command.ExecuteNonQuery();

}

catch(Exception e) {

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

}

}

public void UpdateActivityQueueCodes(Guid emailId, Guid queueId) {

try {

OleDbCommand command = conn.CreateCommand();

command.CommandText = "UPDATE QueueItemBase SET Priority = (?), State = (?), QueueId = (?) WHERE ObjectId = (?)";

command.Prepare();

command.Parameters.Add(new OleDbParameter("Priority", Microsoft.Crm.Platform.Types.PRIORITY_CODE.PC_MEDIUM));

command.Parameters.Add(new OleDbParameter("State", Microsoft.Crm.Platform.Types.ACTIVITY_STATE.ACTS_CLOSED));

command.Parameters.Add(new OleDbParameter("QueueId", queueId));

command.Parameters.Add(new OleDbParameter("ObjectId", emailId));

log.Debug("Prepare to update activity queue code " + emailId.ToString("B") + " in QueueItemBase");

command.ExecuteNonQuery();

}

catch(Exception e) {

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

}

}

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

Boris Makushkin is Lead Software Developer 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, Miami, Montreal, Toronto, Vancouver, Madrid, Moscow, Europe and internationally (www.albaspectrum.com), he is Microsoft CRM SDK, C#, VB.Net, SQL, Oracle, Unix developer. Boris can be reached: 1-866-528-0577 or borism@albaspectrum.com.

borism@albaspectrum.com