{"id":18201,"date":"2026-01-30T12:32:12","date_gmt":"2026-01-30T12:32:12","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18201"},"modified":"2026-08-13T04:44:01","modified_gmt":"2026-08-13T04:44:01","slug":"how-gl-distribution-line-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-gl-distribution-line-works-in-idempiere\/","title":{"rendered":"How GL Distribution Line Works in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A <strong>GL <\/strong><strong>d<\/strong><strong>istribution <\/strong><strong>l<\/strong><strong>ine<\/strong> defines <strong>how much of an accounting amount is allocated<\/strong> and <strong>where it is posted<\/strong> when a GL Distribution rule is triggered.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each line represents a target accounting combination and a proportional share of the original posting amount. GL distribution lines do not operate independently. They are evaluated <strong>only when the parent GL <\/strong><strong>d<\/strong><strong>istribution header criteria are met<\/strong> during accounting posting.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"667\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Accounting-GLDistributionLine.png\" alt=\"\" class=\"wp-image-18204\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Accounting-GLDistributionLine.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Accounting-GLDistributionLine-300x195.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/01\/TenthPlanet-iDempiere-Accounting-GLDistributionLine-768x500.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Percentage and Remainder Handling Logic<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">GL distribution uses percentage-based allocation with strict validation rules.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The system follows these principles:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Percent values must be positive or left as null (0)<\/li>\n\n\n\n<li>Only one distribution line may have a 0 (null) percent<\/li>\n\n\n\n<li>A 0 percent line represents the \u201cremainder to 100%\u201d<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If the total of explicitly defined percentages is less than 100% and a 0 percent line exists, that line automatically receives the remaining amount. If no 0 percent line exists, any rounding difference caused by decimal precision is adjusted on the line with the largest calculated amount.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How the Distribution Is Applied During Posting<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once a posting matches a GL distribution rule, iDempiere performs the following steps:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First, the system suppresses the original posting to the matched account combination.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Next, it calculates the distribution amounts by prorating the original amount across the distribution lines based on their percentage values.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each calculated amount is then posted to the corresponding target account combination defined in the distribution lines.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This entire process happens automatically during posting and requires no manual intervention.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Validation and Control of GL Distributions<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A GL distribution must be marked as <strong>v<\/strong><strong>alid<\/strong> before it can be applied.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The typical setup process is:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Define the distribution header<\/li>\n\n\n\n<li>Enter distribution lines with percentage values<\/li>\n\n\n\n<li>Save the record<\/li>\n\n\n\n<li>Verify the distribution<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Distributions that are not validated are ignored during posting, ensuring incomplete or incorrect rules do not affect accounting results.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A GL distribution line defines how much of an accounting amount is allocated and where it is posted when a [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-18201","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18201","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=18201"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18201\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}