Add Fields to Statistic Panel of Opportunity

By | May 31, 2021

Opportunities in Sage CRM helps user to track orders, sales forecast and quotations against every sale. Sage CRM felicities user to summarized sales forecast for personal as well as team level using Pipeline feature at My CRM and Team CRM tab.  Pipeline is show opportunities present in CRM at different stages. Refer below:

New Stuff: Using RESTful API in Sage CRM – Part 1


Pipelines enables statistic panel which shows Number of Opportunities, Forecast, Weighted Forecast, Average Value, Average Certainty, Weighted Average fields. These analysis helps user to gather data in coming period of time regarding estimated forecast and helps them to build future strategies accordingly.

 Recently one of our client came up with a request to remove some of these fields from static panel and add some custom field in it. Hiding fields was an easy task using some client side scripting but adding custom fields wasn’t. Statistic panel is rendered through eWare.dll and this code is not exposed.

We have achieved this requirement using Ajax request and client side scripting. User can add any custom field in statistic panel with any filter criteria applied and added Total Annualized Value and Total Annual Value in Statistical panel. Refer below:

Statistic Panel
Statistic Panel

We have designed it dynamically so that later if user adds any field in filter box of opportunity existing code will imbibe new filter criteria for custom fields as that of standard fields. Security rights as per logged in user are also been handled.

Update Panel
Updated Panel

So user can now able to see desired data in statistic panel which will be further beneficial from business point of view.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500 and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service Signature and Sage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at We will be glad to assist you.