How to Configure Report Line Set in iDempiere

Introduction

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.

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.

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.

Process Flow Diagram

Business Rules

• Report Line Set Name is mandatory and stored per Organization.
• Only Active Report Line Sets appear when building a Financial Report.
• Report Lines execute top to bottom based on the Sequence value.
• Line Type determines whether a line is Blank, Segment Value, or Calculation.
• Printed flag controls whether a Report Line appears on the printed report output.
• Show Opposite Sign reverses the natural debit or credit sign for display.
• Multiplier and Round Factor adjust calculated amounts, useful for percentage lines.
• A Report Source record requires an Element Type before it can be saved.
• Multiple Report Source records can feed accounting data into a single Report Line.
• Report Line Set and its lines are Client and Organization scoped.

Prerequisites

• Organization configured.
• Accounting Schema and Chart of Accounts configured.
• Role granted access to the Performance Analysis menu.
• Report Column Set configured (required later to build the actual Financial Report).

Navigation

Menu → Performance Analysis and Accounting → Financial Reporting → Report Line Set

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.

Configuration Steps

Step 1: Create the Report Line Set Header

The header record is the container that groups all the lines making up a report’s row structure.

Instructions

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.

Field	Sample Value	Description
Name	Test	Unique label identifying the report structure
Description	(optional)	Free text describing the purpose of the set
Active	Checked	Makes the Report Line Set available for use

Step 2: Add Report Lines to the Set

Each Report Line defines one row of the report and controls how that row behaves and displays.

Instructions

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.

Field	Sample	Purpose
Sequence	10	Sets the display order of the line within the set
Line Type	Blank line	Defines line behavior (Blank Line, Segment Value, Calculation)
Printed	Checked	Includes the line in the printed report output
Show Opposite Sign	Unchecked	Reverses the sign for display when checked
Multiplier	(optional)	Scales the calculated result, e.g. for percentage lines
Round Factor	(optional)	Rounds the calculated amount to a chosen unit

Step 3: Configure Report Source for Calculated Lines

Report Source tells iDempiere which accounting elements to read data from for Account Range or Calculated line types.

Instructions

On the Report Line, open Report Source, click New, select the Element Type, choose Organization scope options, define the Account Element range, then Save.

Field	Sample	Purpose
Organization	CDC	Restricts the data source to a specific Organization
Element Type	Account	Defines which accounting element the source reads
Account Element	(selected range)	Specific account or account range used for the line

Common Issues and Resolutions

Issue	Cause	Resolution
Save fails with “null value in column elementtype”	Element Type not selected before saving Report Source	Select a valid Element Type (e.g. Account) before saving
New Report Line Set not visible in Financial Report	Active checkbox left unchecked	Reopen the record and mark it Active
Report Lines print in the wrong order	Duplicate or unordered Sequence values	Assign unique, increasing Sequence numbers to each line
Calculated line shows zero or blank	Report Source not linked to the correct Account Element	Verify the Account Element range on Report Source
Percentage line shows an incorrect value	Multiplier or Round Factor left blank	Set Multiplier (e.g. 100) and Round Factor as needed
Line missing from the printed report	Printed checkbox unchecked	Enable Printed on the Report Line
Sign appears reversed on the report	Show Opposite Sign set incorrectly	Toggle Show Opposite Sign to match expected presentation
Report Line Set not selectable for another Organization	Record created under the wrong Organization	Recreate or reassign the record under the correct Organization

Next Steps

• Configure Report Column Set to define report columns (Actual, Budget, Variance).
• Build the Financial Report window linking this Report Line Set and Report Column Set.
• Verify Accounting Schema and Chart of Accounts alignment for accurate data.