December 2007 - Posts
One problem I had recently was to find all the documents that existed in the CRM system that were on the notes. The solution to the problem was to use an Advanced Find to solve the problem. To achieve the results I've used Dynamics CRM 4 but this will work with Dynamics CRM 3 as well. The reason I had to do this was that CRM isn't really the best for storing a large amount of documents. For that Microsoft SharePoint Services (WSS) or Microsoft Office SharePoint Server (MOSS) is better suited to do.
- Start your web browser and navigate to your CRM website
- Click on the Advanced Find button
- On "Look for" change the entity to Notes
- Choose "File Name" from the criteria and set the search value to "Contains Data"

- Next (this is a Dynamics CRM 4 feature) I clicked on Edit Columns and added "Account Name (regarding)" so that I can see the account the record is tied to. Now for this query I was only wanting the account name but didn't want to filter on just the account name so that if the item was in an Opportunity I could also see the account the document belonged to.
- Next I clicked the Find button to see my information and was happy to see the documents that are in the system with the account name listed.

One item of great interest is that of Tasks. Before phone call type activities set for future dates wouldn't appear in Outlook. This was due to Outlook not having a task that was specific to a phone call.
Here I'm within the web client and choose to Insert a phone call activity.
Next I setup the phone call with a future date and the basic information that I needed.
The last item was to load the Outlook client and wait for synchronization to complete and opened the task from the Outlook 2007 task pane.
As you can see you have the same information as what you have in the web browser client and at the top of the screen that the call is from "[CRM] Phone call regarding: ". This is a huge benefit as you know will be able to use the Outlook client for a lot more functionality.
I've had five clients that have Dynamics CRM 3 installed and have wanted to not only turn-off the Form Assistant but they want to control it on a form by form basis. There were ways unsupported or via JScript that could handle this for 2003 but wasn't really part of the core product. Well, with Dynamics CRM 4 all of this has changed. To change for any entity, including custom entities do the following (note: you must have System Customizer rights or higher to do this):
- Start your web browser and navigate to the CRM server and log onto the system with a user with sufficient rights
- Settings
- Customization
- Customize Entities
- Double-click on the form you wish to turn on/off the Form Assistant
- The Form Assistant is enabled by default
- The Form Assistant is not expanded by default
- Click on "Forms and Views"
- Double-click on Form
- Double-click on "Form Properties"
- Turn on/off the features you want

- OK
- Save and Close
- Click on Actions on the Actions menu
- Choose Publish to publish the changes to the system
- Save and Close
You'll notice the parts I left out from above is first making a backup of your customizations and then doing a test/preview to verify that the changes have happened to the way you want them to be.
One of, if not the biggest complaint of the Outlook client for Dynamics CRM is that the Outlook client has "issues". The great thing about Dynamics CRM 4 is it allows you to repair without the help of your IT department and can be done with a standard user account. To achieve this you would do the following steps:
- Start
- Programs
- Microsoft Dynamics CRM 4.0
- Choose "Diagnostics" from the menu
- Click "Run Diagnostics"

- At the conclusion of the diagnostics you will be informed of any problems that may have been found.

- If you have any errors you can click "Fix All" to repair the errors.
- Click Close to close the diagnostics Window.
You'll notice that there were two items that couldn't be repaired.
- The first that I need 1 gig of memory on my system. In this case it's a virtual PC and I only allocated 768Meg of space but if this was my desktop or laptop I would purchase more memory to get a minimum of one gift of memory and preferably 2Gig of memory.
- The second being that I have synching of a LOT of information between my Outlook client and the CRM system. By reducing the items I'm synching to the items that I need to sync the diagnostics are informing me that I would be improving the overall functionality and speed of my Outlook client which would be a good thing to do to eliminate the sluggish performance I was experiencing.
One common item that comes up on new SharePoint installations is that the documents for many applications open in the browser window instead of opening within the application itself. This works but you don't always have the full functionality of the application you're trying to run. To get SharePoint to open in a new window when a document is clicked we have two types of applications to think about. The first being the type that integrates in with Windows and the other that handles the settings within the application itself. As an application of each Microsoft Office (Excel, Word, and PowerPoint) utilize Windows for the connection method and Adobe Acrobat Reader uses configuration settings within it's application.I will outline the process for both application types and will use Adobe Acrobat Reader as the same for the application settings that will typically be found in most organizations. The applications that handle this themselves will each have a browser add-in installed as well to catch the file type prior to Microsoft Windows from opening the file type.
Windows
- Load Microsoft Windows Explorer (start | run | explorer.exe | click on OK)
- Click on the Tools menu
- Click on Folder Options...
- Select the File Types tab
- Highlight the file extension you want to edit (for Microsoft Word it would be .doc and .docx)
- Click on Advanced
- You will want to Browse in same window to be unchecked.
- Note: Some also like to uncheck Confirm open after download as this eliminates a screen prompt for end users.

- OK
- Repeat steps 4 through 8 as necessary for each file type you wish to have open within a new window.
- OK
- Close Windows Explorer
Now when you open the document that matches this extension it should open in a new window. If it doesn't there's a good chance this functionality is handled within the application.
Application
- Start
- Programs (All Programs)
- Click on the Adobe Acrobat Reader link
- Click on the Edit menu
- Click on the Preferences... menu choice
- Scroll down to where it says Internet
- Uncheck Display PDF in browser

- OK
- Exit Adobe Acrobat Reader
- Finally close all your open Microsoft Internet Explorer windows ass the change won't take affect until Microsoft Internet Explorer is restarted.
One key addition with Microsoft Dynamics CRM 4 (aka Titan) is the ability to do views. Unlike previous versions though you can display related entities as well in the view. This allows you to show one entity like Opportunities and in the view show a phone number of the associated Account/Contact.