How to create a primary contact in MSCRM

January 6th, 2010

The normal why to create a primary contact in MSCRM is to add the contact to the account and then go back to the account and lookup the contact that you just added. You can simplify this a bit by filtering the lookup on primary contact for only contacts from the account (see: Filter Primary Contact for contact associated to Account in MSCRM.) If you use One Click Activity this process is as simple as clicking ‘Set Primary Contact’.

Set Primary Contact from the contact form(use this for new and existing contacts).

This is simple just create a contact, preferable from the account using One Click Activity create contact related to selected entry button. Make sure the contact has a parent account; save the contact (do not close the form). Then once the contact is saved click the One Click Activity ‘Set Primary Contact’ button and you will be prompted to set this contact as the primary for the account. If there is no parent account nothing happens. Note if the account is open you will need to refresh it (F5) to see the changes.

Set Primary Contact from the contact grid (use this for existing contacts).

This is simple just select a contact in the grid (main, associate or advance find). Click the One Click Activity ‘Set Primary Contact’ button and you will be prompted to set this contact as the primary for the account. If there is no parent account nothing happens. Note if the account is open you will need to refresh it (F5) to see the changes.

Completing Multiple Activities in CRM

January 4th, 2010

Completing Activities in Microsoft Dynamics CRM requires the user to open the activity and click save as complete. If you want to add additional information to the activity this is fine but it you just need to complete it why open the form? Also what if you have a number of activity that you have now finished and need to complete, you would need to open each activity and save as complete. Now you can complete multiple activities including: tasks, phone calls, email, fax, letter and appointments right from the any activity grid (main activity grid or associated grid) with icrm one click activity. The complete activity grid button from icrm one click activity first prompts you to make sure you want to complete the selected activities. This make sure you don’t accidentally complete activities as CRM does not let you un-complete any activity.

iCRM One Click Activity Version 2 New Features

December 16th, 2009

ICRM One Click Activity Version 2 should be release latter this week. Here is a list of new features:

  • Complete Activity from the grid (supports: task, phone call, appointments, fax, letter and email)
  • Assign primary contact from grid.
  • Create duplicate entity (supports: accounts, contacts, opportunities, cases, and leads)
  • Create associate entity from an entity
    • From accounts create a contact, opportunity, case, quote, order or invoice.
    • From contacts create an opportunity, case, quote, order or invoice.
    • From opportunity create a quote, order or invoice (brings across product just like creating them from the associate grid).
  • Create the same buttons on the entity from as on the grid.

All the fetchers currently in iCRM One Click Activity Version 1.

Top 5 Business CRM Review

December 2nd, 2009

Which is the Right CRM Vendor for my Business over the last few years The CRM’s have been innovating and Expanding at very rapid rate and there are more and more companies Successfully Adopting CRM According to Gartner’ in 2008 Microsoft had the highest growth rate 75% followed by Sales Force .com at 42.7% and Oracle at 11.8%

