Aged Trial Balance
Use this report to view detailed information about the current status on open items for a customer or supplier. The amount due is listed by aging categories to provide an overall picture of invoices that are open on the customer or supplier’s account.
- Print the report by customer to view an overview of outstanding receivables balances. This report is useful for managing collections and achieving an efficient receivables turnaround.
- Print the report grouped by supplier to view an overview of paid and outstanding open items. This report is useful to make payment decisions.
Prerequisites
List of criteria
| Parameter |
Parameter title |
Type |
|---|---|---|
|
asofdate |
As of Date |
D |
|
societe |
Company |
|
|
ledger |
Ledger (Local menu Legal, Analytical, IAS, Ledger 4, Ledger 5...) |
|
|
sitedeb |
Site range |
|
|
coldeb |
Range of collective account |
SAC |
|
tiersdeb |
BP range |
|
|
datebase |
Date basis for aging (Local menu Age by invoice date, Age by due date) |
|
|
bprtype |
BP type (Local menu Customer, Supplier) |
|
|
summary |
Summary (Local menu No, Yes) |
|
|
namesort |
Sort by name (Local menu No, Yes) |
|
|
txncur |
Transaction currency (Local menu No, Yes) |
Comments
The data is filtered by site according to the rights granted to the user on the function RPT09 (Print/group/acct ).
Description of the report
The report details include business partner, type, references, days old, base date, and not due. The report totals by business partner and aging totals based on the 0-30, 31-60, 61-90, and over 91 days buckets.
The report filters include the as-of date, site, collective, business partner, date basis for aging (invoice or due date), summary, sort option, and transaction currency.