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

The purpose of the Checkbook Reconciliation Inquiry is to view Checkbook Reconciliations. All checkbook reconciliations, both open and posted can be viewed from here.

Software Version: YYYY.MM.DD and newer

Page Header

Toolbar IconsDescription
Excel
Error rendering macro 'excerpt-include' : No link could be created for 'Excel - Global'.
Grid Layout
Error rendering macro 'excerpt-include' : No link could be created for 'Grid Layout'.
Help
Error rendering macro 'excerpt-include' : No link could be created for 'Help - Global Icon'.
Inquiry Criteria

Opens Inquiry Criteria window where users can define the following criteria: 

  • Checkbook: a multi-select combo box to limit the data that is returned to one or more selected checkbooks. A blank assumes All.
  • Balances as of From: a text box to enter a starting date for reconciliation transactions. A blank assumes All.
  • Balances as of To: a text box to enter an ending date for reconciliation transactions. A blank assumes All.
  • Include Open Transactions: a Yes/No lookup to identify if the results include Open (unposted) reconciliation transactions. This defaults to "No" but can be changed to "Yes".
PrintOpens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. 
FieldsDescription
Account ID

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

Checkbook
Error rendering macro 'excerpt-include' : No link could be created for 'Checkbook - List View/Inquiry Field'.
Checkbook Amount

A text box to show the amount of the transaction, in the checkbook's currency, displayed in the currency format. This column has a grand total at the bottom. 

Amounts that DEBIT the Checkbook's Cash Account are displayed as positives and amounts that CREDIT the Checkbook's Cash Account are displayed as negatives. For example, deposits will be displayed as positive and Payments will be displayed as negative.

Linked Database Field: ERPx_MFCheckbookTransaction.Amount

Checkbook Currency

The Currency ID of the Checkbook. For Transfers, this will be the Currency assigned to the 'From Checkbook'.

Linked Database Field: ERPx_MFCheckbook.CurrencySK

Checkbook Description
Error rendering macro 'excerpt-include' : No link could be created for 'Checkbook Description - List View/Inquiry Field'.
Cleared Amount

The amount that cleared the bank. This is only populated for reconciled transactions. This column has a grand total at the bottom. 

Amounts that DEBIT the Checkbook's Cash Account are displayed as positives and amounts that CREDIT the Checkbook's Cash Account are displayed as negatives. For example, deposits will be displayed as positive and Payments will be displayed as negative.

The 'Cleared Amount' will always match the 'Checkbook Amount' unless the record cleared the bank for a different amount. The 'Cleared Amount' is the Checkbook's Currency amount, formatted in the checkbook's currency.

Linked Database Field: ERPx_MFCheckbookTransaction.ReconciledAmount

Comment

Displays the 'Comment' that was entered on the Transaction.

Linked Database Field: ERPx_MFCheckbookTransaction.Comment

GL Date

Error rendering macro 'excerpt-include' : No link could be created for 'GL Date - List View/Inquiry Field'.

Linked Database Field: ERPx_

GL Period
Error rendering macro 'excerpt-include' : No link could be created for 'GL Period - List View/Inquiry Field'.
GL Year
Error rendering macro 'excerpt-include' : No link could be created for 'GL Year - List View/Inquiry Field'.
Home Amount

The checkbook or  cleared amount converted to the Home Currency, and displayed in the home currency format, as follows:

  • If the transaction has been reconciled this is the 'Cleared Amount' converted to the Home Currency using the 'Transaction Date'.
  • If the transaction has not been reconciled this is the 'Checkbook Amount' converted to the Home Currency using the 'Transaction Date'.

This column displays a total at the bottom.

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 'Check Name' property on the AP Vendor, Fishermen, or Loan account master file.

Linked Database Field: ERPx_MFCheckbookTransaction.PayeeName

Payment SourceIdentifies which Functional Area the payment was made from. Payments made to AP Vendors will have a Payment Source of "Purchasing". Payments made to Fishermen or Loans will have a Source of "Fisherman Accounting".
Reconciled Batch

Identifies the batch that the transaction was reconciled in. Reconciliation Batch ID's are auto-assigned as [YYYYMMDDHHMMSS] the batch was processed. This is only populated for transactions that have been reconciled.

Linked Database Field: ERPx_

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.

Linked Database Field: ERPx_

Reconciled By

Identify the user that reconciled the batch. This is only populated for transactions that have been reconciled and is formatted to be the user's [User First Name] + [User Last Name]. This is a system assigned value that is not editable by a user.

Linked Database Field: ERPx_

Reconciled Date

Identifies the actual date the transaction was reconciled. This is a system assigned value that is not editable by a user.

Linked Database Field: ERPx_

Reconciled Thru

Identifies the last day of the bank statement being reconciled or the date the transactions were reconciled thru if not from a statement. This is manually entered on the Reconcile transaction.

Linked Database Field: ERPx_

Reconciliation Group

Identifies what group the transactions belong to on the Checkbook Reconciliation transaction. The groups are assigned as follows:

  • Deposit: for Deposits and Transfer "Receipt" transactions
  • Payment: for Checks/ACH payments and Transfer "Sent" transactions
  • Adjustment: for Adjustment transactions

Linked Database Field: ERPx_

Reference

Displays the Reference from the transaction record view. 

Linked Database Field: ERPx_MFCheckbookTransaction.Reference

Source Transaction

A hyperlink that displays the source transaction's Transaction #. This is only populated for Reversal transactions.

Linked Database Field: ERPx_

Status
Error rendering macro 'excerpt-include' : No link could be created for 'Status - List View/Inquiry Field'.
ERPx_MFCheckbookTransaction.TransactionStatusSK
Trans. Date
Error rendering macro 'excerpt-include' : No link could be created for 'Doc Date - List View/Inquiry Field'.
ERPx_MFCheckbookTransaction.TransactionDate
Transaction

Error rendering macro 'excerpt-include' : No link could be created for 'Trans. ID - List View/Inquiry Field'.
 

Linked Database Field: ERPx_MFCheckbookTransaction.TransactionID

Transaction Type

A text box to show the type of transaction. The options include:

  • Adjustment: Used to record miscellaneous increases or decreases in the checkbook balance. 
  • Deposit: Used to record deposits to the checkbook.  
  • Payment: Used to record outbound payments from the checkbook. This will have a reference to the 'Payment Type' (e.g. Payment: Check).
  • Transfer: Used to move funds from one checkbook to another. This will have a reference to which side the Transfer is (e.g. Transfer: Sent or Transfer Received). 
  • Reconciliation: Used to reconcile the checkbook balance with the bank's balance 

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

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details

  • No labels