How Does Invoice Transactions (Acct) Report Works in iDempiere

The Invoice Transactions (Acct) Report provides a detailed list of invoice transactions based on the Accounting Date. It displays invoice documents together with accounting information, customer details, payment information, and invoice amounts for the selected accounting period. The report helps users verify invoices that have been posted to the General Ledger and supports financial reconciliation and accounting verification. It is commonly used by the Finance, Accounts, and Audit teams during period-end closing, financial reporting, and accounting analysis.

Business Rules

• Retrieves invoice transaction information from the RV_C_Invoice database view.
• Displays invoice records based on the selected Accounting Date range.
• Allows users to filter records by Organization and Sales Transaction.
• Supports both Sales and Purchase invoice transactions.
• Displays accounting-related information including Accounting Date, Document Number, and Document Status.
• Retrieves Business Partner information associated with each invoice.
• Displays payment information such as Payment Rule and Payment Terms.
• Shows financial values including Charge Amount, Total Lines, and Grand Total.
• Displays only records that match the selected report parameters.
• Provides a transaction-level accounting report for financial verification, reconciliation, and audit purposes.

Report Parameters

Parameter Window

The Invoice Transactions (Acct) Report parameter window allows users to filter invoice records before generating the report.

Invoice Transactions (Acct) Report – Parameter Window

Parameter	Purpose	Filtering Behavior	Sample Value
Organization	Choose Organization	Filters by organization.	POTS Chennai Store
From Account Date	Choose From Accounting Date	Filters from selected accounting date.	07/01/2026
To Account Date	Choose To Accounting Date	Filters up to selected accounting date.	07/31/2026
Sales Transaction	Show Sales Transactions Only	Shows Sales or Purchase invoices.	Checked
Run as Job	Run report in background	Runs report as background job.	Checked

Report Output

The report provides a detailed list of invoice transactions based on the selected accounting period. It displays accounting information together with invoice details, customer information, payment details, and financial amounts. Users can verify invoices posted to the accounting system, review accounting transactions, and reconcile financial records before period closing. The report is useful for accounting verification, financial auditing, General Ledger reconciliation, and statutory reporting.

The report displays information such as:

• Organization
• Accounting Date
• Invoice Number (Document No)
• Invoice Date
• Business Partner
• Payment Rule
• Document Status
• Charge Amount
• Total Lines
• Grand Total
• Currency
• Sales Transaction
• Sales Representative
• Business Partner Information
• Description (if available)

This report enables users to analyze invoice transactions from an accounting perspective and ensures that only invoices posted within the selected accounting period are included in the report.