Misc Transaction Report

Description

Purpose

The Miscellaneous Transactions Report provides the detail of cash receipts that have been applied directly to the general ledger, such as deposit date, batch name, and GL date. This report is used as a reconciliation tool for balancing cash activity to general ledger (GL) accounts in the Research Foundation (RF) of SUNY business system.

Miscellaneous transaction receipts are a type of cash receipt that is not associated with an award and therefore, not applied to an Accounts Receivable (AR) invoice.

A summary of parameters selected is provided at the beginning of the report. The report can be run for a specific receipt batch, deposit date or GL date (date the cash receipt was posted to the general ledger).

Frequency

Central office runs this report monthly to reconcile cash receipts posted directly to the GL..

Setting Report Parameters

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


Parameters	Description (click in the field to see the List of Values)
Required Parameters
Order By		Defines which field to use to sort the report. Select from Deposit Date or Batch Name.
Optional Parameters
Batch Name Low		The name of the cash receipt batch, starting from the top of the range These fields are numeric, alphabetic, or alphanumeric.
Batch Name High		The name of the cash receipt batch, starting from the bottom of the range These fields are numeric, alphabetic, or alphanumeric.
Deposit Date Low		The deposit date of the cash receipts, starting from the top of the range These fields are numeric.
Deposit Date High		The deposit date of the cash receipts, starting from the bottom of the range These fields are numeric.
Receipt GL Date Low		The General Ledger (GL) date of the cash receipts, starting from the top of the range These fields are numeric.
Receipt GL Date High		The General Ledger (GL) date of the cash receipts, starting from the bottom of the range These fields are numeric.
Receipt Number Low		The number assigned to the cash receipt, starting from the top of the range These fields are numeric, alphabetic, or alphanumeric.
Receipt Number High		The number assigned to the cash receipt, starting from the bottom of the range These fields are numeric, alphabetic, or alphanumeric.

Understanding the Output

The following table describes the report output:

Column Heading	Description of Column
Deposit Date	The date that the cash receipt was deposited to the bank.
Batch Source	Identifies how the cash receipt was received.
Batch Name	The name assigned to the batch of cash receipts.
GL Date	The General Ledger (GL) date that the receipt was posted to the general ledger.
Payment Number	The identifying number or description given to the cash receipt Example: the check number.
Payment Source	The payment source (that is, the payer) of the cash receipt
Payment Amount Accounting Flex Field	The specific General Ledger (GL) account to which the cash receipt is posted.
Percent	The distribution by percentage of the cash receipt application to the General Ledger (GL) account. Note: If the receipt is posted to more than one GL class, it will give the percent that was posted to each GL class.
Amount	The amount of the cash receipt distributed to the specific General Ledger (GL) account. Note: A single cash receipt may be distributed to multiple General Ledger (GL) accounts.

Helpful Tips

For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and ASCII (TEXT) format. PDF is a formatted, printable version. ASCII can be easily pulled into a spreadsheet or word processor.
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: 3/30/2007 11:26:46 AM