{"id":2499,"date":"2017-05-30T08:38:15","date_gmt":"2017-05-30T08:38:15","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/salesforce\/?p=2499"},"modified":"2025-06-12T09:41:36","modified_gmt":"2025-06-12T09:41:36","slug":"syncing-data-from-sage-100-into-salesforce-using-gumu","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/05\/30\/syncing-data-from-sage-100-into-salesforce-using-gumu\/","title":{"rendered":"Syncing data from Sage 100 into Salesforce using GUMU&#x2122;"},"content":{"rendered":"<p>Syncing data in our product <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">GUMU&#x2122; Sage ERP 100 Integration for Salesforce<\/a>, is a powerful feature and it empowers you with the ability to import any data in Salesforce from Sage ERP 100. The feature provides completely dynamic mapping where you can refresh fields and map ERP field with Salesforce field and can fetch and store data in Salesforce. Not just this, we can set relationship between two objects, we can set filters for particular object, chain to another syncing process. This data can further be leveraged to perform analysis using any Wave analytics, Dashboard reporting and visual charts.<\/p>\n<p>Please follow the below steps how to create Entity mapping in integration.<br \/>\n&#8211; &gt; Login to Salesforce.<br \/>\n&#8211; &gt; Go to App menu and select \u201cGUMU Settings\u201d App from the list.<br \/>\n&#8211; &gt; Click on \u201cImport Data\u201d menu to view the entity list page<br \/>\n&#8211; &gt; Entity mapping list page will display the Entity Synchronizations as shown in above screen.<\/p>\n<div id=\"attachment_2503\" style=\"width: 605px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image1.jpg\" target=\"_blank\" rel=\"noopener\"><img fetchpriority=\"high\" decoding=\"async\" aria-describedby=\"caption-attachment-2503\" class=\"size-large wp-image-2503\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image1-1024x392.jpg\" alt=\"Entity Sync New Mapping\" width=\"595\" height=\"228\" \/><\/a><p id=\"caption-attachment-2503\" class=\"wp-caption-text\">Entity Sync New Mapping<\/p><\/div>\n<p>You will see \u201cNew Entity Mapping\u201d button. Click on \u201cNew Entity Mapping\u201d button to create a new mapping.<\/p>\n<div id=\"attachment_2504\" style=\"width: 605px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image2.jpg\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" aria-describedby=\"caption-attachment-2504\" class=\"size-large wp-image-2504\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image2-1024x433.jpg\" alt=\"Entity Sync Chain To\" width=\"595\" height=\"252\" \/><\/a><p id=\"caption-attachment-2504\" class=\"wp-caption-text\">Entity Sync Chain To<\/p><\/div>\n<p>&#8211; &gt; Enter the details in Entity mapping Detail section. The entity mappings are identified by their names and hence the name should be unique for each Entity mapping.<br \/>\n&#8211; &gt; Enter Salesforce object name as the Target entity.<br \/>\n&#8211; &gt; Click on Entity look-up to select appropriate Sage ERP 100 entity (e.g.Customer).<br \/>\n&#8211; &gt; Chain-To is an optional field. You can chain the import of data using this feature. If the syncing is chained, it would trigger the syncing of the next entity in chain once the current import has been executed.<br \/>\n&#8211; &gt; You can even schedule Entity import to run on a regular basis by configuring the Schedule section.<\/p>\n<div id=\"attachment_2505\" style=\"width: 605px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image3.jpg\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" aria-describedby=\"caption-attachment-2505\" class=\"size-large wp-image-2505\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image3-1024x148.jpg\" alt=\"Entity Sync Scheduler\" width=\"595\" height=\"86\" \/><\/a><p id=\"caption-attachment-2505\" class=\"wp-caption-text\">Entity Sync Scheduler<\/p><\/div>\n<p>&#8211; &gt; Click on \u201cRefresh Fields\u201d and this will bring the list of all the fields in the target entity in the Mapping tab.<br \/>\n&#8211; &gt; Map the appropriate ERP fields from Source Field list against Salesforce fields.<br \/>\n&#8211; &gt; You can also provide filter for Entity sync to retrieve records based on specified conditions<\/p>\n<div id=\"attachment_2506\" style=\"width: 605px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image4.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2506\" class=\"size-large wp-image-2506\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image4-1024x156.jpg\" alt=\"Entity Sync Filter\" width=\"595\" height=\"91\" \/><\/a><p id=\"caption-attachment-2506\" class=\"wp-caption-text\">Entity Sync Filter<\/p><\/div>\n<p>&#8211; &gt; Click on \u201cAdd Filter Row\u201d button to add filter row. Select source field from list for which you want set filter and add the value for the field.<br \/>\n&#8211; &gt; Select the Active checkbox for all the filter criteria that you want before saving the Entity Sync.<br \/>\n&#8211; &gt; You can either deactivate the filter by unchecking the active checkbox or remove the filter by selecting the record and hitting the \u201cRemove Filter Row\u201d button.<br \/>\n&#8211; &gt; You can set relationship for the Sync, if the target object has a parent in Salesforce (e.g. Account-Contact).<\/p>\n<div id=\"attachment_2507\" style=\"width: 605px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image5.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2507\" class=\"size-large wp-image-2507\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image5-1024x147.jpg\" alt=\"Entity Sync RelationShip\" width=\"595\" height=\"85\" \/><\/a><p id=\"caption-attachment-2507\" class=\"wp-caption-text\">Entity Sync RelationShip<\/p><\/div>\n<p>&#8211; &gt; To add a relationship, click on \u201cAdd Row\u201d button.<br \/>\n&#8211; &gt; Select target field from the list.<br \/>\n&#8211; &gt; Select source field from the list.<br \/>\n&#8211; &gt; Select Parent Object Name from the list of Salesforce Objects (i.e. Account is parent object of Contact object in Salesforce).<br \/>\n&#8211; &gt; You can remove relationship by selecting the relation record and clicking on \u201cRemove Row\u201d button.<br \/>\n&#8211; &gt; After setting all the information, click on \u201cSave button\u201d. This will create your Entity Mapping.<\/p>\n<div id=\"attachment_2502\" style=\"width: 605px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image6.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2502\" class=\"size-large wp-image-2502\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2017\/05\/Image6-1024x490.jpg\" alt=\"Completed Entity Sync Setting\" width=\"595\" height=\"285\" \/><\/a><p id=\"caption-attachment-2502\" class=\"wp-caption-text\">Completed Entity Sync Setting<\/p><\/div>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0as a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners across the globe. We offers Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that requires apex code incorporation into the Salesforce platform.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0has some unique solutions for Cloud CRM such as Salesforce integration with\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Sage Enterprise Management (Sage X3<\/a>),\u00a0Sage Intacct, <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Sage 100\u00a0<\/a>and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/gumu-300-salesforce-integration\">Sage 300 (Sage Accpac)<\/a>. We also offer best-in-class Cloud CRM\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/crm-development\/salesforce-com\">Salesforce customization and development services<\/a> along with services such as Salesforce <a href=\"https:\/\/www.greytrix.com\/product\/professional-services\/data-migration-services\">Data Migration<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/professional-services\/integrated-application-development\">Integrated App development<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/professional-services\/custom-development\">Custom App development<\/a> and <a href=\"https:\/\/www.greytrix.com\/product\/professional-services\/maintenance-support\">Technical Support<\/a> to business partners and end users.<\/p>\n<p>Greytrix GUMU&#x2122; integration for Sage ERP \u2013 Salesforce is a 5-star app listed on <a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<\/p>\n<p>For more information, please contact us at\u00a0<a href=\"mailto:salesforce@greytrix.com\">salesforce@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n<p><span style=\"font-size: Medium;\"><strong>Related Posts<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/04\/26\/promote-shipping-address-in-salesforce-sage-100-integration\/\" target=\"_blank\" rel=\"noopener\">Promote Shipping Address in Salesforce &#8211; Sage 100 Integration<\/a><\/li>\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/03\/09\/promote-salesforce-account-to-sage-100-customer\/\" target=\"_blank\" rel=\"noopener\">Promote Salesforce Account to Sage 100 Customer<\/a><\/li>\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2015\/08\/28\/salesforce-side-configuration-for-gumu-salesforce-sage-100-erp-integration\/\" target=\"_blank\" rel=\"noopener\">Salesforce side configuration for GUMU Salesforce \u2013 Sage 100 ERP Integration<\/a><\/li>\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2016\/08\/08\/creation-of-default-entities-and-mappings-using-gumu-sage-100-erp-integration-for-salesforce\/\" target=\"_blank\" rel=\"noopener\">Creation of Default Entities and Mappings using GUMU&#x2122; SAGE 100 ERP Integration for Salesforce<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Syncing data in our product GUMU&#x2122; Sage ERP 100 Integration for Salesforce, is a powerful feature and it empowers you with the ability to import any data in Salesforce from Sage ERP 100. The feature provides completely dynamic mapping where you can refresh fields and map ERP field with Salesforce field and can fetch and\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/05\/30\/syncing-data-from-sage-100-into-salesforce-using-gumu\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[113,115,162,179,184,188,359,360,361,377,401,424,430,483],"class_list":["post-2499","post","type-post","status-publish","format-standard","hentry","category-gumu-salesforce","tag-entity-mapping","tag-entity-sync","tag-gumusfsage100","tag-import","tag-integrate-salesforce-with-sage-100","tag-integrate-sfdc-and-sage-100","tag-sage100","tag-sage100-salesforce","tag-sage100-sf","tag-salesforce-and-sage-100-integration","tag-salesforce-integration-with-sage-100","tag-salesforce-with-sage-100-integration","tag-salesforce-sage100","tag-sync"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/2499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/comments?post=2499"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/2499\/revisions"}],"predecessor-version":[{"id":10932,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/2499\/revisions\/10932"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=2499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=2499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=2499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}