Have you ever encountered this error message “Cannot open database [XXXX] requested by the login. The login failed. “ While installing CRM patches with SQL Server and MSSQL services both available on the same SQL server??? As the error says there might be many reasons for it to not to connect to database like network dis-connectivity,… Read More: Cannot open database requested by the login. The login failed. »
In standard CRM you can see summary screen for all entities like Company, Person, Cases, and Communication. To change basic details for the company or Person entity you can choose two ways 1. Click on the Change button from Summary screen (Refer screenshot below.) 2. Click on the Summary Block hyperlink of Summary screen. (Refer… Read More: Remove hyperlink from summary caption tags »
We can create List objects for CRM entities and add them to custom pages to load on specific tab. We can link list columns to existing entities or custom pages using Hyperlink to or custom junk functionalities available in List editing feature. However we came across the requirement where hyperlink on person name needed to… Read More: Remove hyperlink from list column based on value in other… »
In Sage CRM, we have the document drop functionality. We can drag the document on document drop icon and it will open the communication task screen with the attached document. Now suppose we want to set the default action value of communication based on the document extension. For example if the document is word then… Read More: Set default action based on file extension at the time… »
Sage CRM provides document upload functionality against almost all the entities in CRM. We can use the same to upload Draft and Finalized versions of relevant documents. Recently we came across the requirement where we were supposed to show the upload link as the separate hyperlink column in custom entity list screen. The requirement was… Read More: Document upload link from other entity lists »
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 »
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 »
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 »
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 »
Cloud or Hosted solutions are the buzzword businesses are looking at for moving their ERP or CRM solutions. But there may be a need to get your data in-house. We often come across this query and same has been discussed many a times on Sage CRM Community. Putting this in our blog for our readers… Read More: How to Migrate your data from Sage CRM Cloud to… »
