How Does Aging Report Work In iDempiere
The Aging report shows who owes money to the business (customers) and who the business owes money to (vendors), grouped by how late each amount is. Instead of just listing unpaid invoices, it sorts them into simple age groups, like not due yet, 1-7 days late, 31-60 days late, or 91+ days late, so users can quickly see how serious the outstanding balances are.
Finance and Accounts Receivable/Payable teams use this report to spot overdue customer payments, plan upcoming vendor payments, and get a quick sense of overall outstanding balances.
Business Rules
- Every time the report runs, it builds a fresh list of unpaid invoices based on the filters the user picks, such as the statement date, currency, or business partner.
- Each invoice, or each installment if the invoice is split into parts, is checked to see how much is still owed and how many days past its due date it is.
- That amount is placed into the right age group — current, or 1-7, 8-30, 31-60, 61-90, or 91+ days overdue — so users can see totals for each age range.
- The Sales Transaction flag shows whether the row is a customer invoice (money owed to the business) or a vendor invoice (money the business owes).
- The List Invoices option lets users see every invoice individually, or just totals per business partner.
- If a Convert Amount in Currency is chosen, all amounts are converted into one currency so balances in different currencies can be added up together.
- The report only shows data for the user’s own company and organization, and can also be grouped by business partner group.
- The report is read-only — it only displays existing information and doesn’t create, change, or delete any records.
Report Parameters
The Aging parameter window allows users to filter open balances before generating the report. Users can select the Statement Date, Account Date, Sales Transaction, Currency, Convert Amount in Currency, Business Partner Group, Organization, Business Partner, and whether to list invoices individually.
| Parameter | Purpose | Filtering Behavior | Sample Data |
| Statement Date | Sets the date the aging is calculated as of. | Displays open balances aged as of the selected date. | 07/22/2026 |
| Account Date | Chooses whether aging is based on the accounting date instead of the due date. | Displays open balances aged using the selected date basis. | No |
| Sales Transaction | Selects whether to show customer invoices, vendor invoices, or both. | Displays open balances matching the selected transaction type. | Yes (Sales) |
| Currency | Selects the invoice currency to include. | Displays open balances recorded in the selected currency. | INR |
| Convert Amount in Currency | Selects a currency to convert all displayed amounts into. | Displays open balances converted into the selected currency. | USD |
| Business Partner Group | Selects the business partner group to include. | Displays open balances for business partners in the selected group. | Retail Customers |
| Organization | Selects the organization the invoices belong to. | Displays open balances for the selected organization. | HQ Office |
| Business Partner | Selects a specific customer or vendor. | Displays open balances for the selected business partner. | Alpha Retail Solutions |
| List Invoices | Chooses whether to show each invoice individually or summarize by business partner. | Displays invoice-level detail when checked, or partner totals when unchecked. | Yes |
Report Output
- The Aging report displays one row per business partner, or per invoice when List Invoices is selected, showing the open balance broken down by aging bucket.
The report includes the business partner, business partner group, organization, currency, sales transaction, statement date, due date, days due, invoiced amount, open amount, past due amount, due amount, and the individual past-due and not-yet-due aging buckets (1-7, 8-30, 31-60, 61-90, 91+ days, and their not-yet-due equivalents). It helps users see overall outstanding exposure and prioritize follow-up on the oldest balances.
