The Aging Detail report allows you to print a list of outstanding invoices and unapplied cash.
On the Filters tab select if you want to only view Unpaid As Of and if so then select the Date or Period.
The Unpaid As Of option allows you to report on invoices posted to the General Ledger. The Date filter searches based on General Ledger journal dates. Any invoices posted when the Interface with General Ledger option is turned off do not show on this report when the Unpaid As Of option is used.
Select the Invoice Date range from which you want to view your detail report. Additional date filters may appear depending on what option you choose.
Select if you want to Include Paid Invoices. You have several additional options to narrow down your selections:
•Divisions: There is a filter for each division you have set up in Preferences.
If you filter by Customer, unapplied cash does not show up on the report. This is because unapplied cash is only tied to the Bill To.
On the Options tab select if you want to Include Invoice Distributions. Select this option to include items, item descriptions,and item amounts from the invoice detail on the report. You can also select additional options:
•Print Setup Information
•Print Bill To Address and Phone
•Print Customer Number
For each Bill To each payment or invoice is displayed on a line with the following columns:
•Invoice #/Item: The item is included if the option to Include Invoice Distributions is selected.
•Revenue Center/Item Description: The item description is included if the option to Include Invoice Distributions is selected.
•Amount: A positive amount indicates an invoice and a negative amount indicates a payment.
Under the detail for each bill to there is a row containing the following columns:
•Current: The total amount that is currently due (not overdue).
•31-60 Days: The total amount that is 31-60 days overdue.
•61-90 Days: The total amount that is 61-90 days overdue.
•91-120 Days: The total amount that is 91-120 days overdue.
•121 & Over: The total amount that is 121 or more days overdue.
•Total: The total of the previous columns minus any unapplied cash.
If you are using the Unpaid As Of option, all of the columns shown on this report are based on the date or period selected as opposed to the current date.
Any unapplied cash for the bill to displays as Total Unapplied Cash underneath the row described above.
After all of the detail is the Aging Detail Report Recap. This includes the following:
•Totals by Revenue Centers: Columns for Current, 31-60 Days, 61-90 Days, 91-120 Days, 121 & Over, and Total are displayed for each revenue center along with any Unapplied Cash. The Total amount is adjusted by any unapplied cash for that revenue center.
•Totals by Sources: Columns for Current, 31-60 Days, 61-90 Days, 91-120 Days, 121 & Over, and Total are displayed for each source along with any Unapplied Cash. The Total amount is adjusted by any unapplied cash for that source.
•Item Recap: Columns for Item, Item Description, and Total are displayed for each item. If the option to Include Paid Invoices is selected on the Filters tab the total Sales Tax (if applicable), Total, Less Payments, and Net are also displayed at the bottom of the recap.
Click the Run Report button to generate a preview of the report.
•Click the Clear Preferences link to reset all of your report preferences to their default values.
•Click the Close Report button to return to the dashboard.
The report displays on the Report Preview page. Refer to the Report Preview help page for more information.