How Does Monthly Invoice Report Works in iDempiere

The Monthly Invoice report provides a monthly summary of invoice transactions. It helps finance and sales users review invoice values, discounts, and sales performance for a selected period.

The report summarizes invoice information by Organization, Sales Representative, Invoice Month, and Sales or Purchase Transaction, making it easier to analyze monthly invoice activity.

Business Rules

• Retrieves invoice data from the RV_C_InvoiceLine view.
• Groups invoice lines by Client, Organization, Sales Representative, Invoice Month, Sales Transaction, and Currency.
• Invoice Month is derived using the FirstOf(DateInvoiced,’MM’) function.
• Calculates Line Net Amount using the sum of LineNetAmt.
• Calculates Line List Amount using the sum of LineListAmt.
• Calculates Line Limit Amount using the sum of LineLimitAmt.
• Calculates Line Discount Amount using the sum of LineDiscountAmt.
• Calculates Discount % only when Line List Amount is greater than zero.
• Returns Discount % as zero when Line List Amount is zero.
• Calculates Line Over Limit Amount using the sum of LineOverLimitAmt.
• Calculates Over Limit % only when Line Net Amount is greater than zero.
• Returns Over Limit % as zero when Line Net Amount is zero.
• Rounds calculated percentages using the invoice currency.
• Uses IsSOTrx to distinguish Sales and Purchase transactions.

Report Parameters

Parameter Window

The Monthly Invoice Report parameter window allows users to filter invoice records before generating the report.

Monthy Invoice Report – Parameter Window

Parameter	Purpose	Filtering Behavior
From Date	Selects a customer or vendor.	Shows orders for the selected Business Partner.	01/01/2026
To Date	Selects a product.	Shows orders for the selected product.	07/20/2026
Sales Transaction	Selects Sales or Purchase Invoice.	Checked shows Sales Invoice unchecked shows Purchase Invoice.	No
Sales Rep	Select Sales Representative	Filtering Sales Representative Invoice Only Show	User Choose
Run as Job	Runs the report in the background.	Generates the report as a background job.	No

The report is executed using the selected parameter values to retrieve matching Sales Invoice records.

Report Output

• Displays monthly invoice summary records.
• Shows Organization, Sales Representative and Invoice Month.
• Displays Line Net Amount, Line List Amount and Line Limit Amount.
• Displays Line Discount Amount and Discount Percentage.
• Displays Line Over Limit Amount and Over Limit Percentage.
• Shows whether the transaction is Sales or Purchase.