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.02.28 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. |
Help | Opens the online WIKI help page for the current page. This icon is only visible on pages that are documented in the online help. |
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). The bolded view is the default view, which will determine the view will automatically display in when opened. |
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. Linked 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. Linked 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. Linked Database Field: If Cleared Amount exists, then the linked database field is ERPx_MFCheckbookTransaction.ReconciledAmount. Otherwise, the linked 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. Linked Database Field: ERPx_MFTransactionBatch.BatchID |
Checkbook | Identifies the Checkbook assigned to the transaction. Linked Database Field: ERPx_MFCheckbook.CheckbookID |
Checkbook Name | The Checkbook Description from the Checkbook that the transaction is associated with. Linked 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. Linked 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 Name | 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. Linked Database Field: ERPx_MFCheckbookTransaction.PayeeName |
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. Linked 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:
Linked Database Field: ERPx_MFModuleTransaction.ModuleTransactionSK WHERE ModuleSK = 1 /*System*/ |
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. Linked Database Field: ERPx_MFCheckbookTransaction.TransactionStatusSK |
Related Topics
Account Balance Summary Inquiry