Trade Payables
Unpaid supplier invoices and how old they are: the outstanding balance per purchase invoice for each supplier as of a date. The report for scheduling payments.
Questions It Answers
- Which supplier invoices are unpaid, and for how many days?
- What is the total owed to supplier X at month end?
- Which payables are past their terms and must be paid this week?
Filters
| Filter | What it does |
|---|---|
| Date | Position as of a date (up to and including), not a range. Empty means today. |
| Supplier | One supplier only; pre-filled from the role's default when set. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Payable Balance | Filter by remainder: > 0 hides invoices already settled. Without it, zero-balance invoices are listed too. |
| Accounts Payable Aging | Filter by age in days: >=, >, or between. |
How To Read It
| Column | Meaning |
|---|---|
| Supplier Code, Name, Address | The supplier; its rows are that supplier's invoices. |
| Purchase Invoice, Purchase Date | Invoices that still carry a balance. |
| Payment Term | Cash, Cash on Delivery, or Credit - the payment type on the invoice header. |
| Payable | Remainder: invoice value minus every payment, return, and adjustment up to the filter date, in the default currency. |
| Aging | Days between the filter date and the invoice date. The footer shows the average age. |
Why The Numbers May Differ
- This is the payable ledger, not purchases: a cash invoice settled immediately leaves no payable.
- Age counts from the invoice date, not the due date.
- Foreign-currency payables are converted at the invoice rate.
- Payments recorded after the filter date do not reduce the balance - this is a position as of a date.
- Supplier prepayments do not reduce the payable here until used on an invoice - see Supplier Prepayment Balance.
- Unlike Supplier History, which lists every transaction with a supplier (purchases, returns, payments), this report shows only the invoices that are still unpaid and how old they are - it is the report to open for unpaid supplier invoices and their age.
Menu Location
- Procurement / Purchase Reports / Trade Payables
/report/repsupplierbalance