Save Time Entering Data into CRM by Mapping Fields between Records

It’s been said that a database is only as good at the data in it. A good way to insure good data is to reduce the amount of data entry by your users and to insure the correct data is entered. A way to accomplish this is through the mapping of fields from parent records to related, child records.

The key to making the mapping work is that the users need to create the new, child record from the parent record. For example, if you have an Opportunity record open, you would then select Quote from the left navigation and then click the ‘Add New Quote’ button from the ribbon when it changes.

To setup the mapping, do the following:

  1. Get to ‘Customizations’.  One way to do this is to go to ‘Settings’, ‘Customizations’, and then choose ‘Customize the System’.


     

  2. Select arrow to the left of the parent entity to expose the sub-menu items. In our example, that is the Opportunity.



     

  3. Once there, go to the Opportunity entity and click on the ’1:N Relationships’.


     

  4. Next click on ‘Mappings’ and then the ‘New’ button.


     

  5. Lastly, choose the source and target fields, click ‘OK’ and you’re done.


     

An important note here is that the field types must be same on both entities if you want to map fields!

Posted in crm | Leave a comment

CRM Webinar Series: 4 Ways for Manufacturers to Increase Sales

Zero2Ten and Microsoft present a CRM Webinar Series that is focused on how CRM can help Manufacturing organizations improve their sales productivity and performance.

Please register by clicking on one of the links below:

Manufacturers in the Steel, Metals and Plastics business have various business models in how they market, sell and service their customers effectively and look to grow their businesses.

We have had the opportunity to implement CRM with a number of these organizations including General Cable and Tempel and have seen some common sales objectives that they are trying to achieve that include:

  1. Increasing Revenues from Existing Customers
  2. Improve Sales Decision Making
  3. Maximize Time Spent Selling
  4. Improve Forecasting Accuracy & Quota Visibility

Attend this webcast to see how each one of these objectives is supported with a good process and CRM to enable it.

Manufacturers in the Steel, Metals and Plastics business have various business models in how they market, sell and service their customers effectively and look to grow their businesses.

We have had the opportunity to implement CRM with a number of these organizations including General Cable and Tempel and have seen some common sales objectives that they are trying to achieve that include:

  1. Increasing Revenues from Existing Customers
  2. Improve Sales Decision Making
  3. Maximize Time Spent Selling
  4. Improve Forecasting Accuracy & Quota Visibility

Attend this webcast to see how each one of these objectives is supported with a good process and CRM to enable it.

Manufacturers in the Steel, Metals and Plastics business have various business models in how they market, sell and service their customers effectively and look to grow their businesses.

We have had the opportunity to implement CRM with a number of these organizations including General Cable and Tempel and have seen some common sales objectives that they are trying to achieve that include:

  1. Increasing Revenues from Existing Customers
  2. Improve Sales Decision Making
  3. Maximize Time Spent Selling
  4. Improve Forecasting Accuracy & Quota Visibility

Attend this webcast to see how each one of these objectives is supported with a good process and CRM to enable it.

Posted in Zero2Ten | Leave a comment

Switching default App to make calls from Microsoft Dynamics CRM

One of the cool features released with the Microsoft Dynamics CRM Polaris update is the Skype Integration. Before Skype integration was available you were able to click on a phone number and dial out via Lync.

If you noticed that your default App is now Skype and would like to switch that back to Lync, follow these steps:

  1. Within Microsoft Dynamics CRM, Navigate to Settings -> Administration -> System Settings.
  2. Scroll down on the General tab and select ‘Lync’ under the “Set the Telephony Provider” section:

     

This will deactivate auto-dialing via Skype.

If you have any questions regarding these steps, drop us a line at info@zero2ten.com

Posted in Zero2Ten | Leave a comment

Turning off Bing integration on Microsoft Dynamics CRM Online

If your CRM Online organization has been upgraded to “Polaris” you have noticed the new User Experience forms on the Account, Contact, Lead, Opportunity and Case entities.

One of the features that came with the new User Experience is the Bing Maps integration. The Bing Maps integration takes the information contained on the “Address 1″ fields and locates the point in the map.

Some organizations are either not going to need this functionality or have a third party more advanced Bing Maps integration so they won’t need the newly included functionality.

