CRM Online Spring 2015 – Immersive Excel

Posted by on May 1, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (0)

Microsoft recently announced the CRM Online Spring Release ‘15 and subsequently lifted the NDA around the release and therefore it’s time to start posting about all the great new features coming!

This post will cover the new Immersive Excel feature that Microsoft is rolling out.

What is it?

Immersive Excel is Microsoft’s new way to have a richer Microsoft Excel experience directly in Dynamics CRM.  You’re no longer required to export your data to Excel to be able to perform more complex analysis on it (though this functionality still remains).  You can now perform this analysis directly within Dynamics CRM.

image

What can it do?:

So what can the new Immersive Excel feature within Dynamics CRM do?  How close to actual Excel do I get when I use it?  Well the answer is that Immersive Excel is actually using Excel Online from within the CRM browser window.  Therefore anything you can do with Excel Online,  you can do with Immersive Excel.

This includes the ability to work with Excel Formulas directly from your list of CRM data, without leaving CRM.  You can calculate what the Commission you could make for your Opportunities, by multiplying the revenue by 10%, if the probability is at least 90%.

 image image  

You can make updates to records which honor field validation (e.g., you cannot enter a string into a date field, you can only select from the available option set values, min and max values, etc.), and then click on Save Changes to CRM.  Or you can simply return back to the CRM list without saving your changes.  Immersive Excel allows you to change multiple records quickly acting like an editable grid.  However, you must click the button to save the changes before the records are updated.

You currently cannot do perform a Save As to save an Excel Doc (due to technical limitations) but you can copy/paste from the embedded Immersive Excel page to another Excel document. Hopefully this will be fixed in a future release.

Requirements

In order to make use of this new functionality, the following requirements must be met:

  • CRM Online (currently we are unaware of any plans to bring this to OnPrem)
  • Separate O365 License required (Online version of Office)
  • Export to Excel Security Role Privilege
  • Available in the Web Client only (not available for the phone, tablet, or Outlook clients yet)

Miscellaneous and Summary:

Immersive Excel is a neat new tool that will provide CRM users with an additional option to perform some more ad-hoc quick queries, reports, dashboards to analyze data on the fly.

Note that this functionality is recommended purely for “on the fly” analytics, and not for someone to save the Excel file locally.  Use Export to Excel for that functionality.

After 5 minutes, the file is regenerated per view per user. There is an indicator in the top right of the page shows when the file was generated.  Take note of this time as Microsoft doesn’t want to bombard the servers with constant regeneration, but they also don’t want the data to become stale.  Therefore if you’re using this functionality to make changes to records, remember to save early and often to make sure none of your changes are lost.

image

Also note that the import of the data from Excel Online will take time.  A data import async job is kicked off to perform this functionality that you can monitor to see when it completes.

I hope you’re as excited about this functionality as we are, and hope you’re able to get your hands on it soon!

CRM Online Spring 2015 – OneNote Integration

Posted by on April 15, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (1)

Microsoft recently announced the CRM Online Spring Release ‘15 and subsequently lifted the NDA around the release and therefore it’s time to start posting about all the great new features coming!

This post will cover the new OneNote Integration feature that Microsoft is rolling out.

How it Works

Now with the new release, there will be a new OneNote tab that’s part of the activity Social Pane (posts / activities / notes / OneNote).  This functionality isn’t limited to only the web, but is also available on the Phone and Tablet clients as well.

SNAGHTML13848c45 

A few key features and benefits of the OneNote integrate with CRM are:

  • You can take photos, record voice, manage to-dos, preserve HTML & hyperlinks, use handwriting, have tables, embedded Excel docs, etc.
  • Uses the native CRM Security Model for access
  • Allows version history
  • When performing a search, it actually searches the content of the note, and not just the title like traditional notes
  • Stores notes in SharePoint not in CRM Database
  • Each record in CRM has a dedicated notebook in SharePoint
  • SharePoint Notebook name = CRM Record name
  • Each notebook can have multiple sections with multiple pages
  • All users share the same notebook
  • Web Client: opens OneNote Online in a separate tab
  • Tablet Client in Windows: opens OneNote app in the side-by-side experience with CRM
  • Phone Client: opens OneNote App
  • Notebook can be auto created when OneNote tab clicked (in the Web Client only)
  • Navigate to OneNote to add new notes

Best Practices

