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 »
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 »
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 »
Whenever we create quotes through standard screen, it calls the internal methods to generated Quote reference id based on reference format and updates the new quote record with the same. When we create quote using CreateRecord method in COMP API we don’t get this value automatically set. Below is the function you can use in… Read More »
Nowadays various business softwares are relying largely on ActiveX components for using third party tools. After all, it is one reliable of the many ways available for using software components in programming language independent way as an integral part of Component Object Model. Document Drop is one of the functionality in Sage CRM which uses… Read More »
In today’s software world reducing number of clicks is an essential task. In CRM we can have communications against all the entities. How helpful it would be; if I can provide link to parent entity on communication screen itself? This way I can go from communication find screen and then also visit the relevant entity… Read More »
Let’s say I want to change the way text appears in a textbox when the screen loads as well as when I type in the field. Here is the function you can write in Custom Content of the screen to achieve the same. Script //’Function to change text color in function ChangeTextColor(FldName,TextColor) { FldName =… Read More »
Some days ago I came across this question on one of the CRM forums. The requirement was like when I select company and go to People tab, if no primary person has been set for that company then display the message “Primary person has not been set”. I remember I did something similar to this… Read More »
For any business firm, monitoring and optimizing services is an imperative task. Considering the fact that whatever is sold needs to be serviced sometime, today’s business demands need to concentrate not only on the Sales, but also on the after sales services. Sage CRM has provided Lead, Opportunity, Quotes, and Orders to maintain the Sales… Read More »
Some days ago i came across the requirement where i needed to display three different sections of the details on the same page. Not that tricky when i design three different pages and put the m in iframes on main page. However Iframe is certainly not a preferable option as it is blocked by many… Read More »
