All, Here is the dilemma... I'll use Incident Management as an example but really, it affects all modules.
1. The assignee of an incident does some work on the request on week 1. In the work effort, he/she puts in 10 minutes spent. 2. On week 2, the assignee does 20 minutes of work and updates the effort log. 3. The system creates a single record for the assignee when the 1st 10 minutes was submitted in week 1 and creates a record in the Work effort form. 4. For the 2nd week, the system updates that same record and adds 20 minutes and so we have a total of 30 minutes. The problem that our organization is running into is this. 1. We run weekly reports on how much time is spent on requests. 2. For tickets that are opened and closed in the same week, the reports work fine. 3. However, for the scenario mentioned above, it pretty much falls apart. 4. Week 1 shows that the assignee did 10 minutes of work on this incident. 5. Week 2 shows that assignee did 30 minutes of work for this incident when really, it was just 20. (This is the problem). Has anyone else dealt with something like this? What I was thinking as a possible solution is to piggy back off of the OOB workflow and do the following: 1. Create a custom form that can be used to collect work effort info about all the modules in this 1 form. 2. Build workflow that creates a record in the custom form much like the work effort forms and updates the record only for a given week. Once the next week starts and someone updates work effort for an older incident, a new record is created on this form and the process continues. Any other ideas would be helpful. Thanks and Happy Thanksgiving for those who are observing in the States! Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Informatics-Infrastructure Office: 631.858.7765 Mobile:646.483.2779 ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
