{"id":20612,"date":"2026-07-14T11:56:17","date_gmt":"2026-07-14T11:56:17","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20612"},"modified":"2026-10-23T11:56:54","modified_gmt":"2026-10-23T11:56:54","slug":"how-to-configure-report-line-set-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-report-line-set-in-idempiere\/","title":{"rendered":"How to Configure Report Line Set in iDempiere"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Introduction<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Report Line Set is a core Performance Analysis window in iDempiere used to define the row structure of a financial report, such as a Profit and Loss or Balance Sheet statement. Each Report Line Set groups multiple Report Lines in a defined sequence.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is used by Finance and Accounting teams during financial reporting setup, working together with Report Column Set inside the Financial Report Writer, rather than in day-to-day transaction entry.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Every Report Line and its underlying Report Source determine which accounting data appears on each row, directly shaping the accuracy and layout of the generated financial statement.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Process Flow Diagram<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Report-Line-Set.drawio-1024x231.png\" alt=\"\" class=\"wp-image-20613\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Report-Line-Set.drawio-1024x231.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Report-Line-Set.drawio-300x68.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Report-Line-Set.drawio-768x174.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Report-Line-Set.drawio-1536x347.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Report-Line-Set.drawio-2048x463.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">B<strong>usiness Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Report Line Set Name is mandatory and stored per Organization.<\/li>\n\n\n\n<li>Only Active Report Line Sets appear when building a Financial Report.<\/li>\n\n\n\n<li>Report Lines execute top to bottom based on the Sequence value.<\/li>\n\n\n\n<li>Line Type determines whether a line is Blank, Segment Value, or Calculation.<\/li>\n\n\n\n<li>Printed flag controls whether a Report Line appears on the printed report output.<\/li>\n\n\n\n<li>Show Opposite Sign reverses the natural debit or credit sign for display.<\/li>\n\n\n\n<li>Multiplier and Round Factor adjust calculated amounts, useful for percentage lines.<\/li>\n\n\n\n<li>A Report Source record requires an Element Type before it can be saved.<\/li>\n\n\n\n<li>Multiple Report Source records can feed accounting data into a single Report Line.<\/li>\n\n\n\n<li>Report Line Set and its lines are Client and Organization scoped.<\/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>Organization configured.<\/li>\n\n\n\n<li>Accounting Schema and Chart of Accounts configured.<\/li>\n\n\n\n<li>Role granted access to the Performance Analysis menu.<\/li>\n\n\n\n<li>Report Column Set configured (required later to build the actual Financial Report).<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigation<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Menu \u2192 Performance Analysis and Accounting \u2192 Financial Reporting \u2192 Report Line Set<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-1-1024x546.png\" alt=\"TenthPlanet-iDempiere-Accounting-ReportLineSet-1\" class=\"wp-image-20614\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-1-1024x546.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-1-300x160.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-1-768x410.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-1-1536x819.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-1-2048x1092.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Opening the window displays the Report Line Set header tab with Name, Description and Active fields, and a Report Line sub-tab listing the lines belonging to the set.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-2-1024x546.png\" alt=\"TenthPlanet-iDempiere-Accounting-ReportLineSet-2\" class=\"wp-image-20615\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-2-1024x546.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-2-300x160.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-2-768x410.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-2-1536x819.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-2-2048x1092.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\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: Create the Report Line Set Header<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The header record is the container that groups all the lines making up a report&#8217;s row structure.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open Report Line Set, click New, enter a Name, add an optional Description, keep Active checked, then Save. This record becomes the parent for all Report Lines added next.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"391\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-3-1024x391.png\" alt=\"TenthPlanet-iDempiere-Accounting-ReportLineSet-3\" class=\"wp-image-20616\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-3-1024x391.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-3-300x115.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-3-768x293.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-3-1536x587.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-3-2048x782.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><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>Test<\/td><td>Unique label identifying the report structure<\/td><\/tr><tr><td>Description<\/td><td>(optional)<\/td><td>Free text describing the purpose of the set<\/td><\/tr><tr><td>Active<\/td><td>Checked<\/td><td>Makes the Report Line Set available for use<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Add Report Lines to the Set<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Each Report Line defines one row of the report and controls how that row behaves and displays.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">In the Report Line tab, click New, enter a Name, set Sequence to control row order, choose a Line Type, and tick Printed if the row should appear on output, then Save.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"595\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-4-1024x595.png\" alt=\"TenthPlanet-iDempiere-Accounting-ReportLineSet-4\" class=\"wp-image-20617\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-4-1024x595.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-4-300x174.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-4-768x446.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-4-1536x893.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-4-2048x1190.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Sequence<\/td><td>10<\/td><td>Sets the display order of the line within the set<\/td><\/tr><tr><td>Line Type<\/td><td>Blank line<\/td><td>Defines line behavior (Blank Line, Segment Value, Calculation)<\/td><\/tr><tr><td>Printed<\/td><td>Checked<\/td><td>Includes the line in the printed report output<\/td><\/tr><tr><td>Show Opposite Sign<\/td><td>Unchecked<\/td><td>Reverses the sign for display when checked<\/td><\/tr><tr><td>Multiplier<\/td><td>(optional)<\/td><td>Scales the calculated result, e.g. for percentage lines<\/td><\/tr><tr><td>Round Factor<\/td><td>(optional)<\/td><td>Rounds the calculated amount to a chosen unit<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Configure Report Source for Calculated Lines<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Report Source tells iDempiere which accounting elements to read data from for Account Range or Calculated line types.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">On the Report Line, open Report Source, click New, select the Element Type, choose Organization scope options, define the Account Element range, then Save.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"442\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-5-1024x442.png\" alt=\"\" class=\"wp-image-20618\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-5-1024x442.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-5-300x129.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-5-768x332.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-5-1536x663.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-ReportLineSet-5-2048x884.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Organization<\/td><td>CDC<\/td><td>Restricts the data source to a specific Organization<\/td><\/tr><tr><td>Element Type<\/td><td>Account<\/td><td>Defines which accounting element the source reads<\/td><\/tr><tr><td>Account Element<\/td><td>(selected range)<\/td><td>Specific account or account range used for the line<\/td><\/tr><\/tbody><\/table><\/figure>\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 is-style-stripes\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Save fails with &#8220;null value in column elementtype&#8221;<\/td><td>Element Type not selected before saving Report Source<\/td><td>Select a valid Element Type (e.g. Account) before saving<\/td><\/tr><tr><td>New Report Line Set not visible in Financial Report<\/td><td>Active checkbox left unchecked<\/td><td>Reopen the record and mark it Active<\/td><\/tr><tr><td>Report Lines print in the wrong order<\/td><td>Duplicate or unordered Sequence values<\/td><td>Assign unique, increasing Sequence numbers to each line<\/td><\/tr><tr><td>Calculated line shows zero or blank<\/td><td>Report Source not linked to the correct Account Element<\/td><td>Verify the Account Element range on Report Source<\/td><\/tr><tr><td>Percentage line shows an incorrect value<\/td><td>Multiplier or Round Factor left blank<\/td><td>Set Multiplier (e.g. 100) and Round Factor as needed<\/td><\/tr><tr><td>Line missing from the printed report<\/td><td>Printed checkbox unchecked<\/td><td>Enable Printed on the Report Line<\/td><\/tr><tr><td>Sign appears reversed on the report<\/td><td>Show Opposite Sign set incorrectly<\/td><td>Toggle Show Opposite Sign to match expected presentation<\/td><\/tr><tr><td>Report Line Set not selectable for another Organization<\/td><td>Record created under the wrong Organization<\/td><td>Recreate or reassign the record under the correct Organization<\/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>Configure Report Column Set to define report columns (Actual, Budget, Variance).<\/li>\n\n\n\n<li>Build the Financial Report window linking this Report Line Set and Report Column Set.<\/li>\n\n\n\n<li>Verify Accounting Schema and Chart of Accounts alignment for accurate data.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"epyt-video-wrapper\"><iframe loading=\"lazy\"  id=\"_ytid_43686\"  width=\"800\" height=\"450\"  data-origwidth=\"800\" data-origheight=\"450\"  data-relstop=\"1\" src=\"https:\/\/www.youtube.com\/embed\/XBkSL12ZtbE\">https:\/\/www.youtube.com\/watch?enablejsapi=1&autoplay=0&cc_load_policy=0&cc_lang_pref=&iv_load_policy=1&loop=0&rel=0&fs=1&playsinline=0&autohide=2&theme=dark&color=red&controls=1&disablekb=0&\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Report Line Set is a core Performance Analysis window in iDempiere used to define the row structure of a [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20612","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\/20612","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=20612"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20612\/revisions"}],"predecessor-version":[{"id":29958,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20612\/revisions\/29958"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}