Author Archives: greysagecrm

Remove Action Buttons using client side script

We had posted much detailed content earlier for removing buttons from standard screens using client side scripts. This is in continuation with the same. When you are customize any List or Summary screen you can find there are lots of action buttons available on right hand side; for example communication search screen. On this screen you can see Find,Clear… Read More: Remove Action Buttons using client side script »

Executing Stored Procedures using COM API methods

This is developer specific technical tip which can be used in CRM customizations. In customizations we usually execute sql statements using CreateQueryObj function. For Eg. SqlQuery = “Select comp_name from company (nolock) where comp_compname=”+sCompId; SqlObj = eWare.CreateQueryObj(SqlQuery); SqlObj.SelectSQL(); Here to retrieve the value of comp_name we can use SqlObj(“comp_name”). The above example is for the… Read More: Executing Stored Procedures using COM API methods »

Setting a Territory field by default to Worldwide

As we all know when we implement sales processes in CRM, territory becomes an essential part of it. Territories help us to separate entities based on user access rights. For example, you may want users in the Europe territory to view all Opportunities within the USA territory, but not to be able to update them.… Read More: Setting a Territory field by default to Worldwide »

Error while writing scripts on OnChange script section

Recently I came across a problem with OnChangeScript in sage CRM version 7.1. Somehow OnChangeScript for search select advanced fields doesn’t like the script to be on multiple lines! i.e. Below written script doesn’t work: id = document.EntryForm.comp_type.value; alert (‘comp_type:’+id); and Below written script works: id = document.EntryForm.proj_companyid.value;alert (companyid :’+id); First script gives the following… Read More: Error while writing scripts on OnChange script section »

Desktop Size Limitation

In my earlier post I had explained the different workarounds if the user gets the below error. https://www.greytrix.com/blogs/sagecrm/2010/04/error-exporting-reports-to-excel-in-crm Recently, I faced the same issue while exporting the Sage CRM standard report into Excel. However when I run the report by setting Display Options as Screen/ Print Preview, then the report runs without any error. Looking… Read More: Desktop Size Limitation »

Error in Uploading companies using CSV file with Date & Integer columns

As you might be familiar with the standard import processes, you can upload data using CSV as well as Excel files. Excel stores the data column-wise hence we don’t get data type conflict errors so often. However in CSV the data is stored comma separated and sometimes programs don’t understand the data type of the… Read More: Error in Uploading companies using CSV file with Date &… »

Error in Uploading companies using CSV file with Date & Integer columns

As you might be familiar with the standard import processes, you can upload data using CSV as well as Excel files. Excel stores the data column-wise hence we don’t get data type conflict errors so often. However in CSV the data is stored comma separated and sometimes programs don’t understand the data type of the… Read More: Error in Uploading companies using CSV file with Date &… »