Author Archives: greysagecrm

Retrieve Primary Keys in TLS

Table Level Scripts (TLS) are an alternative method of creating SQL triggers that can be performed in Sage CRM system. Table Level Script (TLS) are used to perform various operations after inserting records, updating or deleting records in Sage CRM. To perform operations, it is necessary to fetch the primary ID of the current entity in… Read More »

Export to Excel and Export to PDF functionality on Sage CRM Self Service lists

Sage CRM Self Service allows customers to access information or request services and support over the Web whenever they want. Customers can directly receive information based on their preferences, requests, and history through self- service portal. Read our other Self-service offerings at the end of this post. Sage CRM user can export data into Excel/PDF/CSV… Read More »

Creating Order with existing Opportunity in GUMU Integration

Opportunity tracks leads from first contact to final closure, so that time and resources are ensured to be directed towards the most winnable deals. An opportunity is any potential sale, from a Lead to a Closed Sale. Opportunity Management also ensures the following: Leads are handled by the most qualified sales representatives Automate follow-up activities… Read More »

Change Default dedupe behaviour

In Sage CRM, we have Match Rules defined for Company to restrict users from entering duplicate company records. Basically it is defined on Company Name field. Please refer below screenshot. The New Stuff: Migrate communications from Goldmine to Sage CRM Suppose we want to add another field for e.g. “Company Registration” for Company dedupe then… Read More »

Create Document Template in Sage CRM 7.1 SP2 and SageCRM 7.2

Document merge has been one of the essential features of Sage CRM. We can generate Letters, Quotations on the fly on predefined word templates. The question is how you can create and use the merge templates. I remember I had discussed the old way of doing it by using the Local Document feature in old… Read More »