Import Data from Sage 100 ERP to Salesforce using Last Sync Field and Value.

By | October 30, 2017

Our GUMU™ SAGE ERP Integration for Salesforce (Sage X3, Sage 100 and Sage 300) is real-time bi-directional link. Using GUMU™ user can sync data between Salesforce to Sage ERP and vice versa. Here in this blog, we will discuss how to bring data in bulk from Sage 100 to Salesforce using last sync field and last sync value.

Please follow the below steps
-> Login to Salesforce.
-> Go to App menu and select “GUMU Settings” App from the APP list. Below page will be displayed,

GUMU Settings Menu

GUMU Settings Menu

-> Click on “Import Data” menu to view the entity list page.
-> “Edit” Existing Entity.
-> Click on “Refresh Fields” button.

Entity Sync Mapping

Entity Sync Mapping

-> Select the “Last Sync field” value from drop down,which shows all the fields of sage 100 related to that API name.
-> Enter the “Last Sync Value” as shown in Below image.

Entity Sync Mapping - Last Sync Value

Entity Sync Mapping – Last Sync Value

-> Click on “save”
-> As shown in above image Last Sync field is ‘DateUpdated’ and Last Sync Value is ‘20170101’ while import routine is run the records which have DateUpdated value 20170101 and greater than that records is being imported in Salesforce.
-> If user want to import only 2017 and above data so user can select the field in Last Sync Field and enter the value in Last Sync Value.

Also Read:
1. Promote Shipping Address as default address in Salesforce – Sage 100 Integration
2. Promote Sales Order from Salesforce to Sage 100 ERP
3. Syncing data from Sage 100 into Salesforce using GUMU™
4. Promote Shipping Address in Salesforce – Sage 100 Integration
5. Promote Salesforce Account to Sage 100 Customer

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 customization’s, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix has some unique solutions for Cloud CRM such as Salesforce integration with Sage X3, Sage 100 and Sage 300. We also offer best-in-class Cloud CRM Salesforce customization and development services to business partners and end users. Greytrix has some unique solutions for On-Premise CRM such as Sage CRM integration with Sage X3, Sage 100, Sage 300, Sage 500 and Sage 50. We also offer best-in-class On-Premise Sage CRM customization and development services to business partners and end users.

For more information, please contact us at salesforce@greytrix.com. We will be glad to assist you.