The RF Accounts Receivable Invoices in Formal Collection report provides operating locations and central office staff with a comprehensive tool to review the collection status of invoices in "formal collection" by the Research Foundation, central office. Detailed collection actions are captured in the Oracle Accounts Receivable (AR) module through call entries recorded on the outstanding AR invoice. The Research Foundation (RF) customized the RF Accounts Receivable Invoices in Formal Collection report to provide operating locations with a tool to access status information on items in formal collection directly.
The default sort order for this report is by Customer. Data produced is based on security access. In addition, a summary of parameters selected is provided at the beginning of the report.
This report should be reviewed monthly and as needed for updates on the status of Accounts Receivable Invoices in Formal Collection at Central Office.
The following table describes the required and optional parameters to use to run the report:
Parameters |
Description |
||
Required Parameter |
|||
Print Completed Actions |
The option to include or exclude customer contact records that have been flagged as complete. The default value is Y. |
||
Optional Parameters |
|||
Call Date |
The date of the last call made for the corresponding AR invoice. |
||
Customer Name |
The customer name that is associated with the award for which the AR invoice was generated. |
||
Location |
The three-digit operating location code assigned to the award that generated the associated invoice. Note: Central office staff with appropriate security access may leave this field blank to display all invoices in formal collection. |
||
Print Collector |
Displays the collector's name. Selection values are Y for Yes or N for No. The default value is Y. |
||
Print Location |
The option to print the three-digit location code assigned to the award that generated the associated invoice. The default value is N. |
||
Print Call ID |
The option to print the Call ID number. The default value is Y. |
||
The following table describes the report output:
Column Heading |
Description of Column |
Invoice |
Accounts Receivable invoice number, the invoice number that the Accounts Receivables (AR) module assigns once an invoice is approved and released -or the invoice number that is assigned to an advance invoice created in AR. This number only prints if information is entered through the Call Topics window. |
Award |
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. This number only prints if information is entered through the Call Topics window. |
Loc |
A three-digit location operating location code assigned to the award that generated the associated invoice. |
Due Date |
The due date based on the billing terms of the award and the invoice release date. |
Call Date |
The date the last call action was taken. |
Follow Up Date |
The date follow up action should be taken if populated in the Call Topics window. |
Call ID |
The number assigned to the call record in AR. |
Collector |
If "Y" is selected, then the collector entered in the Customer Calls window is displayed. |
Flag |
If the Complete check box is checked, this field displays the Customer Contact Records that are completed. |
Notes |
This field displays any additional notes that the user entered through the Call Topics window. |
Effective Date: 5/16/2007 11:55:51 AM