Cheque Query

The Cheque Query routine allows the user to view a list of all Cheques that have been generated, according to a specific General Ledger Account. Details for each cheque (i.e. Journal Type and Number, Payee, Amount, etc) and the Cheque Status (i.e. Reconciled, Reversed) are displayed.

When accessed from the eQuinox main menu, the screen shown below will be displayed.

Field Definition

Cheque Query

Sorting Order
Before executing a query, the user must select the way in which the query results will be displayed. To display the information in ascending order, the user must select the Ascending option; to display the information in descending order, the user must select the Descending option.

By
From the drop-down list provided, the user must select the value by which the information is sorted (i.e. ascending/descending by Cheque Number, ascending/descending by Cheque ID, etc). Valid options are Cheque Number, Cheque ID, Journal Type, Journal Number, Bank number, Bank Name, Transaction date, Payee, Cheque Amount, description, or Status.

GL Account No, Bank Name
The user must enter the number of the General Ledger Account for which they wish to view cheque information. The corresponding Bank Name will automatically be displayed. Once the query is executed, all cheques written against this account will be displayed in the screen section seen below.

Cheque Query

The information in this section is for display purposes only and cannot be edited or updated by the user. However, the user can use this section for entering query criteria (i.e. to return all Cheques will a number of 12, press F7, enter 12 in the Cheque No field, and then press F8 to execute the query).

JN Type, JN No
The Journal Type and Number associated with the current cheque record (i.e. the type identifies the routine through which the cheque was generated, and the number identifies the batch to which the cheque belongs).

Cheque ID
The unique identifier of the cheque, used to identify and track the cheque in the system. This number is automatically assigned when the cheque is entered into the system.

Cheque No
The number of the cheque, as appears on the cheque itself.

Tran Date
The date on which the current cheque was generated.

Payee
The name of the person/company to whom the current cheque was made payable.

Amount
The total dollar amount of the cheque.

Description
A description of the current cheque, as entered when the cheque was entered into the system.

Rev, Rcn'd
The status of the current cheque (i.e. if the Rev field is "checked", the current Check has been reversed; if the Rcn'd field is "checked", the current Cheque has been reconciled; if neither field is "checked", the Cheque has yet to be reconciled).

Cheque Detail
To view details for a specific cheque, the user must either double click the Journal Type field in that record, or select that record and then click the Cheque Detail button. A sub-screen will be displayed, allowing the user to view details for the current cheque.