Category Archives: SQL

Create Dynamic Grids Without SQL Using Table-wise in GUMU v5.6.0.5

Introduction In the previous article, we introduced the enhanced Dynamic Grid Query Manager in GUMU for Sage CRM and Sage 100, including its Query-wise and Table-wise configuration approaches. In this article, we will take a closer look at one of the key enhancements introduced in GUMU v5.6.0.5 — Table-wise Configuration. Organizations frequently need to display… Read More: Create Dynamic Grids Without SQL Using Table-wise in GUMU v5.6.0.5 »

Troubleshooting “ProvideX Object Error” in Sage CRM – Sage 100 GUMU Integration

The GUMU™ for Sage CRM – Sage 100 Integration is a real-time, bi-directional link that seamlessly connects Sage CRM and Sage 100 where users can view information for customers, invoices and orders from either of the systems. It also supports multiple company integration, allowing multiple Sage 100 companies to be linked with a single Sage CRM instance. In this… Read More: Troubleshooting “ProvideX Object Error” in Sage CRM – Sage 100… »

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: Steps to be followed after change of Windows and SQL… »

Modify the number of Stages to be displayed in Sage CRM

Sage CRM pipeline is basically a graphical representation of data stage wise. The pipeline can be visible for Cases, Opportunities, and Leads in Sage CRM. It is also useful to review the current stage of the Opportunities, Leads, and Cases assigned across the teams to various users. New Stuff: Mark Task ‘Complete’ from Calendar Tab Recently… Read More: Modify the number of Stages to be displayed in Sage… »

Remove Groups from Sage CRM DB using SQL Queries

Sage CRM can be customized many ways, but some time user wants to undo the changes which have been done before. Suppose some time it happed that user has created number of Group which he may need to remove if there is no longer in use. So user can also delete this Group that have… Read More: Remove Groups from Sage CRM DB using SQL Queries »

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: Adding Secondary Entity for Primary Entity »

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 – complete tasks of a closed opportunity in Sage… »

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: Auto update opportunity stage using escalations rules »

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: Duration column in Tracking tabs within Sage CRM »