Deadline Calculation: solution that worked in sp13 but not in SD 5.0
Following solution worked perfectly fine with SP 13 but I am not able to use it in SD 5.0.
For Deadline calculation, we normally try to use addition of max duration with deadline.However there is no such diract method to add max duration with deadline. We can use "Planned Completion Time" and "Planned Start" fields which are by default available and they are automatically calculated obeying the bussiness hours.
Before starting, let's take "Waiting for User" as pending status.
To use these fields, try to create following DB or UI rules:
1) Rule 1:
when call is created or modified, if status equals "Waiting for User" then Planned start = Current Time.
2) Rule 2:
when call is created or modified, if status NOT equals "Waiting for User" then :
Planned Completion Date = Current Time (Explanation: Due to this, Planned Duration is set to the difference between system time when Planned Start was set (from rule 1) and system time when Planned Finish was set.ie. the time in pending.)
Planned Start= Deadline (Explanation: Now Planned Completion Date becomes equal to Planned Start + Planned Duration(pending Time))
Deadline = Planned Completion Date (Explanation: The Deadline is now extended by the elapsed time in pending status, taking into account business hours.Max Duration is automatically extended to accomodate the new value for Deadline.)
Can anyone suggest where I am wrong? I am getting an error that planned start can not be greater than planned finish.
Re: Deadline Calculation: solution that worked in sp13 but not in SD 5.0
Thanks guys for replies..
Ruth: I think your solution should work. But I have one doubt. Suppose I set planned finish = deadline+2 yrs then my duration field will also get extended to 2 more yrs. Then when I will set planned start and deadline then vll my deadline also extend by 2 more yrs? right? then shall I delete 2 yrs from the deadline again?
Mike: I tried you concept also but I forgot one thing that if I will make planned finish as empty then my planned duration will also become empty..