Opportunity Duration in Opportunity progress table

Posted By Sulfath Shajahan over 3 years ago

Hi,

I have few custom pages in opportunity workflow. The data is added to the opportunity progress table whenever the opportunity data is updated. Everything works fine except Opportunity duration. How can I insert value to opportunity duration. I am know it is a system calculated field based on business calendar defined. How to get the calculation used so that I can insert to opportunity progress table whenever a custom page is updated?

Is there any field in CRM that store the duration field? Or how can I calculate the duration time?

Any Help?

Parents

Erzsi_I over 3 years ago

Hi Sulfath Shajahan,

Thanks for reaching out. Did you ever find a resolution to this issue? If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps.

Warm Regards,
Erzsi
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Erzsi_I over 3 years ago

Hi Sulfath Shajahan,

Thanks for reaching out. Did you ever find a resolution to this issue? If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps.

Warm Regards,
Erzsi
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Sulfath Shajahan over 3 years ago in reply to Erzsi_I

Hi Erzsi_I,

Yes. I managed to write one store procedure which calculates the time taken in each stage based on the business calendar. It works pretty well as expected.

I will be glad to know if any other way or directions you can give or an alternative way of doing the same
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage CRM

Opportunity Duration in Opportunity progress table

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING