{"id":17676,"date":"2026-01-29T11:54:56","date_gmt":"2026-01-29T11:54:56","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=17676"},"modified":"2026-08-20T06:50:29","modified_gmt":"2026-08-20T06:50:29","slug":"how-relation-type-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-relation-type-works-in-idempiere\/","title":{"rendered":"How Relation Type Works in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A <strong>Relation type<\/strong> defines how two records in iDempiere are logically connected. It makes existing links visible and navigable in the UI, allowing users to move between related documents like orders and shipments without creating or modifying any data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"279\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Relation-Type-WorkFlow.png\" alt=\"\" class=\"wp-image-27757\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Relation-Type-WorkFlow.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Relation-Type-WorkFlow-300x82.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Relation-Type-WorkFlow-768x209.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"393\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-RelationType.png\" alt=\"\" class=\"wp-image-17750\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-RelationType.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-RelationType-300x115.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-RelationType-768x295.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How a Relation Type Is Defined<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Each relation type is defined at <strong>s<\/strong><strong>ystem<\/strong><strong> level<\/strong> and applies across all organizations. It describes the relationship using source and target references that already exist in the data model.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When creating or reviewing a relation type, the focus is on:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Which record is the <strong>source<\/strong><\/li>\n\n\n\n<li>Which record is the <strong>target<\/strong><\/li>\n\n\n\n<li>How the system should interpret that connection<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Key elements you see in the Relation Type window:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Name<\/strong> \u2013 Describes the relationship in readable form<\/li>\n\n\n\n<li><strong>Type<\/strong> \u2013 Usually <em>Implicit<\/em>, meaning the link already exists<\/li>\n\n\n\n<li><strong>Source Reference<\/strong> \u2013 The table and field where the relationship starts<\/li>\n\n\n\n<li><strong>Target Reference<\/strong> \u2013 The table and field where the relationship points<\/li>\n\n\n\n<li><strong>Entity Type<\/strong> \u2013 Normally <em>Dictionary<\/em>, meaning system-defined<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"457\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-RelationType-1.png\" alt=\"\" class=\"wp-image-17751\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-RelationType-1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-RelationType-1-300x134.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Master-RelationType-1-768x343.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How Implicit Relations Work in Daily Use<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Most relation types in iDempiere are <strong>i<\/strong><strong>mplicit<\/strong>. This means the relationship is not manually created by users but is derived from existing reference columns like IDs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A <strong>Shipment<\/strong> already stores the Order ID<\/li>\n\n\n\n<li>An <strong>Invoice<\/strong> already stores the Shipment or Order ID<\/li>\n\n\n\n<li>A <strong>Credit Memo<\/strong> already references the original invoice<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The relation type tells iDempiere: \u201cThese two records are connected. Show that connection to the user.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This allows the system to automatically show related records in:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Document links<\/li>\n\n\n\n<li>Zoom-across navigation<\/li>\n\n\n\n<li>Related records panels<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Relation Types You Will See<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">iDempiere comes with many predefined relation types that reflect standard business flows.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Typical examples include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Order (Sales) \u2194 Shipment<\/strong><\/li>\n\n\n\n<li><strong>Order (Sales) \u2194 Invoice<\/strong><\/li>\n\n\n\n<li><strong>Invoice \u2194 Credit Memo<\/strong><\/li>\n\n\n\n<li><strong>Business Partner \u2194 Customer Return<\/strong><\/li>\n\n\n\n<li><strong>Business Partner \u2194 Vendor Return<\/strong><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Each of these uses existing reference fields such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>C_Order_ID<\/code><\/li>\n\n\n\n<li><code>C_Invoice_ID<\/code><\/li>\n\n\n\n<li><code>M_InOut_ID<\/code><\/li>\n\n\n\n<li><code>C_BPartner_ID<\/code><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Users never need to configure these links manually during transactions. The relation type ensures the system understands and displays them correctly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How Users Experience Relation Types<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">End users usually do not interact with the relation type window directly. Instead, they experience its effect while working with documents.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When a relation type is correctly defined:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Users can jump from an <strong>Order<\/strong> to its <strong>Shipment<\/strong><\/li>\n\n\n\n<li>From a <strong>Shipment<\/strong> to its <strong>Invoice<\/strong><\/li>\n\n\n\n<li>From an <strong>Invoice<\/strong> to its <strong>Credit Memo<\/strong><\/li>\n\n\n\n<li>From a <strong>Business Partner<\/strong> to related returns or documents<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">All of this happens automatically through:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Toolbar navigation<\/li>\n\n\n\n<li>Right-click related records<\/li>\n\n\n\n<li>Zoom and drill-down actions<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What Happens If a Relation Type Is Missing or Incorrect?<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If a relation type is not defined or incorrectly mapped:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Related records may not appear<\/li>\n\n\n\n<li>Navigation between documents may be broken<\/li>\n\n\n\n<li>Users may need to manually search for linked records<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This does not affect data integrity, but it <strong>reduces usability and traceability<\/strong> across business documents.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For this reason, relation types are usually:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Delivered by default<\/li>\n\n\n\n<li>Maintained by system administrators<\/li>\n\n\n\n<li>Rarely changed unless extending the data model<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>When You Would Create or Adjust a Relation Type<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You typically work with relation types only when:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Adding custom tables or documents<\/li>\n\n\n\n<li>Extending standard flows<\/li>\n\n\n\n<li>Creating new document relationships<\/li>\n\n\n\n<li>Improving navigation for custom processes<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">In standard implementations, existing relation types already cover:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sales flow<\/li>\n\n\n\n<li>Purchase flow<\/li>\n\n\n\n<li>Logistics flow<\/li>\n\n\n\n<li>Returns and credit processes<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>A Relation type defines how two records in iDempiere are logically connected. It makes existing links visible and navigable in [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,10],"tags":[],"class_list":["post-17676","post","type-post","status-publish","format-standard","hentry","category-idempiere-master","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=17676"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17676\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=17676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=17676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=17676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}