There are some best practices that you should be aware of if you’re interested in using the OneNote integration with CRM.

  • Pin notes on your device.
  • Use side-by-side experience for windows
  • Take notes quickly using Quick Notes and move to page later
  • Close notebook when not using it to save OneNote performance and search results

Setup and Requirements

The OneNote integration currently is only available for CRM Online.  Also, you must have the SharePoint integration enabled as the OneNote notebooks are stored in SharePoint.

You need to enable the SharePoint integration (Document Management) for the specific entities that you’re interested in storing OneNote documents for.  Once you enable this on the entity definition, you then have to go into the OneNote Integration settings area, and enable OneNote for those entities.  The list of entities that appear in the OneNote Integration settings are those entities which have SharePoint enabled.

Note that the OneNote integration can also be enabled from the entity itself once Document Management is enabled.  So you can go to a global area to see all the entities where OneNote is enabled, or you can do it from a single specific entity.

image

SNAGHTML1383cc9f

SNAGHTML13821a4b[4]

CRM Online Spring 2015 – Office Groups Integration

Posted by on April 8, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (0)

Microsoft recently announced the CRM Online Spring Release ‘15 and subsequently lifted the NDA around the release and therefore it’s time to start posting about all the great new features coming!

This post will cover the new Office Groups Integration feature that Microsoft is rolling out.

Office Groups

First off let’s discuss what Office Groups are.   Office Groups are a new space to collaborate with a group of O365 users.  These don’t have to be CRM Users, but instead just users of O365.

With Office Groups, you easily indicate what content from different Office products should be shared with other O365 users.  This can be content from Outlook, OneNote, OneDrive. 

To be more specific, the following content can be shared from these Office products:

  • Outlook:
    • Calendar (Outlook Appointments)
    • Conversations (Outlook Emails)
  • OneNote:  Notebooks
  • OneDrive:  Documents

CRM Integration

Now that we know the basics of what Office Groups are, how does it integrate with Dynamics CRM? 

For each CRM record identified to have an Office Group created, an Office Group will be created behind the scenes for that record.  The CRM Record Name will become the Office Group Name.

Then, on the CRM record form itself, there will be a tab “Items Shared with Group”

image

This tab will allow you to collaborate with non-CRM users who are O365 users.  On this tab you’ll be able to:

  • See across the various office products (Outlook, OneNote, etc.) items shared to the specific office group
  • See Yammer like conversations for emails
  • For Opps Only, adding people to the Sales Team will automatically add the person to the O365 group

Setup

Currently this is a solution that’s available on the O365 Admin portal. In order to take advantage of this functionality, you’ll need to download and import this solution to your CRM organization.

Once the solution is imported, it’s as simple as typing in the entity name that you want to enable Office Groups for, and then also indicate if you want an Office Group automatically created for new records that are created of that entity type.

A new Security Role is provided in the solution that you’ll have to assign out to your users to take part in this new functionality.  This role provides access to create/view the Office Group entities that are provided in the solution.

image

vNext

Currently this functionality is only available on CRM Online and Office Online.  I can see down the road this being applied to CRM On Prem, and Office On Prem so that users could have a hybrid of CRM and Office solutions and still take advantage of this functionality.

Also, the functionality of Office Group emails on the record form are very similar to Yammer.  There may be an opportunity here for the Yammer and Office Group teams to talk and consolidate products.

Finally, the functionality to have people automatically added to the O365 group from the Opportunity Sales Team, would be beneficial to have extended to other entities and not just Opportunities

So when would you use this new Office Group functionality?  When you need widespread collaboration for people that are internal that don’t have access to CRM with those that do have access to CRM

CRM Online Spring Release ‘15 - Theming

Posted by on April 6, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (0)

Theming is a brand new feature coming in the Spring Release ‘15 which has been requested by many organizations for many years now. Themes can be created to change the colors of certain UI elements as well as add a logo to the navigation bar. Multiple themes can be created which is managed through a view in Settings –> Customizations as shown below.

theme grid

When opening a theme record, you will see a variety of options for UI elements as well as the navigation logo and colors. The logo is a Lookup to a web resource image and can have a custom tooltip for when a user hovers over the logo.

Theme form

Below is a custom theme in action with a custom Excel logo. As you can see the navigation bar, grid row selection and even the Command Bar buttons can all be customized.

ribbon theme

Here is what a record form can look like with a custom theme. Header fields and Business Process Flow links can be customized as well.

Process Flow theme

