The purpose of the Checkbook Register inquiry is to show all the transactions that impact the checkbook balance. From here, users can open transactions, view applications for payments, and void/reverse transactions. No data can be edited directly in this Inquiry.

Software Version: YYYY.MM.DD and newer

Page Header

Fields	Description
Toolbar Icons	Description
Excel	Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported.
Favorites	Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
Inquiry Criteria	Opens Inquiry Criteria window where users can define the following criteria: Checkbook: a multi-select list showing all active checkbooks. All are selected by default GL Period: a multi-select list showing all GL Periods. All are selected by default GL Year: a text box that allows entry of one 4-digit GL Year to limit the data by. Nothing is selected by default Date From: a date control used to filter the records returned. By default this is set to 60 days ago. Date To: a date control used to filter the records returned. By default this is blank which assumes all records up to the current date. Status: a multi-select list showing all applicable transaction statues. NEw, Approved, Ready to Post, and Posted are selected by default Transaction Type: a multi-select list showing all applicable checkbook transactions. All are selected by default. Reconciled: a multi-select list showing both Yes and No. Both values are selected by default.
More Actions	Displays a drop down menu of related actions. The list of options includes: Void Payments Void/Reverse Transactions
Print	Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed.
Refresh	Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria.
Grid Layout	Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). The bolded view is the default view, which will determine the view will automatically display in when opened.
View Applications	Opens the Payment Application Details window for the selected payment transaction. If more than one payment record is select, the window will be open for the first one. This window will only open for payment transactions.
Account ID	The Account ID (Vendor ID) of the payee. This is only populated for payment transactions and should be blank for all other transaction types. Linked Database Field: ERPx_#####.#####.
Account Name	The Account Name (Vendor Name) of the payee. This is only populated for payment transactions and should be blank for all other transaction types. Linked Database Field: ERPx_#####.#####.
Account Type	The Account Type (Vendor Type) of the payee. This is only be populated for payment transactions and should be blank for all other transaction types. The applicable values come from the APVendorType Enumeration Class. Linked Database Field: ERPx_#####.#####.
Checkbook	The Checkbook that the transaction is associated with. Linked Database Field: ERPx_#####.#####.
Checkbook Amount	The amount of the transaction. The value is formatted in the currency of the checkbook. This column has a grand total at the bottom. The grand total does not support currency formatting but rather is shown in 1,234.56 format. A positive amount reflects an increase to the checkbook balance and a negative amount reflects a decrease in the checkbook balance. Linked Database Field: ERPx_#####.#####.
Checkbook Currency	The Currency ID of the checkbook that the transaction is associated with. Linked Database Field: ERPx_#####.#####.
Checkbook Description	The Checkbook Description from the Checkbook that the transaction is associated with. Linked Database Field: ERPx_#####.#####.
Cleared Amount	The amount that was cleared during a bank reconciliation. This is only populated for transactions that have been reconciled and will be blank for all others. In most cases, the 'Cleared Amount' will match the 'Checkbook Amount'. This column has a grand total at the bottom. The grand total does not support currency formatting but rather is shown in 1,234.56 format. Linked Database Field: ERPx_#####.#####.
Cleared Variance	The calculated difference between the 'Checkbook Amount' and the 'Cleared Amount'. This is only populated for transactions that have been reconciled. If there is no variance then the amount shows as 0.00. This column has a grand total at the bottom. The grand total does not support currency formatting but rather is shown in 1,234.56 format. Linked Database Field: ERPx_#####.#####.
Comment	The Check Description field of a manual payment. This is only populated for manual payment transactions and should be blank for all other transaction types. Linked Database Field: ERPx_#####.#####.
GL Date	The date of the journal entry that was created by the transaction. Linked Database Field: ERPx_#####.#####.
GL Period	The GL Period associated with the GL Date of the journal entry that was created by the transaction. Linked Database Field: ERPx_#####.#####.
GL Year	The GL Year associated with the GL Date of the journal entry that was created by the transaction. Linked Database Field: ERPx_#####.#####.
Home Amount	The 'Amount' of the transaction converted to the 'Home Currency'. This is formatted in the home currency. This column has a grand total at the bottom. The grand total does not support currency formatting but rather is shown in 1,234.56 format. If the transaction has been reconciled this is calculated as the [Reconciled Amount] * [Transaction's Exchange Rate] otherwise it is calculated as the [Checkbook Amount] * [Transaction's Exchange Rate]. Linked Database Field: ERPx_#####.#####.
Originating Transaction	A hyperlink showing the Transaction ID of the originating/source transaction. This is only populated for reversal transactions. Clicking on the link opens the transaction. Linked Database Field: ERPx_#####.#####.
Payee Name	The Payee Name (Check Name) used on the payment. This is only populated for payment transactions and should be blank for all other transaction types. Linked Database Field: ERPx_#####.#####.
Reconciled	A Yes/No indicating whether the transaction has been reconciled. If Yes, the transaction has been reconciled, if No it has not. This is a calculated value that is not linked to a Database field.
Reconciled Batch	A label to identify the YYYYMMDDHHMMSS the batch was processed. This is an auto generated Batch ID that is only populated for transactions that have been reconciled and will be blank for all others. This is not editable. Linked Database Field: ERPx_#####.#####.
Reconciled By	A label to identify the name of the user that reconciled the Transaction. This is an auto generated value that is only populated for transactions that have been reconciled and will be blank for all others. It is generated as the user's [User First Name] + [User Last Name]. This is not editable. Linked Database Field: ERPx_#####.#####.
Reconciled Date	A label to identify the actual date the transaction was marked as reconciled. This is an auto generated value that is only populated for transactions that have been reconciled and will be blank for all others. This is not editable. Linked Database Field: ERPx_#####.#####.
Reconciled Thru	A label to identify the actual date the reconciliation was processed through. This is looked up from the reconciliation and is only populated for transactions that have been reconciled and will be blank for all others. This is not editable. Linked Database Field: ERPx_#####.#####.
Reconciliation Group	A label to identify how the transactions are grouped for Bank Reconciliation. This is an auto assigned value that is not editable nor is it linked to a Database Field. This is assigned as follows: Deposit: assigned to all Deposits, Transfer: Receipts, and positive adjustment transactions Payment: assigned to all Payments (checks, ACH, Wires, etc) and Transfer: Sent transactions Adjustment: assigned to all negative adjustment transactions
Reference	A label to identify the Reference (bank reference) of the transaction. This is not editable. Linked Database Field: ERPx_#####.#####.
Status	A label to show the Status of the transaction. This is not editable. Linked Database Field: ERPx_#####.#####.
Trans. Date	A label to show the date of the transaction. This is not editable. Linked Database Field: ERPx_#####.#####.
Transaction Type	A label to identify the type of transaction. This is not editable. Linked Database Field: ERPx_#####.#####.
Transaction	A hyperlink show the Transaction ID of the transaction. Clicking on the link opens the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####.

Checkbook Register Inquiry

Page Header

Toolbar Icons

Fields

Related Topics