Purpose

The following guide is intended for employees who are looking to view or complete any of the following actions:

· Answer business questions using the AR Aging Detail Report in Accounts Receivable Data Hub in Oracle

Terminology

· Customer Organization Name: Custom identifying field to identify organizations associated with the project.

· Customer Name: Name of the customer. The values are hyperlinked to a page for further review of customer information.

· Accounting Flexfield: The chart of accounts (COA) string related to the Accounts Receivable transaction.

Business Questions

· Does a particular invoice have an outstanding amount remaining? If so, how much is owed? How overdue is the amount owed?

· Utilize the filters to narrow the report to a specified invoice

· View the Outstanding Amount column for the outstanding amount remaining and how much is owed

· View the Days Outstanding column for how long the invoice has been outstanding

· What were the payment terms on a given invoice for a particular customer?

· Utilize the filters to narrow the report to a specified customer and the invoice number

· View the Payment Terms column for the payment terms on a given invoice

· For a given customer, how many invoices make up their outstanding amount?

· Utilize the filters to narrow the report to a specified customer

· The table is at the invoice level and therefore each row represents an invoice

· Count the number of rows for the specified customer for the amount of invoices that make up their outstanding amount

Report Preview