RF Aging – 7 Bucket Report

Description

Purpose

Oracle Accounts Receivable (AR) module maintains detailed information on AR invoices that have been paid in full or have an outstanding balance due. The Research Foundation (RF) customized the Aging – 7 Bucket Report to provide the total outstanding AR invoices based on a location, customer, and/or balance due for a specified date.

This report is sorted by customer. Customer subtotals are displayed each section.

A summary of parameters selected is provided at the beginning of the report. This report is used to monitor open AR invoices that have amounts past due and to determine appropriate action with the sponsor (e.g., collection call to sponsor, dunning letter, etc.).

Frequency

Run this report monthly and as needed for review by staff responsible for resolving outstanding balances on AR invoices.

Responsibilities with Access

ORG AR Inquiry
ORG AR Billing Specialist

Setting Report Parameters

The following table describes the required and optional parameters to use to run the report:


Parameters	Description (click in the field to see the List of Values)
Required Parameters
Order By	The report's default sort order is by customer.
Summary Type	The type of summary for the report. Select from: Invoice Summary - displays information on all of the customers' debit items. Customer Summary - displays the customers' names and a total debit amount.
Report Format	The format of the report. Select from: Brief - displays the customer name with item information. Detailed - displays the customer name, item information, as well as contact and address information.
As Of Date	Date that the report uses to calculate whether an invoice meets the past due criteria. The default is the current date.
Bucket Name	The Standard Bucket is the only bucket defined.
Show On Account	This parameter is for On Account receipts.
Optional Parameters
Customer Name Low	The customer name that is associated with the award that the AR invoice was generated for, starting with the top of the alphabetical range.
Customer Name High	The customer name that is associated with the award that the AR invoice was generated for, starting with the bottom of the alphabetical range.
Balance Due Low	The outstanding balance, starting with the top of the range. Note: For all outstanding balances, leave this field blank.
Balance Due High	The outstanding balance, starting with the bottom of the range. Note: For all outstanding balances, leave this field blank.
Location	Three-digit location code assigned to a campus (operating location). Security will limit location access.

Understanding the Output

The following table describes the report output:

Column Heading	Description of Column
Invoice Number	Accounts Receivable invoice number. The invoice number that Accounts Receivable assigns once an invoice is approved and released or the invoice number that is assigned to an advance invoice created in AR.
Due Date	The date that the payment is due, based on the billing terms of the award and the invoice date.
Award Number	A unique sequential number assigned to an award. An award is the record established from the award notice or contract received from a customer. An award record contains a funding source (customer), award amounts (funds), start and end dates, terms and conditions, and other information. Awards are used to fund one or more projects.
Org Code	The three-digit location number assigned to a campus (operating location).
Days Late	The number of days the invoice is past due based on the billing terms of the award.
% Unpaid	The percentage of the original invoiced amount that remains unpaid.
Outstanding Amount	The total outstanding amount on the invoice.
Current Amount Past Due	The amount remaining outstanding, either above or below the original invoice amount.
1-30 Days Past Due	The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.
31-60 Days Past Due	The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.
61-90 Days Past Due	The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.
91-180 Days Past Due	The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.
181-360 Days Past Due	The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.
360+ Days Past Due	The amount past due by the specified number of days, based on the billing terms of the award and the invoice date.

Helpful Tips

For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and ASCII (TEXT) format. PDF is a formatted, printable version. ASCII can be easily pulled into a spreadsheet or word processor.
Once you select a format and run the report, you cannot change the output format. You will need to run the report again and select the desired output format on the Submit Request window.

Effective Date: 3/19/2007 9:35:10 AM