SalesLogix Opportunity Naming Conventions

week I received a question regarding the Description that is used by
Opportunities. In the Opportunities Defaults options, it states that
you can customize this option by “contacting your Administrator”. This
option can only be customized via scripting, not via a SalesLogix
dialog box.

If you open Architect, go to Manage/Plugins. You will need to open the “Insert Opportunity” plugin.

On the Insert Opportunity Plugin, Script Tab, you can go to the Procedure called “SampleDescription”

This script will pull the Account Name from the Account Name on the Opportunity Screen,  then
adds the Text “-phase” , then counts the existing opportunities for
this accounts and adds 1. This is the description that is then put in
the Opportunity Description field.

Note: Always use a Test Database

The Sample Description procedure is as follows:

Function SampleDescription()

    Dim strAccountName, strUserDefined, strOppCount, strAccountID, strSQL
    Dim objRS

    On Error resume Next

       Set objRS = objSLXDB.GetNewRecordSet
       strSQL = “Select ACCOUNTID from ACCOUNT where ACCOUNT = ‘” & lveAccount.Text & “‘”  ‘DNL
       objRS.Open strSQL, objSLXDB.Connection
       strAccountID = objRS.Fields(“ACCOUNTID”).Value  ‘DNL

       Set objRS = objSLXDB.GetNewRecordSet
       strSQL = “Select Count(*) From OPPORTUNITY Where ACCOUNTID = ‘” & strAccountID & “‘”  ‘DNL
       objRS.Open strSQL, objSLXDB.Connection 

       strAccountName = lveAccount.Text
       strUserDefined = Application.Translator.Localize(“-Phase”)
       strOppCount = objRS.Fields(0).Value + 1

       Set objRS = Nothing 

       SampleDescription = strAccountName & strUserDefined & strOppCount



Dale Richter

Director of Training- I have worked with Customer FX since 1997

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!