CASH RECEIPTS PER BOOKS

Use this non-editable subtask to view the cash receipts detail transactions per the General Ledger for the bank abbreviation, fiscal year, and period displayed in the screen header. The detail rows in this table window include both cleared and outstanding C/R transactions (Code = "CLR" and/or "OUT").

Row data in the table window is pulled from the Bank Transactions History table.

When you open the Cash Receipts Per Books subtask, all detail transactions automatically fill the table window. The Count display in the menu bar indicates the total number of detail transactions. You can use the Subquery function from the menu bar to select parameters for viewing a subset of the detail records, if desired.

As an alternative to viewing the information in this subtask, you can print the transactions detail information from the Bank Reconciliation Detail Reports screen.

The detail transactions that display in this screen are pulled from existing data in the Bank Transactions History table. Before you can view data in this screen, you must first run the Create Bank Transactions History process. (The detail G/L transactions that were copied from the A/P, C/R, and/or P/R tables to the Bank Transactions History table can be viewed, matched to bank transactions, and cleared or uncleared in the Accept Bank Transactions screen.)

Bank Abbr, Currency, Fiscal Year, Pd

These non-editable fields display the bank abbreviation and description, currency, fiscal year, and period that were selected in the main screen.

G/L Pd Ending Date, Bank Statement Ending Date

The G/L period ending date for the selected period automatically displays in the screen header and cannot be edited.

The bank statement ending date set up in the Maintain Bank Statement Info screen for the fiscal year and period selected automatically displays in the screen header and cannot be edited.

Table Window

The Cash Receipts Per Books table window displays the following non-editable columns:

Trans Type ("CR")

Code ("CLR" and/or "OUT")

Receipt Date

Receipt No

Transaction Description

Deposit Number

Trans Crncy G/L Amount

Func Crncy G/L Amount

Cash Account

Cash Organization

Ref 1 (if Ref 1 is used)

Ref 2 (if Ref 2 is used)

Trans Total G/L Amount

This field displays the sum of all values from the Trns Crncy G/L Amount column.

Func Total G/L Amount

This field displays the sum of all values from the Func Crncy G/L Amount column.