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
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:
|
More Actions | Displays a drop down menu of related actions. The list of options includes: From this page users can:
|
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. |
Fields | Description |
---|---|
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:
|
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_#####.#####. |
Related Topics
Account Balance Summary Inquiry