Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

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. 

(lightbulb) 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
PrintOpens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. 
RefreshRe-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 LayoutOpens 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).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

View ApplicationsOpens 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 NameThe 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 TypeThe 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_#####.#####.
CheckbookThe 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 CurrencyThe 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 TransactionA 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 NameThe 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 BatchA 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 ByA 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 ThruA 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  
ReferenceA 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 TypeA label to identify the type of transaction. This is not editable. Linked Database Field: ERPx_#####.#####.
TransactionA 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


 Page Definitions


 Technical Details


Stored Procedures:











  • No labels