Here is a review of top 5 most innovative CRM’s Vendors for Small to Meduim Sized Business’s

  • The Microsoft Dynamics CRM is designed for dynamical business environment. Microsoft Dynamics CRM software provides a perfect CRM solution for those working with a Microsoft infrastructure.

    The key to Microsoft’s CRM software is sales automation. The Dynamic CRM solution offers individualized sales reports with different set of data that managers and sales reps can access. The managers can view the progress of entire sales force and the sales reps can view the data important to them.

    This CRM software simplifies the execution of campaigns and adds mobility to it. It optimizes, manages and tracks the marketing efforts. It offers the marketing analytics highlighting the key performances.

    Moreover, the software is backed by efficient customer service that helps to create a distributed knowledge base that allows sharing of staff expertise.

  • Pros
  • Microsoft’s CRM solution offers an simple and easy to use interface. It offers extensive flexibility of use. The user can work on it from Microsoft Office Outlook, a Web browser, a Microsoft Office SharePoint portal, a custom portal, or even a mobile device.

    Cons

    Some of the standard features are missing like power dialing, voice messaging facilities and options for calling back customers.

  • Salesforce.com offers a web based CRM package. Salesforce CRM solution provides strong supports for tracking contacts, leads, and customer inquiries. It scores high on the reliability quotient and offers a full time, in-house support for businesses. The key modules of the system includes campaigns, leads, accounts and opportunities. The CRM software keeps the pipeline organized and full of qualified leads.

    The prime features of salesforce CRM includes automation of marketing, customer service and support, sales force automation, documentation management, content management, contract management, Product catalog management, analytics and competitors.

    Pros

    What makes salesforce.com an ace CRM solution is its online access. It also provides excellent uptime.

    Cons

    The downside to salesforce is that for outsourcing it uses the ASPs (application service providers). If there are more customers to handle the ASP has to be used for longer time. This results in the increase of expenditure.

  • Sugar CRM The latest version of this open source software can run on Microsoft’s Windows Server operating system and SQL Server database.

    Key features of Sugar CRM

    • Automates the sales force, allows tracking of sales opportunities
    • Assists in managing customer information
    • Enables sharing of customer information with co-workers
    • Generates  informative reports for prioritizing the sales tasks.

    The set up offers an easy to handle interface. It’s allows integration  with Microsoft Outlook and Word. The customizable dashboard offers real time information about business performance. Moreover, bulk of customer data can be imported from other CRM tools such as Sales Force and ACT.

    Pros

    The most appealing feature of Sugar CRM is the affordability, its a perfect CRM solution for the budget conscious businesses. With an open source build-up, Sugar CRM allows the users to customize , integrate and extend the CRM application.  The added functionality are always a plus.

    Cons

    The Sugar CRM is restricted to the small businesses. The CRM solution needs to improve on its pipelines, forecasts and reporting. Above all, the CRM software is yet to be the favorite with business application specialist.

  • Oracle offers four comprehensive Customer Relationship Management (CRM) product lines that leverage enterprise data to drive profitable customer interactions. Oracle’s products cover the breadth of CRM functionality—from sales, marketing, and e-commerce, to customer service and analytics.

    List of Oracle CRM Solutions

    • Siebel
    • PeopleSoft Enterprise
    • Oracle E-Business Suite
    • JD Edwards EnterpriseOne
    • Telephony@Work CallCenterAnywhere

    Pros

    • Simple to use; great for small business organizations
    • Good reporting and analysis
    • Excellent solution if you also use Oracle Financials or similar Oracle application solutions

    Cons

    • Lacks feature sets and functionality depth of some other on-demand CRM solutions
    • Marketing and customer service modules are perceived as very weak
    • Oracle’s SAAS Uncertainty Prior to the Siebel acquisition, CEO Larry Ellison had publicly chastised the SaaS model and discounted its value and potential.
  • Maximizer CRM adapts to the way organizations work, and grows as a company’s business grows. Maximizer offers four editions, as well as several add-on modules and options for the solution that matches a company’s business needs. The right solution will depend on the number of users, access, and feature requirements.

    Key Features

  • Completely Integrates Sales, Marketing and Customer Service and Support Management Solution
  • Simple & quick to deploy and use offering the lowest total cost of ownership in its class
  • Multiple access Options Mobile Devices, Desktop, Web or remote synchronization

    Pros

  • Is simple and quick to deploy, learn, use and maintain
  • Provides multiple access options for today’s mobile workforce
  • Offers the best value in its class for full-featured CRM software

    Cons

  • The Outlook integration is weak
  • Its Saas Model needs to improve

MSCRM 4 icons

November 12th, 2009

Ever need to link to the MSCRM icon?  The icons are all stored in the _imgs folder off the main crm directory (note you should not include the organization name in the url).  The name for the 16 by 16 icons are ico_16_{0}.gif  where {0} is the Entity Type.  I have not added custom icon so I am not sure if they follow the same format.  Also note there are ico_18_{0}.gif and ico_lrg_{0}.gif

