CRM 4.0 Pipeline Report and the Sales Process

What I found out is that the Sales Stages that show up on the pipeline report are the description from each stage in a multistage opportunity workflow (sales process) and are only created from the sales process.  If your opportunity has not been driven by a multistage workflow, the sale stage will always be unspecified in the pipeline report.  It doesn’t matter what you put into the Pipeline Phase field of the opportunity because that has nothing to do with the Sales Pipeline report, and it just used to display in the bottom right-hand of the opportunity form.

Here’s an example of my test sales process (note the names used to describe stage one and stage two in the sales process):

WindowsLiveWriterCRM41

Here is the corresponding Pipeline report. Notice the “Test Sales Process” at the top & stage names at the bottom.

 WindowsLiveWriterCRM43

There are several attributes in the Opportunity entity  that appear to be related to this:

  • stepname (Pipeline phase): Displayed in bottom right corner of opportunity Form
  • salesstagecode (Process code):Picklist out-of-the-box with only one value – “Default value” I’m not sure where this is actually used.
  • stepid (Step): This attribute of type uniqueidentifier is entitled “unique identifier of the step in the sales process”. You can’t access it in a view, nor can you add it to the form, but I believe that this is the data attribute used by the sales pipeline form. I haven’t had a chance to look into the pipeline report to see if this is actually what it does but if somebody wants to let me know about that I would certainly be grateful.

I hope that clarifies things for you.

Have a great day,

Stephen Noe

Advertisements

About stephenvnoe

CRM & XRM solution architect and project lead. I provide CRM design, services, mentoring & support to all manner of front office solutions and CRM projects.
This entry was posted in CRM, CRM 4.0, Customization and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s