Accounts Receivable Reports

Overview

In addition to the reports described below, Payment History and Outstanding Invoice reports are available. They are part of the Contracts & Grants Billing (CGB) functionality, but are available when the CGB is not turned on. 

Customer Aging Report

Returns a report showing how long invoices from each customer have been outstanding. The last two buckes of the Aging Report is set with parameter LAST_TWO_BUCKETS. 

A Processing or Billing Chart and Org or Account Number must be entered. Enter additional search criteria as desired. Click Search to return results that match search criteria. 

Click on any amount to open the Customer Open Item Report. 

Following are a list of reports available in the Accounts Receivable module. 

Customer History Report

Returns all Accounts Receivable activity for a customer.

This report is accessed from the Customer Lookup. 

Click on the Report link to open the Customer History Report. 

The Customer History Report shows the history of activity for the selected customer. Invoices, Payment Applications, Payment Application Adjustments, Credit Memos and Invoice Write Offs. 

The Unpaid column lists INV/CINV unpaid amounts. The Unapplied column lists and APP/APPA unapplied amounts.

Click on an Unpaid amount to open the Customer Open Item Report. 

Click on an Unapplied amount to open the Unapplied Amount Report. 

Customer Invoice Report

Allows you to generate a print file of customer invoices by billing organization, processing organization or user ID.