{"id":4971,"date":"2019-08-21T20:46:37","date_gmt":"2019-08-21T20:46:37","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=4971"},"modified":"2019-09-11T05:27:13","modified_gmt":"2019-09-11T05:27:13","slug":"gumu-salesforce-import-routine-tricks-and-facts-about-creating-relationship-between-entities","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/08\/21\/gumu-salesforce-import-routine-tricks-and-facts-about-creating-relationship-between-entities\/","title":{"rendered":"GUMU&#x2122; Salesforce Tricks and Tips \u2013 about creating Relationship between Entities Import Routine"},"content":{"rendered":"\n<p>We have already described the details of how <strong><a rel=\"noreferrer noopener\" aria-label=\"Entity Sync Mapping (opens in a new tab)\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/05\/30\/syncing-data-from-sage-100-into-salesforce-using-gumu\/\" target=\"_blank\">Entity Sync Mapping<\/a><\/strong> functionality of <a href=\"https:\/\/www.greytrix.com\/product\/gumu\/gumu-connector\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"GUMU&#x2122; (opens in a new tab)\">GUMU&#x2122;<\/a> can help you import any data from your Sage ERP system to Salesforce. <\/p>\n\n\n\n<p>In this blog we will be highlighting the instructions on how to create relationship in the import routine for related objects, so that the data from those can be brought over to Salesforce.<\/p>\n\n\n\n<p><em>There are already some relationships present in the entity mapping for some standard Objects such as Orders, Order Products etc. But if we want to create a new relationship, we can create them with the help of steps mentioned below.<\/em><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><em>Prerequisites:- You need to create the Lookup relationship for that object to link it to another Object.<\/em><\/p><\/blockquote>\n\n\n\n<p>Create new import routine for custom\/standard Object.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/08\/1_Import-routine-for-custom-object.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/08\/1_Import-routine-for-custom-object.png\" alt=\"Import Routine for Custom Object\"><\/a><\/center>\n\n\n\n<p>Now, to set the relationship, you need to select the Lookup field which was created in the Salesforce Object. In the \u201cTarget Field\u201d and the \u201cSource Field\u201d you will have to select the ERP field followed by the \u201cParent Object\u201d of the \u201cTarget Field\u201d. For better understanding refer the image below.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/08\/2_Relationship-in-Import-Routine.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/08\/2_Relationship-in-Import-Routine.png\" alt=\"Relationship in Import Routine\"><\/a><\/center>\n\n\n\n<p>After creating the above relationship, whenever you sync the data from ERP to Salesforce, we will get all the record related to that Object. For example, if you want to display the location in Salesforce custom Object then you need to create formula fields for the Location. After creating the formula fields, create the relationship in the import routine of the custom Object where you want to display the Location details.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/08\/3_LocationDetails.jpg\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/08\/3_LocationDetails.jpg\" alt=\"Location Details\"><\/a><\/center>\n\n\n\n<p>Go to the Import Routine and create the relationship for the Location.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/08\/4_Relationship.jpg\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/08\/4_Relationship.jpg\" alt=\"Updated Relationship\"><\/a><\/center>\n\n\n\n<p style=\"text-align: justify\"><b>About Us<\/b><\/br>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u2013 a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.<br><br> Greytrix has some unique solutions for Cloud CRM such as <a href=\"\">Salesforce Sage integration<\/a> for <a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/integration\/\">Sage X3<\/a>, <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-100-integration\/\">Sage 100<\/a> and <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-300-integration\/\">Sage 300 (Sage Accpac)<\/a>. We also offer best-in-class Cloud CRM <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/crm-development\/\">Salesforce customization and development services<\/a> along with services such as Salesforce <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/data-migration-support\/\">Data Migration<\/a>, <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/crm-development\/\">Integrated App development<\/a>, Custom App development and Technical Support business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU&#x2122; integration for Sage ERP \u2013 Salesforce is a 5-star rated app listed on <a href=\"https:\/\/appexchange.salesforce.com\/appxListingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<br> The GUMU&#x2122; Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.<br><br> For more information on our Salesforce products and services, contact us at <a href=\"mailto:salesforce@greytrix.com\">salesforce@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n<p><strong>Related Posts<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"GUMU&#x2122; Salesforce Import Routine \u2013 Tricks and Facts about the use of Filter Functionality (opens in a new tab)\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/07\/31\/gumu-salesforce-import-routine-tricks-and-facts-about-the-use-of-filter-functionality\/\" target=\"_blank\">GUMU&#x2122; Salesforce Import Routine \u2013 Tricks and Facts about the use of Filter Functionality<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Create Entity in GUMU&#x2122; SAGE ERP Integration for Salesforce (opens in a new tab)\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2018\/06\/05\/create-entity-in-gumu-sage-erp-100-integration-for-salesforce\/\" target=\"_blank\">Create Entity in GUMU&#x2122; SAGE ERP Integration for Salesforce<\/a><\/li><li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/10\/30\/import-data-from-sage-100-erp-to-salesforce-using-last-sync-field-and-value\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Import Data from Sage 100 ERP to Salesforce using Last Sync Field and Value. (opens in a new tab)\">Import Data from Sage 100 ERP to Salesforce using Last Sync Field and Value.<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>We have already described the details of how Entity Sync Mapping functionality of GUMU&#x2122; can help you import any data from your Sage ERP system to Salesforce. In this blog we will be highlighting the instructions on how to create relationship in the import routine for related objects, so that the data from those can\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/08\/21\/gumu-salesforce-import-routine-tricks-and-facts-about-creating-relationship-between-entities\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[114,115,158,159,164,165,166,169,678,185,186,187,189,363,364,367,370,372,374,378,389,400,402,676,671,683,673,684,425,454,458,461,462,463],"class_list":["post-4971","post","type-post","status-publish","format-standard","hentry","category-gumu-salesforce","tag-entity-setting","tag-entity-sync","tag-gumu-settings","tag-gumu-sf-integration","tag-gumusfsage300","tag-gumusfsage300erp","tag-gumusfsageem","tag-gumusfsageerpx3","tag-gumulightninginterface","tag-integrate-salesforce-with-sage-300","tag-integrate-salesforce-with-sage-em","tag-integrate-salesforce-with-sage-x3","tag-integrate-sfdc-and-sage-300","tag-sageem","tag-sagex3","tag-salesforce","tag-salesforce-sage-300","tag-salesforce-sage-em","tag-salesforce-sage-x3","tag-salesforce-and-sage-300-integration","tag-salesforce-crm-integration-for-sage-erp","tag-salesforce-integration-with-sage","tag-salesforce-integration-with-sage-300","tag-salesforce-lightning-sage300-integration","tag-salesforce-lightning-and-sage-300-integration","tag-salesforce-lightning-and-sagex3-integration","tag-salesforce-lightning-integration-with-sage-300","tag-salesforce-lightning-sagex3-integration","tag-salesforce-with-sage-300-integration","tag-sfdc-sage-300","tag-sfdc-integration-with-sage-300","tag-sfdc-with-sage-300-integration","tag-sfdc-with-sage-em-integration","tag-sfdc-with-sage-x3-integration"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/4971","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/comments?post=4971"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/4971\/revisions"}],"predecessor-version":[{"id":5069,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/4971\/revisions\/5069"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=4971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=4971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=4971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}