Entity Type Codes:

Entity name Value
None 0
Account 1
AccountLeads 16
ActivityMimeAttachment 1001
ActivityParty 135
ActivityPartyRollupByAccount 4603
ActivityPartyRollupByContact 4604
ActivityPointer 4200
Annotation 5
AnnualFiscalCalendar 2000
Appointment 4201
AsyncOperation 4700
AttributeMap 4601
BulkOperation 4406
BulkOperationLog 4405
BusinessUnit 10
BusinessUnitMap 6
BusinessUnitNewsArticle 132
Calendar 4003
CalendarRule 4004
Campaign 4400
CampaignActivity 4402
CampaignActivityItem 4404
CampaignItem 4403
CampaignResponse 4401
ColumnMapping 4417
Commitment 4215
Competitor 123
CompetitorAddress 1004
CompetitorProduct 1006
CompetitorSalesLiterature 26
ConstraintBasedGroup 4007
Contact 2
ContactInvoices 17
ContactLeads 22
ContactOrders 19
ContactQueues 18
Contract 1010
ContractDetail 1011
ContractTemplate 2011
CustomerAddress 1071
CustomerOpportunityRole 4503
CustomerRelationship 4502
Discount 1013
DiscountType 1080
DocumentIndex 126
DuplicateRecord 4415
Email 4202
EntityMap 4600
Equipment 4000
Fax 4204
FilterTemplate 30
FixedMonthlyFiscalCalendar 2004
Import 4410
ImportFile 4412
ImportMap 4411
Incident 112
IncidentResolution 4206
IntegrationStatus 3000
InternalAddress 1003
Invoice 1090
InvoiceDetail 1091
KbArticle 127
KbArticleComment 1082
KbArticleTemplate 1016
Lead 4
LeadAddress 1017
LeadCompetitors 24
LeadProduct 27
Letter 4207
License 2027
List 4300
ListMember 4301
LookUpMapping 4419
MailMergeTemplate 9106
MonthlyFiscalCalendar 2003
Opportunity 3
OpportunityClose 4208
OpportunityCompetitors 25
OpportunityProduct 1083
OrderClose 4209
Organization 1019
OrganizationUI 1021
OwnerMapping 4420
PhoneCall 4210
PickListMapping 4418
PluginType 4602
PluginAssembly 4605
PriceLevel 1022
PrincipalObjectAccess 11
Privilege 1023
PrivilegeObjectTypeCodes 31
Product 1024
ProductAssociation 1025
ProductPriceLevel 1026
ProductSalesLiterature 21
ProductSubstitute 1028
QuarterlyFiscalCalendar 2002
Queue 2020
QueueItem 2029
Quote 1084
QuoteClose 4211
QuoteDetail 1085
RelationshipRole 4500
RelationshipRoleMap 4501
Resource 4002
ResourceGroup 4005
ResourceSpec 4006
Role 1036
RolePrivileges 12
RoleTemplate 1037
RoleTemplatePrivileges 28
DuplicateRule 4414
DuplicateRuleCondition 4416
SalesLiterature 1038
SalesLiteratureItem 1070
SalesOrder 1088
SalesOrderDetail 1089
SavedQuery 1039
SdkMessage 4606
SdkMessagePair 4613
SdkMessageRequest 4609
SdkMessageRequestField 4614
SdkMessageRequestInput 4612
SdkMessageResponse 4610
SdkMessageResponseField 4611
SdkMessageFilter 4607
SdkMessageProcessingStep 4608
SdkMessageProcessingStepImage 4615
SemiAnnualFiscalCalendar 2001
Service 4001
ServiceAppointment 4214
ServiceContractContacts 20
Site 4009
StatusMap 1075
StringMap 1043
Subject 129
Subscription 29
SubscriptionClients 1072
SubscriptionSyncInfo 33
SystemUser 8
SystemUserLicenses 13
SystemUserPrincipals 14
SystemUserRoles 15
Task 4212
Team 9
TeamMembership 23
Template 2010
Territory 2013
TransformationMapping 4426
TransformationParameterMapping 4427
UnresolvedAddress 2012
UoM 1055
UoMSchedule 1056
UserFiscalCalendar 1086
UserQuery 4230
UserSettings 150
WorkflowCompletedScope 4701
WorkflowWaitSubscription 4702
Workflow 4703
WorkflowDependency 4704