Themes can be built brand new or there is an ability to clone an existing theme and make changes. They can also be previewed before publishing to all users. Unfortunately themes are not solution aware at this time but can be exported and imported into a new environment using native record export / import.

Besides branding your CRM system, theming can also come in handy when trying to distinguish your many different environments from DEV to QA to PROD by creating unique themes for each environment.

Happy Theming!

CRM Online Spring 2015 – USD and Parature KM

Posted by on April 3, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (3)

Microsoft recently announced the CRM Online Spring Release ‘15 and subsequently lifted the NDA around the release and therefore it’s time to start posting about all the great new features coming!

This post will cover the changes coming to Unified Service Desk around Parature Knowledge Management.

USD and Parature KM

First off are the changes that are coming to USD regarding Parature Knowledge Management. 

Users can now perform actions / automations around the Knowledge Base such as Copy Link, Send Email, Link/Unlink KB Article, Browse web pages, etc. within USD sessions.

Also, the KB Search Panel is now independent, and not tied to an entity form.  Previously you could only perform a KB search when on a specific record / form.  The KB Search Panel can be displayed in different layouts / areas of USD (right panel, pop out, etc.).  This provides a much richer experience with multiple applications and session management for the USD Agents.

image

USD Technical Updates

There were also a bunch of technical updates applied to USD and what actions/controls are available for use. 

  • A new type of Hosted Control was added for the KM integration (KM Control)
    • Inbuilt Actions:  Search, SetArticleContext, Associate, Disassociate, SetSearchProps
    • Associated Events:  ResultOpen, SelectionChange, SearchComplete
  • Navigate() action now supports Post-Method for Web applications
  • New Actions:
    • SetVisualProperty (automate visual properties such as height, width, color, and background)
    • CopytoClipboard (allow copy/append text data to the system clipboard)
  • New Panel RightPopUpPanel gives an option to display article previews

USD and Parature KM Setup and Install

To install and setup the new functionality for USD and Parature KM, the Package Deployer can be used to deploy all the components needed for the core User Interface Integration (UII) and USD solutions along with sample data to CRM.

image

Then when in CRM, navigate to Settings –> Service Management –> Setup Knowledge Base Management to setup the record types you want KB management on.  You can also configure your Parature connection details from this location as well.

image

Finally, you need to configure your Parature KM Hosted Control and you should be set to go!

image

CRM Online Spring Release ‘15 – Navigation Enhancements

Posted by on April 1, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (0)

Microsoft recently announced the CRM Online Spring Release ‘15 and subsequently lifted the NDA around the release so we can now blog about all the great new features coming!

This post will cover the feature we’re most excited for in the Spring Release – Navigation enhancements.

New Navigation Bar Shelf

One of the biggest complaints about CRM 2013 / 2015 is that the main navigation was much worse than its predecessors.  Users weren’t able to see many entries at once which required them to scroll horizontally for a long time to find the area of the site map they’re trying to navigate to.  While this was a pain for all users, it was even more painful for those users who had hundreds of sitemap entries, and trust us, we have customers who fall in that camp.  Countless partners and customers started creating their own custom solutions to be able to see more entries at once.

If you’re familiar with the navigation in Dynamics Marketing then you will recognize the new navigation bar that is coming with the Spring Release ‘15. We’re very excited for the new navigation bar as it now provides the ability to see a lot more sub areas on a single screen instead of having to scroll for days if your organization has a lot of entities. Now when you hover over a main tile like Sales, a new shelf will drop down to display a lot more sub sections and links as shown below.

Navigation

MRU

Microsoft is once again listening to the community and adding back features that were in past CRM’s but removed from 2013 (similar to Advanced Find in the global navigation bar). Now Microsoft is adding back the MRU (most recently used) functionality.  An MRU icon was added to the navigation bar to the left of the Quick Create icon that will show you a list of your most recent views and recent records as shown below.

MRU

Pinning

Once inside the MRU pane, you can hover over a recent record and click the pin icon to pin that record to the top of the list so it is always visible and easily accessible.

pinning

Quick Create

The Quick Create pane was also updated to be a consistent look and feel. It now has the same pane as the new navigation and lists the entities in a vertical manner to be able to show more entities on a single screen without having to scroll horizontally.

quick create

Form Navigation

