How does Payment Details Report works in iDempiere

The Payment Details report provides detailed information about payments and receipts recorded in iDempiere. It displays each payment transaction along with its bank account, business partner, document type, and allocation status.

The report is mainly used by Finance, Accounts Receivable/Payable, and Management teams to review payments and receipts, verify bank account activity, and track which payments have been allocated to invoices.

Business Rules

• The report retrieves data from the RV_Payment report view.
• The report combines payment, receipt, bank account, business partner, and document type information into a single report.
• Each record represents a single payment or receipt transaction.
• Payment amount, discount amount, write-off amount, tax amount, and over/under amount are automatically sign-adjusted based on transaction type: receipts are shown as positive amounts, while payments are shown as negative amounts.
• The report calculates the allocated amount and available amount for each payment using the payment allocation functions, so users can see how much of a payment has been applied to invoices.
• The report includes bank account, business partner, document type, currency, tender type, and document status details for each payment.
• The report is read-only and does not create or update payment data.
• Based on the available implementation, the report retrieves data directly from the RV_Payment report view without using a custom Java process.

Report Parameters

Payment Details – Parameter window

The Payment Details parameter window allows users to filter payment records before generating the report. Users can select Bank Account, Business Partner, Document Type, and Allocated to display only the payment records that match the selected criteria.

Parameter	Purpose	Filtering Behavior	Sample Data
Bank Account	Selects the bank account used for the payment.	Displays payment records for the selected bank account.	POS Cash Account
Business Partner	Selects the business partner associated with the payment.	Displays payment records for the selected business partner.	Alpha Retail Solutions
Document Type	Selects the payment document type.	Displays payment records for the selected document type.	AR Receipts
Allocated	Filters by whether the payment has been allocated to an invoice.	Displays payment records matching the selected allocation status.	Yes

Report Output

• The Payment Details report displays one row per payment or receipt transaction. Each row shows the transaction amount signed according to whether it is a payment or a receipt, along with its allocation and availability status.

The report includes the document number, transaction date, bank account, business partner, document type, payment amount, discount amount, write-off amount, tax amount, allocated amount, available amount, tender type, and document status. It helps users track payment activity and reconcile which payments are still open for allocation.