How Does Open Items (Aging) Report Works In iDempiere

The Open Items (Aging) report shows all invoices that are still unpaid, and how overdue each one is. It helps users see, how much money is still outstanding and how long it has been due, whether that money is owed to the business or by the business.

Finance and Accounts Receivable/Payable teams use this report to chase overdue customer payments, plan vendor payments, and keep track of how collections are progressing.

Business Rules

• The report is built from the RV_OpenItem view, which only includes invoices that are still unpaid (IsPaid = ‘N’), have a remaining open amount, and are Completed or Closed.
• Most invoices are paid in one go, so they appear as a single line using the invoice’s own payment term to work out the due date and days overdue. Invoices that are split into installments (a payment schedule) instead appear as one line per installment, each with its own due date and open amount.
• The Due Date is calculated from the invoice date and payment term (or, for installments, from the payment schedule), and Days Due shows how many days past that due date the item is — a positive number means it is overdue.
• A Discount Date and Discount Amount are also calculated, showing the early-payment discount the customer or vendor could still claim if paid before that date.
• The Open Amount is the portion of the invoice (or installment) that is still unpaid, calculated by subtracting what has already been paid from the total amount due.
• The Sales Transaction flag shows whether the open item is a customer invoice (money the business is owed) or a vendor invoice (money the business owes).
• Each invoice also carries a collection status, which reflects where it stands in the collection or dunning process, letting users see which items may need follow-up.

Report Parameters

The Open Items (Aging) parameter window allows users to filter open items before generating the report. Users can select Business Partner, Sales Transaction, Days Due, and Collection Status to display only the items that match the selected criteria.

Parameter	Purpose	Filtering Behavior	Sample Data
Business Partner	Selects the customer or vendor associated with the open item.	Displays open items for the selected business partner.	Alpha Retail Solutions
Sales Transaction	Selects whether to show customer invoices, vendor invoices, or both.	Displays open items matching the selected transaction type.	Yes (Sales)
Days Due	Sets how many days overdue (or not yet due) an item must be to appear.	Displays open items matching the selected days-due range.
Collection Status	Selects the collection or dunning stage of the invoice.	Displays open items matching the selected collection status.

Report Output

• The Open Items (Aging) report displays one row per unpaid invoice or installment, showing how much is still owed and how overdue it is.

The report includes the document number, business partner, sales transaction, invoice date, due date, days due, discount date, discount amount, grand total, paid amount, open amount, currency, collection status, and document status. It helps users track outstanding receivables and payables and prioritize follow-up on overdue items.