A new icon was added to the right of the record name which displays a list of tabs on the form. Clicking a tab name will navigate directly to that tab on the form. This makes it easier to navigate taller forms.  It’s also a great way to quickly navigate back to a tab of the main form if you’re currently viewing a related Associated Grid of the main record.  Previously in 2013 and 2015, once you navigate to a related Associated Grid, you’d have to go back to the top tab of the form, then scroll down to the tab you’re interested in.

form navigation

As stated earlier, we are super excited for these enhancements as they have been highly requested for awhile! The one downside is you can only get your hands on it this Spring if you are on CRM Online.  On-premise customers will unfortunately have to wait a bit longer until Fall 2015.

Form Record Navigation in CRM 2015

Posted by on March 24, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (0)

If you’re like us at Sonoma Partners, and have upgraded to CRM 2015 already, you’re also getting used to the different UI of 2013/2015 compared to 2011.

I may be one of the odd ones where I enjoyed 2011 opening each link in a separate tab (I changed my IE settings to open in a tab, versus a new window).  This way I could multi-task and have many different tabs for different records that I was working with.

However, in order to get this functionality with CRM 2013/2015, I now resort to right clicking in a list/grid, and selecting “Open in a New Window” and now I’m back to the navigation that I’m used to.

image

However, doing this comes with a price of losing some other functionality.  Another great CRM feature is the previous/next navigation arrows on a record form to navigate quickly between records from the view you came from.

However, if you right click and open your new record in a separate window/tab as I did above, these arrows don’t appear.  If you navigate the way 2015 was built (double clicking a row and having it open in the current window/tab), then these arrows appear.

Just something to be aware of as you choose your own adventure for how to navigate around CRM 2015.

image

image

Convergence 2015 Keynote Recap

Posted by on March 23, 2015 in   |  Microsoft Convergence,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (0)

Microsoft’s Convergence was last week and we’re recovering from a long and exciting week in Atlanta but we wanted to share with the community some of the hot topics being talked about in the Dynamics community.

The focus of this year’s Convergence keynote was how Microsoft empowers people, industries and organizations to achieve more. Satya Nadella and Kirill Tatarinov took the stage separately to talk about how Microsoft technologies work together to help transform businesses and while doing so, they announced a handful of new tools.


Power BI

Power BI is a cloud service that leverages Excel to provide shareable analytics through reports and dashboards. Power BI is now available in the U.S. and more than 140 markets around the world. The following data sources are coming soon – Google Analytics, Microsoft Dynamics Marketing, Zuora, Acumatica and Twilio.

image 

Office Delve

Delve is a new tool which surfaces content from email and social feeds within Office 365. It uses machine learning to highlight information that is relevant based on your work and your colleagues. Delve can surface content from Yammer as well as Exchange Online. It was announced during the keynote that Delve is now globally available.

image

Skype for Business

Lync has been rebranded as Skype for Business and can now leverage all your Skype contacts. It was announced in the keynote that the technical preview starts today. The full version will be available starting in April.

image 

 

Microsoft Dynamics CRM was finally discussed towards the end of the keynote when Julia White came out to unveil the new Spring ‘15 Release.

InsideSales Predictive Intelligence

Julia announced and did a demo of Dynamics CRM integration with InsideSales.com’s Predictive Intelligence which helps sales users determine which lead they should be focused on right now by displaying the Neural Score and Contactability front and center on the Lead form.

image


OneNote Integration

On the Activity Feed for a record there is a new link for OneNote which lists all the related OneNote entries for the current record.

image

When a OneNote entry is clicked on, it navigates right to the note in OneNote Online which can then be edited directly in OneNote. This feature is exciting for us as a lot of CRM users use OneNote as well. It provides a better rich-text experience versus the standard text box that CRM provides with native notes.

image 


Suggested Items

On the product line items for an Opportunity, there is a “Suggestions” link in each row which will display a list of related products so that they can be easily added to the Opportunity as well with a single click. This feature comes in handy for cross selling or when you’re selling a product that has a lot of related accessories.

image

 
Cortana

With a Windows Phone device, Cortana can now be used to open records through voice commands. Julia said the command “CRM open opportunity called Trek 3D printer upgrade” which then proceeded to open the specific opportunity record in the MoCA app for Windows Phone without any hiccups! I’m still skeptical of how well the voice commands will work but it looks very promising based on her demo and I’m excited to see what else can be done with Cortana and CRM in the future.

image 

image

 

Outlook 2016

