RF Unapplied Receipts Register

Description

Purpose

The Oracle Accounts Receivable (AR) module maintains detailed information on cash receipts that have been applied to an invoice, a customer or could not be identified and remain unapplied. All receipts that are entered are entered to a receipt batch. The RF Unapplied Receipts Register report provides detailed information on unapplied receipts (not posted to an AR invoice on an award). The report will provide the receipt information including deposit date, batch name, location, amount, status and information entered in the Receipt Information Flex Field to assist in receipt identification. Unapplied receipts are displayed based on receipt batch, deposit date or location. This report is used to monitor receipts which have not been applied to invoices.

The report is sorted by batch and can be run for a specific batch, deposit or location.

Frequency

Run this report weekly or as needed to monitor unapplied or on account receipts.

Setting Report Parameters

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

Note: The RF Unapplied Receipts Register Report does not have required fields.


Parameters	Description (click in the field to see the List of Values)
Optional Parameters
Batch Name		The name of the receipt batch. Leave this field blank to view all unapplied receipts.
Deposit Date		The date of the deposit. Leave this field blank to view all unapplied receipts.
Location		The campus location. Leave this field blank to view all unapplied receipts.

Understanding the Output

The table that follows describe the report output:

Column Heading	Description of Column
Dep Date	The date that the receipt was deposited at the bank.
Batch Name	The name of the batch that the receipt was posted to.
Receipt No.	The identifying number or description given to the receipt.
Customer	The customer name associated with the receipt.
Award No.	The award number entered in the "Receipt Information" descriptive flex field. Note: Only valid award numbers can be entered.
Inv. No.	The invoice information entered in the "Receipt Information" descriptive flex field. Note: Only valid RF AR Invoice numbers should be used in this field to assist in accurate receipt posting.
Loc	The campus location entered in the "Receipt Information" descriptive flex field. Note: Only valid campus location numbers can be entered, for multiple location numbers use comments field.
Comments	Information entered in the Comments area of the "Receipt Information" descriptive flexfield. Comments are free-form text areas, so any information that many accompany the receipt and be useful for identification can be entered in this field.
Unapplied Amount	The amount of the receipt remaining unapplied.

Helpful Tips

For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and Export (TEXT) formats. PDF is a formatted, printable version and the Export version is easily exported into a Microsoft Excel spreadsheet.
For easy export to Excel, chose the RF Unapplied Receipts Register Export (TEXT) and change the 'Upon Completion' options by choosing the layout format Excel from the list of values and click 'Ok' twice. This will export the report direct into Excel upon completion.
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: 2/10/2009 9:12:28 AM