You could navigate to each one of the new User Experience forms and remove the visibility for the Bing Maps section manually but that could take some time depending on how many of the new entities are you using with the new forms.

Luckily for us, Microsoft has included a quick way to remove/hide the Bing Maps integration, here are the steps:

  1. Within Microsoft Dynamics CRM, Navigate to Settings -> Administration -> System Settings.
  2. Scroll down on the General tab and select ‘No’ under the “Enable Bing Maps” section:

     

This will hide the Bing maps functionality on all new user interface forms.

If you have any questions regarding these steps, drop us a line at info@zero2ten.com

Posted in Zero2Ten | Leave a comment

Utilizing “Follow” to synchronize Microsoft Dynamics CRM contacts to Microsoft Outlook

One of the things that comes up often is the need to take a contact from Microsoft Dynamics CRM (owned by a different user) and synchronize it to Microsoft Outlook. By default, Microsoft Dynamics CRM contacts are only synchronized to the owner’s Outlook.

Here is another way to utilize out of the box features included with Microsoft Dynamics CRM to solve a problem the feature was not originally intended to resolve. In this case, we will be taking advantage of one of the Social capabilities of Microsoft Dynamics CRM 2011, the ability to “Follow” contacts.

The idea behind this process is to allow multiple users to synchronize the same contact to their Outlook instead of having multiple versions of the same contact in CRM.

First, you need to edit the default Outlook synchronization filter from this:

To this:

This change will enable Outlook to synchronize contacts you are following instead of contacts you own!

All you need to do is go to Microsoft Dynamics CRM (via the Outlook client or the web client) and follow contacts:

The contacts will show up within Outlook after the next synchronization process:

Ownership of the contacts will not be affected.

Here is a short video I recorded explaining the process and demonstrating the solution:

https://www.youtube.com/watch?v=wcc8kVc4J3g

