A/R Aging Report
This report shows all the open invoices (invoices having balance) "As Of" a given date i.e. any activity that occurred after the given date is not reflected in results. The transactions (invoices, payments, credits, adjustments etc.) with transaction date less than or equal to "As of Date" are considered irrespective of whether the batches containing those transactions are closed or not. The balance of an invoice is considered in aging periods of current (less than 30 days), 30-60 days, 61-90 days, 91-120 days and over 120 days. The aging period is arrived at by subtracting Due Date of an Invoice from "As Of Date".
Note: For terms greater than 0, the invoice will remain in the current column for the length of the term + 30 days.
Report Parameters
Selected report parameter information displays below the title of the report.
Parameter Name | Required | Description |
---|---|---|
Business Unit | Required |
Choose the specified business unit you want to run this report on from the drop-down list. |
As of (mm/dd/yyyy) | Required |
Choose the specified as of date you want to run this report on from the date text box. Note: Defaults to system date. Invoices and other transactions with transaction date less than or equal to this date are selected. |
Product Type | Optional | Choose the specified product type you want to run this report on from the drop-down list. |
Group by GL? | Optional | When checked, report results are grouped by General Ledger account. |
Report Fields
This report can produce output in a browser window (HTML) containing the following information:
Column Name | Description |
---|---|
Invoice |
Lists the invoice number. |
PO |
Lists the purchase order number. |
Date |
Lists the invoice transaction date. |
Batch | Lists the batch number. |
Product | Lists the product type. |
Current 30 - Over 120 | Lists the balance due in one of the aging periods (current, 30-60, 61-90, 91-120, Over 120 days) . |
Total | Lists the total amounts for each aging period and the total for the report. |