The Daily Invoice Report provides a summary of sales or purchase invoices generated each day in iDempiere. It helps users monitor daily invoice amounts, discounts, and sales activity by sales representative.

The report is mainly used by Sales, Finance, and Management teams to review daily invoicing performance and analyze invoice values based on the selected report parameters.

Business Rules

• The report retrieves data from the RV_C_Invoice_Day database view.
• The report summarizes invoice information day-wise.
• Invoice amounts are grouped by Organization, Sales Representative, Invoice Date, and Transaction Type.
• The report supports both Sales and Purchase invoices based on the IsSOTrx transaction type.
• The report calculates the total Net Amount, List Amount, Limit Amount, Discount Amount, and Over Limit Amount for each day.
• The Discount Percentage is calculated from the List Amount and Net Amount.
• The Over Limit Percentage is calculated from the Net Amount and Over Limit Amount.
• Users can filter the report using the available report parameters.
• The report displays summarized invoice information and does not modify any business data.
• Based on the available implementation, the report retrieves data directly from the RV_C_Invoice_Day Report View and does not use a custom Java process.

Report Parameters

Daily Invoice Report – Parameter Window

The Daily Invoice Report parameter window allows users to filter invoice records before generating the report. Users can select values such as Sales Representative, Invoice Date, and Sales Transaction to display only the invoice summary matching the selected criteria.

Parameter	Purpose	Filtering Behavior	Sample Data
Date Invoiced	Selects the invoice date.	Displays invoice summaries for the selected date or date range.	07/01/2026
Sales Transaction	Selects Sales or Purchase invoices.	Checked displays Sales invoices; unchecked displays Purchase invoices.	Yes
Sales Representative	Selects a sales representative.	Displays invoice summaries for the selected sales representative.	Anand Menon
Run as Job	Runs the report in the background.	Generates the report as a background job.	NO

Report Output

• The Daily Invoice Report displays summarized invoice information for each day based on the selected report parameters. Each record represents the total invoice values for a specific day.

The report includes important information such as Invoice Date, Sales Representative, Net Amount, List Amount, Discount Amount, Discount Percentage, Over Limit Amount, and Over Limit Percentage.

It helps users review daily invoice performance, compare invoice values, and analyze daily sales or purchase activities.