Promote Order Technique and Adding new field in the process in GUMU for Sage CRM- Sage X3

By | November 30, 2017

In GUMU™ for Sage CRM – Sage X3 integration, we have provided with feature where user can create Orders in Sage CRM and promote the same in Sage X3 ERP.
In this blog, we will discuss about technique / logic, we use in our GUMU framework in our current version of GUMU Sage CRM Sage X3 connector (1.0) while promoting customer from Sage CRM Sage X3.

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

For promoting order from Sage CRM to Sage X3 to we use field mapping table and the XSL technique.

1.All the list of fields for which we want to promote data from Sage CRM to Sage X3 while promoting order is stored in this (GT_Fieldmapping) CRM table. This table contains the columns like CRM source field name, Sage X3 source field name, Sage X3 screen name which will be used by GUMU to create XML which can be passed to Sage X3 web services to create records.

2.Above field mapping table consists of records for other processes as well but the data which represents field names for Promote order functionality are represented by “promotesalesorder” in column erpm_entityname and value as “promote” in column erpm_process.

3.Once the list of fields are fetched from the Sage CRM database from above mapping table, GUMU creates the XML using XSL template files we created which is stored in XSL folder in GUIU in Sage CRM directory.

In case if someone wants to promote data of a new field from Sage CRM order screen into Sage X3 using Promote order process then user can add entry of that new field in above fieldmapping table as well as in XSL and can promote data for corresponding custom field yourself.
For more information you can always contact us at

About Us

Greytrix is 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.

Also read :
1. Setting require of – Bulk Import from Sage X3 to Sage CRM
2. New Features in GUMU™ for Sage CRM – Sage X3 Integration – Auto Link
3. New Features in GUMU™ for Sage CRM – Sage X3 Integration – Manual Link
4. New Features in GUMU™ for Sage CRM – Sage X3 Integration – Link Business Partners
5. GUMU Integration is compatible with new Sage X3 v11 along with Sage CRM 2017 R2