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 Summary Report in the Accounts Receivable Data Hub in Oracle

Terminology

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

· Aging Buckets: Time periods grouped into buckets based on the elapsed time since the invoice was overdue. Used to help gauge the quality of a company’s receivables.

Business Questions

· Which customer currently owes us the most money?

· Confirm the report is in Interactive mode

· If not: Click the drop-down menu in the top right corner of the table and click Interactive (Above the table, not the report)

· Select the arrow in the Outstanding Amount column

· Select Sort Descending

· View the first row in the Customer Organization Name, Customer Account Description, and Customer Account Number columns for customer information on the customer who owes the most money

· The report is sorted to have the customer with the largest outstanding amount at the top of the table

· View the first row of the Outstanding Amount column for the amount owed

· How much in total do we currently have outstanding?

· View the last row in the Outstanding Amount column

· This row shows summed values for the columns

· How much of our amount owed is in each aging bucket?

· View the 31-60, 61-90, 91-120, 121-150, 151-180, and 181+ columns to see the amounts in each aging bucket

· The columns refer to the days outstanding

Report Preview