{"id":81,"date":"2009-01-19T05:21:00","date_gmt":"2009-01-19T05:21:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=81"},"modified":"2009-01-19T05:21:00","modified_gmt":"2009-01-19T05:21:00","slug":"realtionship-management-in-sage-crm-v6-2","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/","title":{"rendered":"Realtionship Management in Sage CRM v6.2"},"content":{"rendered":"

Want to propagate communications of the parent entity to that of all the child entities for parent\/child relationship in Sage CRM version6.2? Check this one.
<\/em>
Sage CRM version 6.2 has provided a very strong and effective feature as \u201cRelated Entities\u201d functionality. Using this particular functionality we can create parent\/child and parent\/sibling relationships between the entities on the fly. This functionality has enabled us to create various \u201cone to many\u201d and \u201cmany to one\u201d relationships and also some reciprocal relationships between the entities.<\/p>\n

Using \u201cRelated Entities\u201d feature, it is very easy to establish the parent\/child relationship between two entities. We can establish the \u201cone to many\u201d relation between one entity (parent) with another entity (child) using parent\/child relationship. Let\u2019s consider one opportunity can have multiple companies as the children and now we want to propagate all the communications for an opportunity to that of all the child company entities. Here are the steps that we have analyzed for the same with some \u201cOut Of Box\u201d thinking.<\/p>\n

1. <\/strong>To define a new relation type Go to Administration \u00e0 Data Management \u00e0 Manage Relation Types \u00e0 New.
2. <\/strong>Select relation type \u201cparent\/child\u201d, \u201copportunity\u201d as a \u201cparent entity\u201d and \u201cCompany\u201d as a \u201cSecondary entity\u201d, enter the relationship names and click on Save button to save the relation.
3. <\/strong>At the backend the entry is made for this particular relation type in \u201cRelatedEntityLinks\u201d table with renl_entity1 as \u201copportunity\u201d and renl_entity2 as \u201cCompany\u201d.
4. <\/strong>Now for an opportunity we can go to the \u201cRelationships\u201c tab and add several child company entities. All these entries are made in \u201cRelatedEntityData\u201d table.
5. <\/strong>In \u201cRelatedEntityData\u201d table we can find id for the relationship type that we have created above as rend_relatedentitylinkid and we can also find the id\u2019s for parent and child entities as rend_entity1id and rend_entity2id.
6. <\/strong>This way we can find id\u2019s for all the company entities that are chidren for the particular opportunity.
7. <\/strong>Now as we know when if we create a communication for an opportunity an entry is also made in Comm_Link table where we can find to which all entities that communication is linked.
8. <\/strong>What we can do is we can write a table level scripts which will make use of the child entity id\u2019s that we have found from the \u201cRelatedEntityData\u201d table as mentioned in point number 5 and make entry in the Comm_Link table to update cmli_comm_companyid values for the particular communicationid. <\/p>\n

This way all the communications of parent entity i.e. opportunity can be attached to all the child companies associated with that particular opportunity.<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

Want to propagate communications of the parent entity to that of all the child entities for parent\/child relationship in Sage CRM version6.2? Check this one.Sage CRM version 6.2 has provided a very strong and effective feature as \u201cRelated Entities\u201d functionality. Using this particular functionality we can create parent\/child and parent\/sibling relationships between the entities on\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2488],"class_list":["post-81","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-uncategorized"],"yoast_head":"\nRealtionship Management in Sage CRM v6.2 - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Realtionship Management in Sage CRM v6.2 - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Want to propagate communications of the parent entity to that of all the child entities for parent\/child relationship in Sage CRM version6.2? Check this one.Sage CRM version 6.2 has provided a very strong and effective feature as \u201cRelated Entities\u201d functionality. Using this particular functionality we can create parent\/child and parent\/sibling relationships between the entities on\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-01-19T05:21:00+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/\",\"name\":\"Realtionship Management in Sage CRM v6.2 - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2009-01-19T05:21:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Realtionship Management in Sage CRM v6.2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Realtionship Management in Sage CRM v6.2 - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/","og_locale":"en_US","og_type":"article","og_title":"Realtionship Management in Sage CRM v6.2 - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Want to propagate communications of the parent entity to that of all the child entities for parent\/child relationship in Sage CRM version6.2? Check this one.Sage CRM version 6.2 has provided a very strong and effective feature as \u201cRelated Entities\u201d functionality. Using this particular functionality we can create parent\/child and parent\/sibling relationships between the entities on\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2009-01-19T05:21:00+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/","name":"Realtionship Management in Sage CRM v6.2 - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2009-01-19T05:21:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/01\/19\/realtionship-management-in-sage-crm-v6-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Realtionship Management in Sage CRM v6.2"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=81"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/81\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=81"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=81"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}