Skip to main content
Answer

How to automate Opportunity stage changes

  • October 25, 2022
  • 3 replies
  • 313 views

Forum|alt.badge.img

We would like to move the opportunity stage to a “stale” stage if the customer hasn’t responded in 30 days.  I was thinking that a Business Event would be the best way to do it, but I am unsure how to take the estimated close date, add 30 days to it and then have the business event change the opportunity status from proof to stale.  Has anyone done this yet?

Best answer by BenjaminCrisman

Hi @mcoman! I think for this issue you’ll need to use a Business Event to trigger an import scenario to update the field you need.

I would make sure that the Import successfully updates the field, then build a GI which uses the necessary field date and set a condition that the date on the opportunity is greater than or equal to Today() -30.

Have the Business Event trigger on record insertion and then it should work as expected

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • Answer
  • October 25, 2022

Hi @mcoman! I think for this issue you’ll need to use a Business Event to trigger an import scenario to update the field you need.

I would make sure that the Import successfully updates the field, then build a GI which uses the necessary field date and set a condition that the date on the opportunity is greater than or equal to Today() -30.

Have the Business Event trigger on record insertion and then it should work as expected


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @mcoman 

Could you please create a UDF field- Customer Lack of response and add it to the opportunity screen.

As soon as the user enables the checkbox then Implement the Business event ( Import scenario ) to update the status of the Opportunities as you required.

Thanks


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • October 25, 2022

Thanks!  I will give the solutions a try