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.