marksadmin No Comments

MSCRM – CRM for Outlook & Firewalls

A client recently came to me with a problem where they could not login to MS Dynamics CRM via Outlook. I discovered that they had a network firewall enabled so I went about researching which ports are used by CRM for Outlook. This TechNet article shows that port 80 is used for HTTP and port 443 for HTTPS. I went back to my client with this information but it turns out that they don’t block either of those ports. We learned that the problem is only with the initial login so they temporarily disabled the firewall and was able to login. Once the firewall was enabled again, it was still working.

marksadmin No Comments

MSCRM – Change Biz Process on Existing Opportunities

If you create a new business process for your opportunities in CRM, the records that already exist do not update automatically. It may appear that you have to update each individual record to use the new process but there is a way to do this in bulk. Once you have your new process set up and your old process deactivated, you’ll start seeing a message like this on your existing opportunities. This is a good reminder that you need to switch the business process. 

If you have several opportunities to update, you can do it all at once using a simple view. Create a view of opportunities that includes the field Process.

Make sure the results include at least one opportunity that is using the new process. This way, you’ll be able to clearly see the ID for the new process vs. the old.

Next, you’ll want to export the results to Excel or edit directly in Excel Online. Copy the ID of the new process over the ID of the old process.

In Excel Online before changing the Process ID:

In Excel Online after changing the Process ID:

Then import your changes and all of the opportunities will now be using the new process!

marksadmin No Comments

MSCRM – Recurring Tasks

Do you have specific tasks that you do on a regular basis and would like to automate their creation? MSCRM doesn’t have the capability to do this out-of-the-box but with a few new fields and a simple workflow, you can do it yourself.

The only field that you need to create is an option set for the recurrence frequency. I called the field “Recurrence” and the options available are None, Weekly, Monthly, Quarterly. I’ll review the workflow April’s Tips & Tricks Google Hangout so make sure you join us!

7