Generate reports in CRM using External Database – GUMU™ CRM – Sage EM Integration (Part I)

By | July 25, 2019

GUMU™ for Sage CRM – Sage EM integration is a real-time bi-directional link where user can update the information from Sage CRM to Sage EM and vice versa. Today, in this blog we will walk through how users can generate/view reports in Sage CRM using GUMU Sage CRM – Sage EM Integration by creating External database. This can be helpful for any Sage CRM users and Salesperson for viewing Sage EM information’s like customer, quotes, orders and invoices in Sage CRM through CRM standard reports.

New Stuff: Pre– Requisites for installing GUMU for sage CRM- Sage EM

User can customize views to add more fields from Sage CRM side. Since we have used standard Sage CRM reporting and view functionality, while building the view, user will need to make sure that you design or modify it as per standard Sage CRM procedure.

For generating reports in Sage CRM, user should create a View in Sage CRM which can be used during reporting purpose. We will explain the complete process by taking example of Customer entity from both Sage EM and Sage CRM and will generate the report by displaying Sage EM Customer data along with Sage EM and Sage CRM fields.

Create a View in Sage CRM which will display the Sage EM Customer information along with Sage EM and Sage CRM fields.

1. Administration -> Customization -> Company -> Views -> New
2. Enter proper View Name (say vCompanyReport)
3. Check Reports View checkboxes. This is required for generating reports in CRM
4. Enter View in View Script section and Save. Before adding View, make sure that View should get executed in SQL with proper field name which you want during reports. Refer below screenshot,


5. Refresh Metadata

Please go through the next blog section where , we have displayed reports in Sage CRM using Standard Sage CRM reporting functionality.

About Us

Greytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique integration solutions for Sage CRM with Sage ERP’s (Sage X3Sage 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 migrating to Sage CRM from ACTGoldmine and other CRM’s.

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