Creating A Following Associated Grid

November 5th, 2009

Here is an example of how to create a follwing associated gird on a entity form. The idea here is to put two embedded grids on the form and relate one to the other. An embedded grid is an associated grid embedded in an iFrame. This is great is a great way to see associated records without having to navigate to the associated view. To learn about embedded grids see Customer Effective Blog. The next step is to capture the “onselectionchange” event of the first grid and pass this id and type to the second grid. To learn about “onselectionchange” event see More CRM Grid Goodies: Detecting Click Event by Customer Effective Blog.

Here is how it is done.

First add a parent iFrame and a child iFrame to the form. These will hold the embedded grids, set the src to “about:blank”. Now will start adding code to the On_Load event of the form.

function GetFrameSource(tabSet)
{
if (crmForm.ObjectId != null)
{
var oId = crmForm.ObjectId;
var oType = crmForm.ObjectTypeCode;
var security = crmFormSubmit.crmFormSubmitSecurity.value;
return “areas.aspx?oId=” + oId + “&oType=” + oType + “&security=” + security + “&tabSet=” + tabSet;
}
else
return “about:blank”;
}
}

crmForm.all.IFRAME_parent.src = GetFrameSource(”new_new_maxexchangeserver_new_remoteaddressbo”);

The GetFrameSource function get the url for the current form for the set tabSet.

function GetFrameSourceID(oId, oType, tabSet)
{
if (crmForm.ObjectId != null)
{
var security = crmFormSubmit.crmFormSubmitSecurity.value;
return “areas.aspx?oId=” + oId + “&oType=” + oType + “&security=” + security + “&tabSet=” + tabSet;
}
else
{
return “about:blank”;
}
}

The GetFrameSourceID get the url for the parent grid row. You need to pass the id of the current entity in the grid as well as the typeid of the entity.

var bFired = false;
GridClick = function()
{
// check to see if this event has been fired already
if(bFired == false)
{
var frameDoc = document.getElementById(”IFRAME_parent”).contentWindow.document;
var crmGrid = frameDoc.all['crmGrid'];
var a = crmGrid.InnerGrid.SelectedRecords;
if (a.length > 0)
{
//Get the url to set for the child grid. Note we are always using the first selected value if more than one is selected.
crmForm.all.IFRAME_child.src = GetFrameSourceID(a[0][0],a[0][1],”new_new_remoteaddressbook_new_maxexchangepack”);
}
bFired = true;
}
else
{
// toggle our fired flag back
bFired = false;
}
}

The GridClick function will be called each time a row is selected.

AttachGridEvent = function()
{
if(crmForm.all.IFRAME_parent.readyState == “complete”)
{
var frameDoc = document.getElementById(”IFRAME_parent”).contentWindow.document;
frameDoc.all['crmGrid'].InnerGrid.attachEvent(”onselectionchange”, GridClick);
GridClick();
}
}
crmForm.all.IFRAME_parent.onreadystatechange = AttachGridEvent;

The AttachGridEvent attaches the GridClick event to the grid onselectionchange event. The challange here is we can not attach to the grid in the iFrame until the grid is loaded (readyState == “complete”). To do this we attach the GridClick event on the change of ready state and only add it if the readyState == “complete”.


© 2009-2010 iCRM Blog All Rights Reserved -- Copyright notice by Blog Copyright