Hi there.
I have created a sales process using a workflow. It is very basic, containing 5 stages. The sales pipeline report displays these 5 stages no problem.
The issue I have is that I have built in a way for users to restart an opportunity on the sales process. This basically stops the sales workflow, and starts a new instance of it - resetting the sales stgae back to the first stage.
The sales pipeline report now displays the same opportunity twice. Once for the original workflow that was stopped (as cancelled) and again for the new instance that is now running.
Obviously this isn't expected or desired, as I thought the report would only show for workflows that were running.
Even when I deleted the old, cancelled workflow, the report still shows it! So I can't even 'clean up'.
Has anyone created similar functionality into their sales process, and if so, how, and how do your reports work?
We have looked into the database and there is no way of filtering the report based on the status of the workflow, as the status relates only to indivudal jobs for a workflow and not for the workflow instance.
Please rack your brains on this one, you'll feel good im sure...
Dom