Category Archives: SQL

Steps to be followed after change of Windows and SQL Password

The GUMUTM for Sage CRM – Sage 100 is a real time bi-directional integration link, using which an user can promote Sage CRM company, sales order from Sage CRM to Sage100. In addition to this, the information for Sage 100 customer flows between Sage CRM on real depending on the configuration setting option selected. Today… Read More »

Adding Secondary Entity for Primary Entity

It is possible to customize Sage CRM in different ways, to meet user requirement. There are many customization option in Administration.  So in this Blog we are going to see how to create a secondary Entity for Standards Entity. Sometime if organization is using Opportunity entity to store all of their Projects in Sage CRM. It… Read More »

Auto – complete tasks of a closed opportunity in Sage CRM

As we all know, Sage CRM’s Communications entity has not only helped to manage communication with the Customers but also internally within the application users. Another important feature is the ability to link these communications of any type i.e. Task, Appointments, or Email to the respective Sales or Service record of the Customer. This has… Read More »

Auto update opportunity stage using escalations rules

Opportunities are a very important aspect of sales revenues in any business as they help us to track orders, sales forecast and quotations against every sale. As we know opportunity goes through various stages in Sage CRM. In this blog, we will discuss how to auto update opportunity stage from Proposal Submitted to Proposal Approved… Read More »

Duration column in Tracking tabs within Sage CRM

Hey folks! You guys must have seen Duration column within Tracking tabs of Cases, Opportunities etc. Duration column shows values in Days, Hours and Minutes format. In this blog, we will explain how Duration is calculated within Sage CRM and displayed into Tracking tabs. New Stuff: Modify Print Quote button functionality in Sage CRM Consider Opportunity… Read More »

Suppress inactive records from SSA fields in Sage CRM

In Sage CRM while creating a record against a Company you must have noticed both Active and Inactive Company records are displayed in the SSA drop-down list. As displayed in below screenshot.In our blog we will provide a quick tip how you can exclude Inactive records from an SSA drop-down list by adding a short… Read More »

How to get SQL Query of Groups created in Sage CRM

In Sage CRM, Groups feature allows you to create, edit, and save lists of people, companies, leads, cases, opportunities, quotes and orders based on defined filter criteria. Groups are based on the SQL views generated by queries. The views that are used to create group’s needs to be designed such that each row should return… Read More »