Auto – complete tasks of a closed opportunity in Sage CRM

By | June 8, 2020

As we all know, Sage CRM’s Communications entity has not only helped to manage communication with the Customers but also internally within the application users. Another important feature is the ability to link these communications of any type i.e. Task, Appointments, or Email to the respective Sales or Service record of the Customer. This has been of great help to track the progress of the records with ease. But when these transactional records are marked as completed in CRM, what happens with their respective Communication records? Yes, they are still under pending stage.

New Post: Changing Sage CRM Default log on page for Mobile view

Consider an example where you have a Sales opportunity against a Customer. After sending the proposal to the customer, your salesperson has created a reminder task in CRM against the opportunity to follow up with the Customer after 2 days for the proposal sent. However, the customer gets back to you the very next day and the opportunity is progressed further or even marked as completed in CRM. Now, what happens with the Task (Communication)? It will still be under the Pending stage and has to be manually updated by the sales representative. Isn’t it a bit of time-consuming?

To avoid manual efforts, you can easily mark such kind of communication records as auto-complete along with the Opportunity record completion with the help of SQL condition on the specific opportunity workflow rule.

Below are the steps to follow –

  1. Navigate to Administration -> Advanced Customization -> Workflow
  2. Open Opportunity Workflow and click on the Edit Workflow button.
  3. Click to open Closed Rule’s condition/actions.
  4. Click New from the Workflow Actions section and select Execute SQL Statement.
  5. Put the SQL condition as shown in the below screenshot, save and activate the workflow.
SQL Condition on Opportunity workflow
SQL Condition on Opportunity workflow

Now, whenever your sales representative will mark an opportunity as closed; all the pending communications against it will also be auto-marked as completed.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service SignatureSage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at We will be glad to assist you.