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.
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.
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 –
- Create a new field in Opportunity entity say, ‘Oppo_Compname‘.
- Create/Execute a Trigger at Database level as below –
CREATE TRIGGER tOpportunity ON Opportunity
DECLARE @CompName NVARCHAR(100)
DECLARE @CompID INT
DECLARE @OppoID INT
SELECT @CompID=Oppo_PrimaryCompanyId,@OppoID=Oppo_OpportunityId FROM inserted
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
- 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.
- 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#
- Restart the Tomcat service.
Favourites lists view will be modified for Opportunity entity as shown below.
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.
Greytrix – a globally recognized and one of the oldest Sage Development Partner 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 X3, Sage Intacct, Sage 100, Sage 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 migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like 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 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 processing and execution of application programs at the click of a button.
For more information on our integration solutions, please contact us at firstname.lastname@example.org. We will be glad to assist you.