{"id":20510,"date":"2026-08-04T12:03:01","date_gmt":"2026-08-04T12:03:01","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20510"},"modified":"2026-08-17T06:07:56","modified_gmt":"2026-08-17T06:07:56","slug":"how-to-configure-gl-journal-generator-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-gl-journal-generator-in-idempiere\/","title":{"rendered":"How to Configure GL Journal Generator in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Configure the GL Journal Generator in iDempiere to automate store journal entries from posted accounting transactions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Introduction<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The GL Journal Generator is an iDempiere configuration window that reads posted Fact_Acct balances from a Source account and its full sub-account tree, recalculates them using multiplier and rounding rules, and generates a new GL Journal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Businesses use it to automate recurring, rule-based entries such as inventory adjustments, fee allocations, and store-level reclassifications without manual journal entry.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Because the output posts directly to the general ledger, correct setup affects store-level P&amp;L accuracy, financial reporting, and month-end closing time.<\/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-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"265\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-GL-Journal-Generator-1-1024x265.png\" alt=\"\" class=\"wp-image-20810\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-GL-Journal-Generator-1-1024x265.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-GL-Journal-Generator-1-300x78.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-GL-Journal-Generator-1-768x199.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-GL-Journal-Generator-1-1536x397.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-GL-Journal-Generator-1-2048x530.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Source Amount is read from the Source&#8217;s Account Element and its entire account-tree of sub-accounts.<\/li>\n\n\n\n<li>Only Actual posting type, active, in-range Fact_Acct entries feed the calculation.<\/li>\n\n\n\n<li>Source Amount is SUM(Debit &#8211; Credit), grouped by the Generator Line&#8217;s configured dimensions.<\/li>\n\n\n\n<li>Multiplier and Round Factor apply twice: once at the Source, again at the Generator Line.<\/li>\n\n\n\n<li>Same Product groups and carries the Product dimension separately for each product.<\/li>\n\n\n\n<li>Type of BP Dimension controls Business Partner handling: Same, Fixed, or From Column.<\/li>\n\n\n\n<li>Copy All Dimensions carries every Accounting Schema dimension and overrides BP\/Product settings.<\/li>\n\n\n\n<li>Fact_Acct rows with no Business Partner are grouped into one blank-BP bucket, not per partner.<\/li>\n\n\n\n<li>Matching dimension groups from multiple Sources are combined into a single amount.<\/li>\n\n\n\n<li>Zero calculated amounts never generate an output journal line.<\/li>\n\n\n\n<li>Simulation mode calculates and logs results without creating or saving a GL Journal.<\/li>\n\n\n\n<li>An unbalanced journal is auto-balanced using the configured Adjustment DR\/CR accounts.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisites<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Accounting Schema configured for the tenant.<\/li>\n\n\n\n<li>Chart of Accounts structured correctly, since Source matching includes the full child-account tree.<\/li>\n\n\n\n<li>Document Type &#8220;GL Journal&#8221; configured.<\/li>\n\n\n\n<li>GL Category configured (e.g., Standard).<\/li>\n\n\n\n<li>Organization structure configured (e.g., Chennai Store).<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigation<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a><\/a><a><\/a> <strong>Menu \u2192 <\/strong><strong>Performance Analysis and Accounting<\/strong><strong> \u2192 GL Journal Generator<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Opening this window displays the Generator Header, with the Generator Line and Generator Source sub-tabs and a Generate GL Journal button used to run the process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Configuration Steps<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Define the GL Journal Generator Header<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Enter a Name and Description, select Document Type &#8220;GL Journal&#8221;, GL Category &#8220;Standard&#8221;, Posting Type &#8220;Actual&#8221;, and the Accounting Schema. Set Account Adjust DR\/CR for balancing.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Name<\/td><td>Inventory Adjustment Journal<\/td><td>Identifies the generator template<\/td><\/tr><tr><td>Document Type<\/td><td>GL Journal<\/td><td>Document type used for the generated journal<\/td><\/tr><tr><td>GL Category<\/td><td>Standard<\/td><td>Groups journal entries for reporting<\/td><\/tr><tr><td>Posting Type<\/td><td>Actual<\/td><td>Restricts source entries to actual postings<\/td><\/tr><tr><td>Accounting Schema<\/td><td>POTS UN\/38 Indian Rupee<\/td><td>Schema used for reading and posting amounts<\/td><\/tr><tr><td>Account Adjust DR<\/td><td>B_ASSET_Checking Account<\/td><td>Debit account used to balance the journal<\/td><\/tr><tr><td>Account Adjust CR<\/td><td>B_INTERESTEXP_Interest Expense<\/td><td>Credit account used to balance the journal<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"423\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-3-1024x423.png\" alt=\"\" class=\"wp-image-20512\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-3-1024x423.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-3-300x124.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-3-768x317.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-3-1536x635.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-3-2048x846.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Configure the Generator Line<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Add a Generator Line with a Sequence and Description. Select Account DR and Account CR. Choose either Copy All Dimensions, or set Type of BP Dimension and Same Product individually \u2014 not both approaches at once.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Sequence<\/td><td>10<\/td><td>Controls processing order of the line<\/td><\/tr><tr><td>Description<\/td><td>Inventory Adjustment Expense Entry<\/td><td>Explains the purpose of the line<\/td><\/tr><tr><td>Account DR<\/td><td>B_ASSET_Checking Account<\/td><td>Target Debit account for calculated amount<\/td><\/tr><tr><td>Account CR<\/td><td>B_INTERESTEXP_Interest Expense<\/td><td>Target Credit account for calculated amount<\/td><\/tr><tr><td>Type of BP Dimension<\/td><td>Same \/ Fixed \/ From Column \/ blank<\/td><td>Controls how Business Partner is assigned (ignored if Copy All Dimensions is checked)<\/td><\/tr><tr><td>Same Product<\/td><td>Checked<\/td><td>Groups and carries Product from the source entry<\/td><\/tr><tr><td>Copy All Dimensions<\/td><td>Unchecked<\/td><td>When checked, all Accounting Schema dimensions are copied instead of the two fields above<\/td><\/tr><tr><td>Multiplier Amount<\/td><td>1.0<\/td><td>Scales the combined source amount<\/td><\/tr><tr><td>Round Factor<\/td><td>0<\/td><td>Rounds the final calculated amount<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"590\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-1-1024x590.png\" alt=\"\" class=\"wp-image-20514\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-1-1024x590.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-1-300x173.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-1-768x443.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-1-1536x885.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-1-2048x1180.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>Type of BP Dimension \u2014 Options<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Option<\/strong><\/td><td><strong>Behavior<\/strong><\/td><td><strong>When to Use<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Same<\/td><td>Groups by the source row&#8217;s own Business Partner and carries it to the output<\/td><td>Source entries reliably carry a real Business Partner<\/td><\/tr><tr><td>Fixed<\/td><td>Ignores the source&#8217;s Business Partner; assigns one hard-coded BP to every output line<\/td><td>Consolidating many partners into one internal partner<\/td><\/tr><tr><td>From Column<\/td><td>Groups by a related record&#8217;s key, then resolves the BP from a column on that record<\/td><td>The real BP is reachable only through a linked record, not directly on Fact_Acct<\/td><\/tr><tr><td>Blank \/ none<\/td><td>Business Partner is not grouped by or carried at all<\/td><td>Source account never carries a meaningful Business Partner<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Configure Generator Source<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Under the Generator Line, add one or more Sources. Select the Account Element to read (a parent account matches its full subtree), an optional GL Category filter, and a Multiplier Amount or Round Factor if scaling is required.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Account Element<\/td><td>B_ASSET_Checking Account<\/td><td>Source account read from Fact_Acct, including all accounts below it in the tree<\/td><\/tr><tr><td>GL Category<\/td><td>Standard<\/td><td>Optional filter on source entries<\/td><\/tr><tr><td>Multiplier Amount<\/td><td>2.0<\/td><td>Scales the source amount before combining with other Sources<\/td><\/tr><tr><td>Round Factor<\/td><td>0<\/td><td>Rounds the source amount<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"623\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-2-1024x623.png\" alt=\"\" class=\"wp-image-20513\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-2-1024x623.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-2-300x183.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-2-768x467.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-2-1536x935.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-GLJournalGenerator-2-2048x1246.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Run the Generate GL Journal Process<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click Generate GL Journal, enter the Processing Date range and Accounting Date, set Simulation to Yes to preview first, then rerun with Simulation set to No and a Document Action.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Processing Date From<\/td><td>01-Jul-2026<\/td><td>Start date for selecting Fact_Acct entries<\/td><\/tr><tr><td>Processing Date To<\/td><td>31-Jul-2026<\/td><td>End date for selecting Fact_Acct entries<\/td><\/tr><tr><td>Accounting Date<\/td><td>31-Jul-2026<\/td><td>Accounting date of the created GL Journal<\/td><\/tr><tr><td>Simulation<\/td><td>Yes \/ No<\/td><td>Preview only, or create the GL Journal<\/td><\/tr><tr><td>Document Action<\/td><td>Prepare \/ Complete<\/td><td>Action applied to the generated journal<\/td><\/tr><tr><td>Business Partner<\/td><td>ABC Customer (optional)<\/td><td>Filters source entries by partner<\/td><\/tr><tr><td>Product<\/td><td>Product A (optional)<\/td><td>Filters source entries by product<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Note: <\/strong>In Simulation mode, the process log shows the resolved Account, Debit\/Credit amount, Business Partner, and Product for each calculated line \u2014 always review this before running with Simulation set to No.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>No journal lines generated<\/td><td>No matching Fact_Acct entries in the date range, schema, or account tree<\/td><td>Verify Processing Date range, Accounting Schema, and that the Source account tree contains posted entries<\/td><\/tr><tr><td>Source amount includes unexpected accounts<\/td><td>The Source&#8217;s Account Element matches its entire sub-account tree, not only the exact account<\/td><td>Point the Source at a leaf account, or review which child accounts sit under the selected parent<\/td><\/tr><tr><td>Journal is unbalanced and fails posting<\/td><td>Adjustment DR\/CR accounts not configured<\/td><td>Configure Account Adjust DR and Account Adjust CR at header level<\/td><\/tr><tr><td>Simulation shows amounts but no journal created<\/td><td>Simulation parameter left as Yes<\/td><td>Rerun the process with Simulation set to No<\/td><\/tr><tr><td>Generated journal fails to complete<\/td><td>Accounting period closed or invalid Document Action<\/td><td>Confirm the accounting period is open before processing<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next Steps<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Confirm the GL Journal Document Type and numbering sequence.<\/li>\n\n\n\n<li>Review Chart of Accounts structure, since Sources match entire account subtrees.<\/li>\n\n\n\n<li>Verify GL Category setup used for reporting segmentation.<\/li>\n\n\n\n<li>Check Period Control status before running the process each month.<\/li>\n\n\n\n<li>Open the GL Journal window to review and post generated entries.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Configure the GL Journal Generator in iDempiere to automate store journal entries from posted accounting transactions. Introduction The GL Journal [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-20510","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20510","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20510"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20510\/revisions"}],"predecessor-version":[{"id":29638,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20510\/revisions\/29638"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}