Previously, I blogged about configuring Microsoft Dynamics CRM to automatically follow certain records (http://www.zero2ten.com/blog/automatically-following-records-matching-a-condition-in-microsoft-dynamics-crm-2011/), you can take the process described on that post and combine it with this solution to enable automatic synchronization of contacts to Outlook based on a set criteria. For example, “If a contact is owned by *this user*, make the user’s manager follow the contact” triggering the contact to synchronize to the manager’s Outlook.

If you have any questions regarding these steps, drop us a line at info@zero2ten.com

Posted in Zero2Ten | Leave a comment

Automatically follow records matching a condition in Microsoft Dynamics CRM 2011

As mentioned on my October column regarding Social CRM and the importance of utilizing the Microsoft Dynamics CRM Activity Feeds (https://community.dynamics.com/crm/b/adopt2win/archive/2012/10/30/unleash-the-power-of-social-crm.aspx); I wanted to show you how to configure Microsoft Dynamics CRM 2011 to automatically make a user follow a record that matches certain conditions.

For this article, I’ve decided to configure a workflow that will fire up for opportunities created with an Estimated Revenue equal to or higher than $50,000 and it will make the owner’s manager ‘follow’ the opportunity automatically.

First step is to create a workflow: Navigate to Settings -> Processes -> New:

Include the condition for your automatic follow on the name of the workflow, this makes it easier to identify in the future:

On the workflow, I will select when a record is created and when the “Est. Revenue” field changes (In case an opportunity is created with an estimated revenue lower than $50,000 but then is changed to a value equal to or higher than $50,000).

On the first step of the workflow, I will check that the opportunity is open and that the Est. Revenue is equal to or higher than $50,000:

If the condition is met, we will set the auto-follow by utilizing the “Create Record -> Follow” step:

On the “Create: Follow” step, click on the “Set Properties” button and configure your automatic “Follow” record:

Notice how I have selected the owner’s manager on the “Form Assistant” right navigation pane and set that user as the “owner” of this “follow” record.

Save the changes and activate your workflow.

To test the new workflow, I will create a new opportunity with estimated revenue equals to or higher than $50,000 and follow the opportunity right away:

My user profile shows Mark Wilson as my manager:

A few seconds later, after the workflow has executed successfully, the opportunity owner’s manager will be following that record:

You can add more steps to the workflow to set more users or team members to automatically follow Microsoft Dynamics CRM records based on a condition. For example, if an opportunity is owned by user A, set users B, C and D to automatically follow that opportunity.

This is another way to exploit the social capabilities of Microsoft Dynamics CRM 2011.

If you have any questions regarding these steps, drop us a line at info@zero2ten.com

Posted in Zero2Ten | Leave a comment

Processing opportunities created after qualifying leads on the new User Experience forms in Microsoft Dynamics CRM

If you are currently working with the new User Experience forms on Microsoft Dynamics CRM Online, good for you, Microsoft showed us at Microsoft Convergence that this is the future of the product and thus getting familiar with it is a good move.

The current User Experience looks and works great to a certain extent, I have found several limitations that I hope will be fixed by the time Microsoft Dynamics CRM Orion hits the market in the future.

One of the things that makes the new User Interface stand out is the “Sales Process Bar” that is located at the top of the Lead, Opportunity and Case forms. The advantage of this process bar is a seamless transition between entities but the down side is that sometimes your business doesn’t have the requirement to transition from one entity to another. For example, what if you don’t want to create an Opportunity every time you qualify a Lead?

There are several cases when you wouldn’t want to automatically create an opportunity:

  • You attend an event and come back with 3 leads from the same company. You would create an opportunity for the first lead you qualify on that company but then you just need to create contacts for the other two.
  • You would like to create a Contact and an Account for marketing purposes but will not use this information to generate an opportunity.
  • You employ a third-party organization to qualify leads for you but you would like to control who can create opportunities from those qualified leads.

Out of the box, Duplicate Detection fields have been added to the process bar that prevent a new contact and account to be created every time you qualify a lead but there is nothing out of the box that will prevent an opportunity to be created, so I came up with this quick “solution” to deal with these cases:

  1. Add a field to the Lead entity and Place it on the form, for this example I placed it on the Sales Process Bar. This field is a Two-Option field that will allow the users to choose whether an Opportunity should be created or not after qualifying the Lead:

     

  2. Add the same field to the Opportunity entity, the checkbox does not have to be placed on the form or the Sales Process bar.
  3. Configure the mapping of the 1:N Lead to Opportunity entity to pass the value of this field:

     

     

     

  4. Once the mapping is created, the fields value will be passed from the Lead to the Opportunity upon Qualification so you can use that value to do one of two things:
    1. Create a Workflow that Deactivates the Opportunity (and sets it to a custom StatusCode under the Lost Status, I.E. “Auto-Created”). You can then create a Bulk Delete Job that deletes these Auto-created opportunities daily or weekly.
    2. Deploy the Custom Workflow Utilities from CodePlex (http://crm2011workflowutils.codeplex.com/) and Delete the records right after they are created.

I have chosen Option b in this case and this is how my workflow looks:

As you can see, I’m checking for one condition: is the field I added different than ‘Yes’? If so, it means that the user didn’t want to create an opportunity when the Lead was Qualified. This triggers the custom workflow action that deletes the record out of Microsoft Dynamics CRM. If the user had checked the field before qualifying the Lead, this field would equals ‘Yes’ and the workflow would’ve skipped it, leaving the Opportunity intact.

This is how Peter Houston’s Lead looks after qualifying it:

 

And this is the System Job showing that the resulting Opportunity was deleted:

 

I realize that this is not a solution but more like a workaround since the Opportunity is created but it achieves the goal of not populating your database with open Opportunities that shouldn’t exist.

If you have any questions regarding these steps, drop us a line at info@zero2ten.com

Posted in Zero2Ten | Leave a comment

Adding percent sign (%) to Microsoft Dynamics CRM charts

It is no secret that the charts and dashboard capabilities included in Microsoft Dynamics CRM 2011 are a great tool for reporting and ultimately help increase User Adoption, but even these great tools sometimes lack flexibility. For example, I often find myself working with a customer that wants to see a percentage on a chart instead of a number.

Here is the example:

The chart on the right shows me how many active cases I have segmented by Origin. By looking at the chart, I see that “Phone” is the biggest entry point for these cases but in my mind is hard to figure out percentage wise how much is 10 cases in the system versus the other 18. Since the numbers are low I can quickly do some approximate math in my head and come up with about 40%. But what if this chart was more complex, for example if we had 8 different sources and the numbers were on the hundreds or thousands; it would be tough.

Luckily for us, formatting this chart so it displays percentage instead of count is very simple. If you ever find yourself needing to format one of your charts just follow these five simple steps:

  1. First, Navigate to the chart you need to format and export it via the Chart Tab:

     

     

  2. Save the chart (.xml file) and open it with a text editor, in this case I’m using Notepad++. You will focus on the “Series” section of the chart:

     

     

    Code:

     

    <Series>

    <Series ShadowOffset=”0″ IsValueShownAsLabel=”true” Font=”{0}, 9.5px” LabelForeColor=”59, 59, 59″ CustomProperties=”PieLabelStyle=Inside, PieDrawingStyle=Default” ChartType=”pie”>

    <SmartLabelStyle Enabled=”True” />

    </Series>

    </Series>

     

  3. Switch the “IsValueShownAsLabel” to “FALSE” and Add “Label” and “LabelFormat” values to the Series details as shown below:

     

     

    Code:

     

    <Series>

    <Series ShadowOffset=”0″ IsValueShownAsLabel=”False” Label=”#PERCENT” Font=”{0}, 9.5px” LabelForeColor=”59, 59, 59″ CustomProperties=”PieLabelStyle=Inside, PieDrawingStyle=Default” ChartType=”pie” LabelFormat=”#0.##%”>

    <SmartLabelStyle Enabled=”True” />

    </Series>

    </Series>

     

  4. Save your XML and navigate back to Microsoft Dynamics CRM and the place where you exported the chart. Import the saved XML:

     

     

     

     

  5. Enjoy the new chart!

     

 

If you have any questions regarding these steps, drop us a line at info@zero2ten.com

Posted in Zero2Ten | Leave a comment

Having problems with Microsoft SharePoint Online and Microsoft Dynamics CRM Online Integration lately?

After the upgrade of Microsoft SharePoint Online recently many organization found issues with their existing integration, the reason behind this is that the upgrade to Microsoft SharePoint Online was to Microsoft SharePoint 2013 from Microsoft SharePoint 2010.

As you know, the integration between Microsoft Dynamics CRM and Microsoft SharePoint is enabled by two pieces; the first one is the Microsoft Dynamics CRM List Component that is imported into Microsoft SharePoint and the second one is the configuration you perform on the CRM side to connect to your SharePoint site.

The problems you see are due to the first piece, the CRM Component inside SharePoint, as Microsoft upgraded SharePoint to the 2013 version on the Online platform the CRM List component was not upgraded inside so you need to do this manually.

Here is the official message from the Microsoft team regarding these issues:

Title: Alert: Document Management issue

 

The Document Management feature released as part of a recent service update to SharePoint Online may cause issues with the List component in Microsoft Dynamics CRM. To resolve this, please install the new Microsoft Dynamics CRM List Component for SharePoint Server 2013 from the Microsoft Download Center:   http://go.microsoft.com/fwlink/?LinkId=275763.

Important:   Only use the new List component after the SharePoint Online service update is complete. To learn when the SharePoint Online service update is scheduled for you, refer to the Office 365 service alert email that you were sent. You can also go to the Service Health Dashboard.

What you may experience

Before you install the List component update, these are examples of issues you might experience :

  • You cannot open a PowerPoint file by clicking its link in a document list. Instead, you must download it, and then open it.
  • When you search from a document list, the search results page never stops trying to load.

We apologize for any inconvenience this may cause.

Sincerely,
The Microsoft Dynamics CRM Online Team

Posted in Zero2Ten | Leave a comment

Customer Spotlight: Infuse Consulting

 

IT Services Firm Equips Employees with Easy-to-Use CRM Tool, Supporting Growth

IT services company Infuse Consulting has experienced 600 per cent year-on-year growth since 2002. With people and back-office systems stretched to the limit by rapid expansion, the firm selected Microsoft Partner Zero2Ten to implement Microsoft Dynamics CRM Online and Assistance PSA for Microsoft Dynamics CRM. Infuse now has complete confidence in sales reporting and the sales, marketing, and invoicing tools to support its ambitions.

Business Needs

In common with many small businesses, the growth experienced by Infuse had created a number of challenges for its Managing Director. Tools that had been adequate for a team of two people were proving ineffective by the time that team had expanded to 27.

Nalin Parbhu, Managing Director, Infuse Consulting, says: “Trying to manage our growth has been a challenge. We didn’t have a scalable model. Much of it was in my head—I was the single point of failure.”

Infuse was using Sage ACT for customer relationship management (CRM). And while it was a practical tool, it didn’t provide the detailed pipeline information Parbhu needed. In addition, he was spending too much time administering the system. “A big problem I had was the way you had to set it up on a laptop. I was the administrator and had to connect to our virtual private network to sync the data—it was fine as a one-man business, but with a growing sales team it was an unnecessary burden on my time,” he says.

Invoicing was equally challenging. Infuse had moved from a simple time and materials (T&M) billing model to a combination of fixed price and T&M contracts. The company had also gone from issuing one or two invoices a month with three or four employees submitting timesheets, to 27 employees submitting timesheets and a corresponding increase in invoices being processed. Parbhu says: “My Finance Director found the invoice system particularly frustrating. It was all on a spreadsheet, but it was out of control. I was the only one who could work out the commission structure. Billing and paying expenses were both extremely time-consuming tasks. The situation was far from ideal, and it was even affecting growth. We couldn’t build a business like this—we needed systems that would give us the room and information to grow.”

Solution

Wanting to act fast, Infuse engaged Microsoft Partner Zero2Ten to install Microsoft Dynamics CRM Online and Assistance PSA, a professional services automation (PSA) module that integrates with Microsoft Dynamics. This provides professional services functionality, including contract and project management, resource planning, timesheet and expense management, and invoicing.

Parbhu had evaluated a number of CRM and PSA applications—including Sage, Force.com, and Kimble—but was particularly impressed by Microsoft Dynamics CRM Online. He says: “The two things that really worked for me were the tight integration with Microsoft Outlook and the fact that it was web-based and would always be available and up to date.”

Infuse opted for the Zero2Ten SmartStart implementation, a virtual implementation of a pre-configured instance of Microsoft Dynamics CRM Online, to cut the time it would take to go live with a working solution. Parbhu says: “We needed just one piece of configuration. We went live in just four weeks, including integration with the PSA solution and Quickbooks, our accounting software. If Christmas hadn’t fallen in the middle, it would have taken just two weeks.”

The integration between Microsoft Dynamics CRM and Microsoft Outlook means that Infuse sales people can access the CRM system from their email accounts, rather than having to open a separate system. They can use the same calendar and synchronise their contacts.

Infuse is using PSA to create project proposals as well as for managing timesheets and invoices. Parbhu also has plans to add Microsoft SharePoint Online to the integrated solution—to provide additional functionality and make it available wherever his employees happen to be.

Benefits

Infuse now has an easy-to-use CRM system that supports the needs of a fast-growing services business. It has better visibility of the sales pipeline and Parbhu is confident that he can achieve his 400 per cent growth target.

Pipeline visibility. Infuse has to track and report on leads from partners to ensure continued investment. It also uses an outsource partner to run a sales campaign. Parbhu says: “It was giving us a spreadsheet, but it wasn’t very useful. Now, we put it into the CRM system and I can see the pipeline. I can remove conjecture and see actual results.”

Reduced cost. Parbhu says: “We’re paying around £100 a month for Microsoft Dynamics CRM, whereas Sage ACT was costing us £160 a month. What’s more, I was spending 10 per cent of my time supporting ACT. That’s an opportunity cost of between £20,000 and £200,000 a year. The business case is very simple—I got payback in the first hour I switched to Microsoft Dynamics CRM.”

Ease of use. The sales team has found the CRM tool simple to use. Parbhu says: “Now they’re working in Microsoft Outlook, they’re completely at home with CRM. It’s a much better tool, and they’re actually using it.” Parbhu also benefits from Microsoft Dynamics CRM in the cloud. He says: “They can update it in real time and I can get an instant snapshot view.”

Efficient sales process. Technical Account Directors can now close renewal business themselves, leaving the sales team to concentrate on new business. Parbhu says: “If they’re focusing on renewals, they want to be paid twice and they’re not bringing in new customers.” Sales people are also less reliant on the technical team for winning new business. Parbhu says: “They create their own proposals in a few clicks of a button. They no longer need to involve the technical team, which is saving time and cutting costs.”

Posted in CRM ROI, Customers, Zero2Ten | Leave a comment