Julia briefly showed off the new Outlook 2016 and announced the release of IT Professional and Developer Preview of Office 2016. Attaching a file will now display the most recently used documents. There are also new attachment options so you can use a link to OneDrive or the standard inline attachment. The release version of Office 2016 is expected to be available in the second half of this year.

image

 

Surface Hub

Lastly, Julia showed off the new Surface Hub on a 84” HD 4k touch sensor screen with WiFi, speakers, microphones and cameras. It supports two-way integration so the content can be manipulated from either the Surface Hub or individual devices that are connected to the Hub and it looked pretty smooth and slick! The Surface Hub website notes that it is coming later this year.

image

image\

 
Unfortunately we were hoping for some more stage time for Dynamics CRM but the features that were shown from the Spring ‘15 release look very promising. Now that the NDA is lifted on the Spring release, we will be covering the new features over the next few weeks so check back in the near future!

CRM 2015 – Custom Help Content

Posted by on February 13, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM 2015,   |  Microsoft Dynamics CRM Online  |  commentsComments (0)

With CRM 2015 Microsoft added the ability to customize help content on a global level as well as an entity level.  Your content will then be surfaced by clicking the question mark icon at the top right of CRM. 

image

Depending on what entity grid or form you are on, CRM will either take you to the custom help URL specified for that specific entity or if a URL isn’t specified then it will take you to the custom help URL specified at a global level with context information passed in as a parameter.  If a custom help URL isn’t specified at an entity or global level then it will display the native CRM Customer Center.

To setup custom help at a global level:

  • Go to the System Settings in CRM (Settings –> System Settings)
  • On the General tab, scroll down towards the bottom to find “Set custom Help URL”

image

  • Set “Use custom Help for customizable entities” to Yes
  • You can now specify a URL in the “Global custom Help URL” field
    • This URL can also be a relative path to a custom web resource, for example: /WebResources/new_/help/content/global.htm
  • Set “Append parameters to URL” to yes if you would like the following context information to be appended to your custom URL
    • User Language Code: userlcid
    • Entity Name: entity
    • Entry Point: hierarchy chart or form
    • Form id: formid

To setup custom help at an entity level:

  • Navigate to the entity information in the solution
  • Check the “Use custom Help” box

image

  • You can now specify a URL in the “Help URL” field
    • This URL can also be a relative path similar to the global custom help, for example: /WebResources/new_/help/content/account.htm
  • Publish Customizations

Customer Success: For Jones Lang LaSalle, Success Can Be Found in the Cloud

Posted by on February 3, 2015 in   |  Microsoft Dynamics CRM,   |  Microsoft Dynamics CRM Online  |  commentsComments (0)

Sonoma-success-stories3
Jones Lang LaSalle (JLL) is a financial and professional services firm that specializes in commercial real estate services and investment management. With an impressive workforce of 52,700 employees spread across 200 corporate offices worldwide, JLL turned to CRM to improve visibility into the core business of real estate availability. But with their original out of the box solution, sales reps found CRM to be cumbersome and difficult to navigate. Information about real estate availability wasn’t always accurate within CRM and too much information on each screen was a point of confusion for end users. What they needed? A customized global deployment of Microsoft Dynamics CRM.

“If we are going to remain a thought leader in commercial real estate, it’s crucial that we not only have the right data analytics tools, but also have systems that are agile and flexible.”
- Greg Adams, Managing Director of Information Technology for JLL

Today, JLL uses Microsoft Dynamics CRM, SharePoint and Office 365 to get the job done. But for JLL to grow, they needed agility and flexibility - two things the cloud could give them.

The following is an excerpt from the full customer story published by Microsoft:

JLL used Microsoft Dynamics CRM on premise for several years, but is working now to add 3,500 Microsoft Dynamics CRM online seats to their current 2,000, allowing their offices in Asia, EMEA, Australia, the US, and beyond to have access to the same data analytics tools and more seamlessly integrate across continents. They envision their Microsoft Dynamics CRM system as a hub of information for their properties, accounts, and services so their people not only have the right information, anywhere, on any device, but also can be more proactive in their discussions with customers. The company is also planning to move its full Microsoft stack to the cloud, and is considering adding Microsoft Social Listening.

“With a company our size, you have to have customizations around business processes – both for individual offices and across the entire company.” Adams says. “As we look to the future, if it can’t operate in the cloud, we will probably look elsewhere.”

New Call-to-action

 


Contact Us for a Quote, or Personalized Demonstrationof Salesforce.com or Microsoft Dynamics CRM for Your Business.

Contact Us