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.0809.31 15 and newer
| Table of Contents | ||||
|---|---|---|---|---|
|
...
Toolbar Icons | Description | ||||||||
| Excel |
| ||||||||
| Favorites |
| ||||||||
| Help |
| ||||||||
| Inquiry Criteria |
| ||||||||
| |||||||||
| Refresh |
| ||||||||
| Grid Layout |
| ||||||||
| 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 |
Database Field: ERPx_MFTransactionBatch.BatchID | ||||||||
| Checkbook |
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 |
Database Field: ERPx_APVendorClass.ClassID | ||||||||
| Date |
Database Field: ERPx_MFCheckbookTransaction.GLDate | ||||||||
| Description | Shows the text of the memo line of the payment if one exists. | ||||||||
| GL Period |
| ||||||||
| GL Year |
| ||||||||
| 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 NameThe 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. Linked 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. 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:
Database Field: ERPx ERPx_MFModuleTransaction.ModuleTransactionSK WHERE ModuleSK = 1 /*System*/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 |
Database Field: ERPx_MFCheckbookTransaction.TransactionStatusSK |
...