Browse By Tags

  • Escalation E-mail / Template Sending Merged Documents

    Good day, all. We have a requirement to have a document of a specific type that was merged / uploaded against a custom entity, to be sent to the linked customer record using an escalation e-mail. We have previously developed an application that can…
  • Creating a followup opportunity in the workflow leads to the new opportunity ending up in a wrong workflow state

    Hi there, we want our employees to create a followup opportunity whenever they lose or win an opportunity so that they can work on it again in a year or so when the opportunity presents itself again. To do this we integrated the task of creating a new…
  • Email notification on created case.

    Problem details How do I set up an escalation rule in CRM so that once a case is logged in CRM, an email is sent to the client and the assigned consultant? Solution Add an email workflow action on the primary workflow rule to email the required…
  • Creating an Escalation Rule on ANY Table in CRM

    I wanted to share something with you that I learned this week. Being on the integrations team I spend lots of time working on customisations that help our integration partners to deliver really great out of the box integrations with their own products…
  • TableLevel Scripts and SQL TimeOuts

    Any SQL statement may take time to run and result in a timeout error. In Sage CRM the general timeout period is controlled within the Administration -> System -> Database screen by setting the Query Timeout field value. This is expressed in seconds and…
  • Using Quick Notifications to alert users of reassigned records

    The links in this article were corrected 22nd May 2009. Oh how angry I get with myself sometimes. I am a very stupid person. Someone sends me an email entitled 'a quick question' and in my idiocy I start trying to answer the question and look up nearly…
  • The Data Structure for a Notification

    A simple Notification can be of two types OnScreen Notification Email Notification Both types of Notification can be seen in the WorkflowRules table. E.g. select * from workflowrules where wkrl_ruletype = 'time' and wkrl_deleted is null OnScreen…
  • Date and Times in Escalation Rules

    I have discussed in a previous article the structure and purpose of the SQL clause of an Escalation rule. e.g. (quot_IsQuote is not null) AND UPPER(RTRIM(quot_Status))=UPPER(RTRIM(N'Active')) AND (Escl_DateTime<#T And Escl_UserID=#U) We know that…
  • Using ASP Pages in Workflow

    Sage CRM has a very powerful internal workflow engine. A workflow may control the processing of data from the initial insertion of the record through to its final state. The user-driven aspect of a workflow is created from a mixture of workflow rules…
  • #Code Usage

    The #Codes are a set of codes that indicate to CRM as the dll parses the Meta data it should substitute these references with internal function calls. These are for use where SQL is used directly as the control mechanism to limit the data returned. #U…
  • Scripting Escalation Rules in a Component

    I found this a very interesting issue. If you have created an escalation rule outside a workflow you will not be able to find a place where the component manager script can be generated. So how or where can you get the script of an escalation rule that…
  • How to use Escalation Rules to Email a Case Progress Tracking Note

    We are currently using CRM 2017 R3 and I have multiple escalation rules that will send emails from a case. What I am looking to do is that when a tracking note is entered from a specific action button an email is set to the assigned user in the case…
  • Escalation Rules Not triggering

    Hello, I'm having trouble getting an escalation rule to trigger in crm. I am currently on version 7.3. I have an escalation rule configured to notify someone when they have been assigned a task within CRM. However it does not seem to be sending out…
  • Escalation Rules on Orders

    Version: Sage CRM 7.3 SP1.2 I have been tasked with sending an email to a customer a certain number of days after they place an order. However, when creating a new Escalation Rule, the Orders Entity is not available to select in the table dropdown.…
  • Notifiy interval less than 5 minutes : possible or not possible ?

    Hi, After a few tries and a call to my local support, it appears that I can't set the Notify interval to a value less than 300 sec (5 minutes). I am using Escalation service and I want some notifications to be sent 2 minutes max after the trigger…
  • Escalation rules within context of Workflow

    Do these rules auto filter to items at that state in workflow? Forexample, I want an escalation rule to auto advance items to the next workflow state if condition is met. However, once condition is met, it will always be met. So before I create control…
  • Problem with escalation Rules

    Hi all, I've been having an absolute nightmare trying to set up escalation rules relating to opportunities. It is not an escalation within a workflow, but a standalone. My SQL Trigger Clause is: (oppo_closeby <= #T) AND Upper(RTRIM(oppo_status))=N…
  • Escalation rules in version 6.2 i

    Hi, I created simple escalation rule to send mail to fixed mail id at every 30 minutes. I already created escalation rule for same in version 7.1 and it's working as expected. I followed same procedure to create in 6.2 but not working as expected. When…
  • alignment from left to right?????

    Dears, How can i make sage crm alignment from left to right permanent coz when i convert it to left to right alignment when i logged it auto convert from right to left IE 9 :/
  • how to add the asp file in Escalation Customization

    How add the Escalation Customization to add the asp file and how it's works