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 20 Next »

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. 

(lightbulb) Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

HelpOpens the online WIKI help page for the current page. 

(lightbulb) 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: 

  • 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 filtered by default. 
  • Date From: a text box to enter a Start Date. This defaults to 60 days ago. 
  • Date To: a text box to enter an End Date. This default to 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.
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 '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.
VoidOpens 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

DescriptionShows 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 SourceIdentifies 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:

  • ACH
  • Check

Linked Database Field: ERPx_MFModuleTransaction.ModuleTransactionSK WHERE ModuleSK = 1 /*System*/

Printed DateIdentifies 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 TransA 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


 Page Definitions


 Technical Details


Stored Procedures:











  • No labels