UNMATCHED MANUAL ADJUSTMENTS

Use this non-editable subtask to view the adjustments detail in which the G/L and bank statement amounts differ for the bank abbreviation, fiscal year, and period displayed in the screen header. The detail rows in this table window include both G/L and bank amounts.

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

When you open the Unmatched Manual Adjustments 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.

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 have entered Manual Adjustments in the Accept Bank Transactions screen that match the selection criteria.

You must have also compared G/L transactions to bank transactions by clearing checks in the Accept Bank Transactions screen and/or using the Process Batch 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 inquiry screen

G/L Pd Ending Date, Bank Statement Ending Date

The G/L period ending date for the period that was selected in the main inquiry screen 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 in the main screen automatically displays in the screen header and cannot be edited.

Table Window

The Unmatched Manual Adjustments table window displays the following non-editable data columns:

Trans Type

Trans Date

Trans No

Trans Crncy G/L Amount

Func Crncy G/L Amount

Trans Crncy Bank Amount

Trans Crncy Variance Amt

Bank Accpt Date

Bank Accpt FY

Bank Accpt Pd

Bank Accpt Subpd

Trans ID

Trans Name

Transaction Description

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 Trans 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.

Trans Total Bank Amount

This field displays the sum of all values from the Trans Crncy Bank Amount column.

Trans Total Variance Amount

This field displays the sum of all values from the Trans Crncy Variance Amount column.