Sage CRM - Tips, Tricks and Components
Greytrix is one of the largest Gold Development Partner of Sage CRM and has been awarded "Sage Development Partner of the Year" three times in the last few years. Greytrix has been working on customization and products in SageCRM since last decade and have accumulated hundreds of man years of experience. In this blog, Greytrix will endeavour to stop reinvention of wheel and save upto 90% of project cost of SageCRM users by presenting a list of useful small components, tools and add-ons for SageCRM!

Issues while upgrading the Sage CRM-ACCPAC integrated system

By greytrix On February 20, 2012

Day by day more advanced and useful business softwares are being launched by Sage. Sage CRM latest versions like version 7.0, version 7.1 integrates with more advanced Sage 300 (Accpac) versions like Accpac 6.0, 6.1 etc. Now process of implementation is very easy and straight forward as far as new installation is concerned, however when [...]

Continue Reading →

Validation of Workflow Rule based on Date field value

By greytrix On February 20, 2012

For one of our clients we had a requirement where 3 days after closing opportunity a welcome letter needed to be sent out. The closure action was tracked using two fields Status (Closed) and Closed Date (Date when opportunity was closed). There was an action in workflow to send out the Welcome Letter to clients; [...]

Continue Reading →

OSQL error at the time of installing CRM

By greytrix On February 13, 2012

You must have come across the above mentioned issue when installing CRM on multiserver architecture where Application server and Database server are two different machines on the network. This error occurs at the time of installing CRM on Application server.

This issue seems to be related to the database connectivity across the server, [...]

Continue Reading →

Cannot open database requested by the login. The login failed.

By greytrix On February 13, 2012

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, [...]

Continue Reading →

Remove hyperlink from summary caption tags

By greytrix On February 13, 2012

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 [...]

Continue Reading →

Remove hyperlink from list column based on value in other column

By greytrix On February 13, 2012

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 [...]

Continue Reading →

Set default action based on file extension at the time of document drop

By greytrix On January 30, 2012

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 [...]

Continue Reading →

Document upload link from other entity lists

By greytrix On January 30, 2012

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 [...]

Continue Reading →

Remove Action Buttons using client side script

By greytrix On January 25, 2012

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 [...]

Continue Reading →

Executing Stored Procedures using COM API methods

By greytrix On January 25, 2012

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 [...]

Continue Reading →
← Previous Entries
  • Blog Archives

    • February 2012 (6)
    • January 2012 (6)
    • December 2011 (3)
    • November 2011 (5)
    • October 2011 (8)
    • September 2011 (5)
    • August 2011 (9)
    • July 2011 (9)
    • June 2011 (13)
    • May 2011 (10)
    • April 2011 (10)
    • March 2011 (6)
    • February 2011 (5)
    • January 2011 (6)
    • December 2010 (9)
    • November 2010 (10)
    • October 2010 (8)
    • September 2010 (8)
    • August 2010 (8)
    • July 2010 (7)
    • June 2010 (8)
    • May 2010 (7)
    • April 2010 (7)
    • March 2010 (1)
    • February 2010 (1)
    • November 2009 (2)
    • October 2009 (7)
    • September 2009 (9)
    • August 2009 (16)
    • July 2009 (15)
    • June 2009 (18)
    • May 2009 (24)
    • April 2009 (22)
    • March 2009 (10)
    • February 2009 (6)
    • January 2009 (5)
    • December 2008 (22)
    • November 2008 (4)
    • September 2008 (8)
    • August 2008 (30)
    • July 2008 (5)
    • June 2008 (3)
  • Related Websites and Blogs

    • Greytrix
    • Greytrix Consulting
    • Sage Accpac – Tips, Tricks and Components
    • Sage ERP X3 – Tips, Tricks and Components
    • Sage MAS and ACT! Blog
    • SME ERP India Blog
  • Tags

    Bi-Directional Case Communication Company CRM7.0 Custom Date Delete document Email Entity Field GUMU import INTEGRATION Lead library MAS 90/200 merge MultiSelect opportunity Opporunity Order Order Entry Person Phone REAL TIME Report Sage CRM.com Sage CRM 7.0 Sage CRM 7.1 Sage Pro Sage Saleslogix screen search select advance self service SSA summary report table task territory Uncategorized Users web client workflow

Sage CRM – Tips, Tricks and Components

Pages

The Latest

  • Issues while upgrading the Sage CRM-ACCPAC integrated system
    Day by day more advanced and useful business softwares are being launched […]

More

Thanks for dropping by! Feel free to join the discussion by leaving comments, and stay updated by subscribing to the RSS feed.
© 2012 Sage CRM - Tips, Tricks and Components
Platform by PageLines