CRM Blog

September 2007 - Posts

Leverage the Power of Windows Workflow Foundation with Microsoft Dynamics CRM 3.0
by Jeremy Hofmann 09.24.07

Comments    1 Comment(s)

Jeremy Hofmann
Crowe Chizek and Company LLC
September 24th, 2007
http://www.crowecrm.com 

Summary: Jeremy Hofmann writes an article on leveraging Windows Workflow Foundation from CRM 3.0.

Introduction: As Microsoft Dynamics continues to gear up its workflow offering, now is the time to start ramping up your company’s strategy for integrating real-time workflow into your Microsoft Dynamics CRM 3.0 solution. 

The Microsoft® .NET Framework 3.0 platform contains the Windows Workflow Foundation (WF), which enables you to build sequential and state-driven workflow capabilities into your existing applications. Along with the Microsoft CRM 3.0 Software Development Kit (SDK), this means you can begin to leverage this robust platform now. This will give you a head start on future releases of products in the Microsoft Dynamics line. 

This article will show you how to build a WF sequential workflow to retrieve the next available salesperson and then automatically assign an incoming lead to that salesperson.

Find the rest of the article at http://folio.crowechizek.com/files/PDF/PERF7708_CRM3_Workflow.pdf

Jeremy Hofmann is a Manager and CRM specialist at Crowe Chizek. 

Filed under: ,
Moving CRM SQL Reporting Services Reports from one Environment to Another
by Zahara Hirani 09.20.07

Comments    No Comments

Zahara Hirani, MCAD
Crowe Chizek and Company LLC
September 20th, 2007

http://www.crowecrm.com

Summary: Zahara shows the steps needed to move CRM SQL Reporting Services reports from one CRM Environment to another CRM Environment.

Moving Reports from one Environment to Another

 

1. In Internet Explorer, navigate to the Report Manager for the first environment (e.g.: http://servername/reports)

2. Select the folder which contains the report.

 

 

 

  Z_image_0912_1_4

 

 

 

3. This should display a list of reports in the folder.

 

  Z_image_0912_2_3

 

 

 

4. Navigate to the report to move, and click on it.

5. In the Properties Tab, select the General from the left navigation menu.  Z_image_0912_3_3

 

 

 

6. In the Report Definition section, Click on Edit

7. This should give you a pop up window to save the report(.rdl) file.

  Z_image_0912_4_3

 

 

 

8. Click the Save button to save the report to the desired location.

9. In Internet Explorer, navigate to the Report Manager of the second environment (e.g.: http://servername/reports).

10. Select the folder which where the report needs to go.

11. This should display a list of reports in the folder.

12. From the Top navigation menu, Select Upload File.

 

  Z_image_0912_5_3

 

 

 

13. Click Browse and navigate to the report saved from environment1.

      Z_image_0912_6_3

 

 

14. Update the name of the report.

15. Select Ok to upload the report.

16. Once the report has been uploaded, Navigate to the new report, and click on it.

17. In the Properties Tab, select the Data Sources from the left navigation menu

18. Click the Browse button to select a Shared Data Source.

19. Navigate to the CRM Data Source.

a. This should be located under the folder that contains the reports (e.g. Crowe_Chizek_MSCRM)

b. The Data Source will be named MSCRM_DataSource

20. Select the CRM Data Source.

21. Click Ok.

22. Click Apply on the bottom of the screen.

23. Click the View Tab from the top navigation menu.

24. The report parameters to select should display for the report to run correctly.

Zahara Hirani, MCAD is a Microsoft CRM developer at Crowe Chizek (www.crowecrm.com) Zahara currently focuses on .NET / SQL / SRS development on the Microsoft Dynamics CRM 3.0 platform.

Filed under:
Understanding Contract Statuses
by Cullen Hunter 09.03.07

Comments    No Comments

 

Cullen Hunter
Crowe Chizek and Company LLC
http://www.crowecrm.com 

Summary: Cullen Hunter explains the sometimes confusing contract statuses.

The Microsoft CRM 3.0 contracts functionality allows you to track contracts through the entire contract lifecycle. The system does this by assigning a “Status” to a contract. It is easiest to think about contract statuses by breaking them up into three categories:

1) Contracts that are created, but have not been submitted for activation

2) Contracts that have been activated

3) Contracts that have been cancelled or put on hold

The first group, Contracts that have been created, but are not yet submitted for activation are referred to in the system as “Draft” contracts and can be defined by the following:

Draft: A Contract will be in Draft status if it has been created, but has not been submitted or activated. Contracts in the Draft status are the only contracts that can be edited in the system. Once submitted, the contract cannot be changed back to a Draft status for editing, so make sure it is accurate before continuing through the process! Contracts in a Draft status cannot be chosen from a Case because they are not considered active contracts.

A Draft contract is simply one that has been entered, but is not ready to be activated. When ready, a contract is activated by “Invoicing” the Contract by choosing “Actions-Invoice Contract” from the file menu. (It should be noted that Microsoft CRM 3.0 does not actually invoice the Contract; it merely changes the status of the Contract. Your company could write an integration to your operational system or could create a report to actually invoice the contract if required.)

The sometimes confusing part comes in understanding what happens to the contract status after the contract has been activated or “Invoiced” as defined above. Many would expect that the status of the contract should be “Invoiced” (which is an available status). But, the actual status is determined by the Contract Start and Expiration Dates. The system automatically determines the status of the contract based on these dates. Statuses for invoiced contracts include:

Active: A contract with an “Active” status is one that has been “Invoiced” and the current system date is between the Contract Start Date and the Contract Expiration Date. Active contracts are the only status which will show in the Case lookups.

Invoiced: A contract with an “Invoiced” status is one that has been “Invoiced” and the Contract Start Date is in the future. This status indicates the Contract has been invoiced, but is not yet active because the start date of the contract has not arrived. This will happen most often when renewing a contract. The current contract remains active until its expiration date, at which time the renewal Contract will become active and the current contract will expire (see below). Invoiced contracts will not show in Case lookups because they have not yet reached their activation window.

Expired: A contract with an “Expired” status is one that has been invoiced and the Contract Expiration Date has passed. Expired contracts will not show in the Case lookups as you would expect.

The good news is that the Microsoft Dynamics CRM 3.0 system will take care of changing the contract status for you. You do not need to manage whether a contract is about to expire or whether it is about to become active. 

The final statuses available for a contract allow you to either put a contract on hold, or to cancel the contract in the case where you need to end a relationship or to change the contract details. In both of these cases, the contracts will not be available within Case lookups. The final statuses include:

Cancelled: A “Cancelled” contract is what you would expect. It is a contract that has been manually cancelled. 

On Hold: “On Hold” contracts are ones that are temporarily held – this could be for payment or other issues.

It is important to remember that once invoiced (Active, Invoiced, Expired, Cancelled or On-Hold), a contract cannot be modified or reopened. The only way to change the contract details is to cancel the contract and create a new one (or to potentially renew the contract). The good news is that a “Copy Contract” feature exists to help with this. 

People often want to know why the system works this way. Think of contracts as revision controlled legal documents. Once a contract is entered into, it cannot be changed. To change the agreement or binding contract, the initial contract needs to be cancelled and a new contract must be initiated and agreed to. This gives you full revision control and contact history.

 

 

Cullen Hunter, is a CRM Executive at Crowe Chizek (www.crowecrm.com). Cullen currently focuses on CRM Strategy, Business Process Improvement, CRM Tool Selection, and System Implementation including the Microsoft Dynamics CRM 3.0 platform.