Extending the Favourites Facility in Sage CRM

By | October 23, 2019

You all must be aware of the Favourites feature provided in Sage CRM that is used to bookmark the records in CRM, just like we do in Chrome, IE or any other browsers. Marking the records as Favourites helps to keep the records handy, thereby allowing to access the records on the go. However, there is one slight shortcoming of Favourites list related to Opportunity entity i.e. it only displays the Description of the Opportunity record in the list.

New Stuff: Adding a Pipeline graphic to List using .Net API in Sage CRM

Just by looking at the Description of the Opportunity, it used to be very difficult to identify or recollect what product or which company this record belongs to. When multiple opportunities are created for a single product it became even more difficult to locate the one you are looking for.

Standard view of Favourites list
Standard view of Favourites list

To overcome this disadvantage, one of our Client requested to concatenate and display Customer Name as well as the opportunity description in the Favourites list. In order to achieve this, we first focused on fetching the Company Name from the Opportunity table only rather than pulling it from Company table at the database level. To do the same, follow below steps –

  1. Create a new field in Opportunity entity say, ‘Oppo_Compname‘.
  2. Create/Execute a Trigger at Database level as below –

<Snippet>

CREATE TRIGGER tOpportunity ON Opportunity
AFTER INSERT
AS
BEGIN
DECLARE @CompName NVARCHAR(100)
DECLARE @CompID INT
DECLARE @OppoID INT
SELECT @CompID=Oppo_PrimaryCompanyId,@OppoID=Oppo_OpportunityId FROM inserted
IF(ISNULL(@CompID,0)!=0)
BEGIN
SELECT @CompName=Comp_Name FROM Company(NOLOCK) WHERE Comp_Deleted IS NULL AND Comp_CompanyId=@CompID
UPDATE Opportunity SET Oppo_Compname=@CompName WHERE Oppo_OpportunityId=@OppoID
END
END

</Snippet>

  1. Next step is to determine what needs to be displayed in the Favourites list. For this you need to configure/update the changes in the Bord_RecDescriptor column in Custom_tables for the respective entity.
  2. Since by default, Opportunity entity has #oppo_description# set against it in Custom_tables. In order to extend it to use other fields, we need to update the same under Bord_RecDescriptor column with no comma between them like – # Oppo_Compname# : #oppo_description#
  3. Restart the Tomcat service.

Favourites lists view will be modified for Opportunity entity as shown below.

Favourites list after applying the modifications
Favourites list after applying the modifications

In this way, you can modify the Favourites list view for any other entity. However, these changes will be reflected for all the Users of Sage CRM.

About Us

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

Greytrix has some unique integration solutions for Sage CRM with Sage ERPs Sage X3 (Sage Enterprise Management)Sage Intacct, Sage 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 migrating of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature and Sage CRM CTI Framework.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace.

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