Checkbook Register Inquiry
The purpose of the Checkbook Register inquiry is to show all the payments that have been made within a checkbook. Unlike the Checkbook Transaction Inquiry, this only shows individual payments and no other checkbook transactions. This also shows the individual ACH Payments, not the combined batch that was uploaded to the bank. From here, users can open the payment batch that included the payment, view the payment applications, void/reverse transactions, and open the Reconciliation transaction. No data can be edited directly in this Inquiry.
Software Version: 2023.09.15 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.
|
| Help | Opens the online WIKI help page for the current page.
|
| Inquiry Criteria | Opens Inquiry Criteria window where users can define the following criteria:
|
| 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).
|
| View Applications | Opens the 'Transaction Application Details' page for the selected payment transaction. If more than one payment record is select, the window will be open for the first one. |
| Void | Opens the 'Void Check' page for the selected payment transaction for the single record that was selected. If no records are selected, the message "Please select one item and try again." will be displayed. If more than one payment record is selected the message "Please limit your selection to one item and try again." will appear. |
Fields | Description |
|---|---|
| Account | The ID of the AP Vendor, Fisherman, or Loan the payment was made for. This is only populated for Payment records. Database Field: ERPx_APVendor.VendorID |
| Account Name | The Name of the AP Vendor, Fisherman, or Loan the payment was made for. This is only populated for Payment records. Database Field: ERPx_APVendor.VendorName |
| Amount | A text box to show the amount of the payment. 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. Database Field: If Cleared Amount exists, then the database field is ERPx_MFCheckbookTransaction.ReconciledAmount. Otherwise, the database field is ERPx_MFCheckbookTransaction.Amount. |
| Batch ID | Displays the name of the batch. from the Batch ID field on the Process Payments record view formatted as [User First Name] + [User Last Name] + [Batch Number + 1]. This field is required and is never editable by a user. Database Field: ERPx_MFTransactionBatch.BatchID |
| Checkbook | Identifies the Checkbook assigned to the transaction. Database Field: ERPx_MFCheckbook.CheckbookID |
| Checkbook Name | The Checkbook Description from the Checkbook that the transaction is associated with. Database Field: ERPx_MFCheckbook.CheckbookDescription |
| Class ID | Vendor Class IDs are used as a short description and unique identifier for Vendor Class records. Displays the ID from the Class associated with the Fisherman/Vendor account being paid. Database Field: ERPx_APVendorClass.ClassID |
| Date | Identifies the date the transaction posted (or will post) to the general ledger. Database Field: ERPx_MFCheckbookTransaction.GLDate |
| Description | Shows the text of the memo line of the payment if one exists. |
| GL Period | Identifies the Fiscal Period based on the GL date on the source transaction or manual journal entry. |
| GL Year | Identifies the Fiscal Year based on the GL date on the source transaction or manual journal entry. |
| Originated In | Identifies the system the payment originated in. This shows "NS" for payments that originated in NorthScope and the ID of the third-party application for payments that were imported from a third-party application. |
| Payee Address | Identifies the address used on the corresponding payment. This value is not required and only editable on the Process Payments Record View until the payment is printed. Database Field: ERPx_MFCheckbookTransaction.Address1, ERPx_MFCheckbookTransaction.Address2, ERPx_MFCheckbookTransaction.Address3 |
| Payee City | Identifies the City associated with the address used on the corresponding payment. This value is not required and only editable on the Process Payments Record View until the payment is printed. Database Field: ERPx_MFCheckbookTransaction.City |
| Payee Name | Identifies the name entered as the Payee on Payments. This is only populated for Payment records. This is most often the value in the 'Payment Name' field on the AP Vendor, Fishermen, or Loan account Address master file. Database Field: ERPx_MFCheckbookTransaction.PayeeName |
| Payee State | Identifies the State associated with the address used on the corresponding payment. This value is not required and only editable on the Process Payments Record View until the payment is printed. Database Field: ERPx_MFCheckbookTransaction.State |
| Payee Zip | Identifies the Zip code associated with the address used on the corresponding payment. This value is not required and only editable on the Process Payments Record View until the payment is printed. Database Field: ERPx_MFCheckbookTransaction.Zip |
| Payment # | A hyperlink that shows the Payment # (Check # or ACH Payment #). Clicking on the link opens the payment batch that included the payment. This field is not editable. Database Field: ERPx_MFCheckbookTransaction.TransactionID |
| Payment Source | Identifies the Functional Area used to create the Payment. This will either show Purchasing or Fisherman Accounting. |
| Payment Type | Identifies the type of payment. The options include:
Database Field: ERPx_MFCheckbookTransaction.TransactionTypeSK |
| Printed Date | Identifies the Date & Time the user clicked the Print Checks icon. |
| Reconciled | A Yes/No value to identify if the transaction has been reconciled. If "Yes" then the transaction has been reconciled, if "No", it has not. This is a looked-up value. |
| Reconciled Trans | A hyperlink that displays the system assigned Reconciliation Transaction ID. When clicked, the transaction record view of the Reconcile Transaction will open. This is a looked-up value. |
| Status | Identifies the Status of the transaction. Database Field: ERPx_MFCheckbookTransaction.TransactionStatusSK |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.Related Topics
Account Balance Summary Inquiry