Tag Archives: Case

Identity increment in CRM tables

Primary keys in SQL tables allow us to uniquely identify the rows. These keys also allow us to establish the relationship between tables based on foreign key-primary key concept. Though we can have different id field names in CRM tables, the standard primary key feature is well maintained with field names like “_” (e.g. Case_CaseId).… Read More »

Data Import Routines

Though CRM systems are capable of maintaining and managing Business related data thoroughly over the web, most of the business structures still won’t allow the data entries to be done in actual working environment. For such prospects, even if Sage CRM holds the greater importance from business perspective, the web architecture of CRM can’t be… Read More »

Generating Case Reference Number without User Id

In our previous posthttp://www.blogger.com/post-edit.g?blogID=6264840572654717689&postID=1152421825773155870 we discussed how case reference number gets generated for every case that is created in the CRM. In the earlier post we discussed how we can change the format of the case reference number. But it is still a combination of current user login id and the custom part, something like… Read More »

Case Ref Id Auto Generated

As we all know about the Case reference ID, it gets generated depends upon the current logged in user and some predefined number range. Currently it gets generated according to the SageCRM standards defined already but what to do if we want to generate a case reference according to the business standards? Suppose for Greytrix… Read More »

Display Image to notify number of Cases/Opportunities/Leads against Person/Company

If you find this useful, Please drop us a mail on crm@greytrix.com. Have you ever been imagine displaying a notification related to number of Cases created against a person? Solution: If you are looking:1. To identify how many cases registered against a person on the Person’s summary tab2. Or willing to show count of cases… Read More »

Globally scheduling the cases across users

Are you willing to find Cases categorized on the basis of User?Would you like to provide the user a feel like Calendar; while accessing Cases? We have a workaround which will help you to search the cases on the basis of user and its status. Also it shows pictorial representation of Cases you see in… Read More »

Time and Billing for Cases

Need to identify whether a recently closed case is billable or not?Want to create a report for cases which are billed on hourly basis?Solution:Now it is available in Sage CRM that a particular case is billable or not on the basis of some rules set by the admin. It calculates time duration by the time… Read More »