A/R Aging Report

Reports Central: Accounting --> Invoice

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.