Sage CRM 2017: Company Workflow Example

Hints, Tips and Tricks

Technical Hints Tips and Tricks that cover customization and development using Sage CRM. API usage and coding are covered.

Sage CRM 2017: Company Workflow Example

  • Comments 6
  • Likes
You can define a workflow for the Company entity.  Creating a company workflows is different from creating a new workflow for the opportunity or case entity.  The entities, Leads, Cases, Opportunities and Solutions all work in a similar way.  They have a progress table associated with them and they assume that you may want to control the full creation of the new record. 

But tables like Company and Person have initial inbuilt behaviour that is far more complex.  When you insert a company you will also be creating a person, an address record, phone and email details.  This means that our workflow will start once the record has been inserted into the system.  The custom company workflow will need to start with a Transitional Rule. This makes sense when you consider that many company records will be automatically inserted into Sage CRM because of the integration between it and Sage BMS products like Sage 100cloud or Sage 300cloud.

A new version of an example company workflow has been added to the download section of the partner community.  You can find it in the Example Components & Developer Resources folder. 

It gives examples of the following business rules and techniques:

1) Changes to comp_slaid will be recorded as a note record.
2) Changes to the comp_slaid can only be made once a communication is recorded that the SLA has been agreed with the customer.
3) Changes to comp_type comp_status and comp_primaryuserid will also be recorded as a note record.
4) Automatic creation of a task.
5) Use of JavaScript condition to determine whether workflow actions should be available.
6) Use of the workflow action type 'Execute SQL Statement' to insert record in notes table.
7) JavaScript condition that links activity on a task to the company workflow.

  • Can I use this same download for Release 7.1C?

  • Renee

    Do you have Developer rights?  I think you should be able to see this version of the component for 7.1.

  • ohhh, I can not download the component. it says that resource is not available.

  • Send me an email and I will reply with the component.

  • Hi Jeff

    This is my email

    I would be grateful if u send me the component.

    thanks in advance

  • Thanks for your information :)