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

Version 1 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.
  • GL Period From: a text box to enter a starting GL Period as [GL Period]-[GL Year] (e.g. 01-2020). A blank assumes All.
  • GL Period To: a text box to enter an ending GL Period as [GL Period]-[GL Year] (e.g. 01-2020). A blank assumes All.
  • GL Date From: a text box to enter a starting GL Date. If entered, this must be in a valid date format. A blank assumes All.  
  • GL Date To: a text box to enter an ending GL Date. If entered, this must be in a valid date format. A blank assumes All.  
  • Transaction Date From: a text box to enter a starting Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
  • Transaction Date To: a text box to enter an ending Transaction Date. If entered, this must be in a valid date format. A blank assumes All. 
  • Status: a multi-select check box to limit the data that is returned to one or more selected Statuses. Options include: Open, Posted, & Void/Replaced. Open includes transactions in a Status of "New" and "Approved". Posted includes transactions in a Status of "Ready to Post" and "Posted". Void/Replaced includes transactions in a Status of "Void" or "Replaced". The default value is "Posted".
  • Reconciliation Group: a multi-select check box to limit the data that is returned to one or more selected Reconciliation Groups (Deposit, Payment, or Adjustment) . A blank assumes All.
  • Transaction Type: a multi-select check box to limit the data that is returned to one or more selected Transaction Types. A blank assumes All.
  • Reconciled: a multi-select Yes/No lookup to limit the data that is returned based on whether the transactions are reconciled or not. 

Need to discuss with Dev on how to do default values.

More Actions

Displays a drop down menu of related actions. The list of options includes:

Need to discuss with Dev on whether or not this should be included in Phase 1.

PrintOpens 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. 

View Applications

Opens the View Applications window. This will only work when a single record with a 'Transaction Type' of "Payment" is selected.

Need to discuss with Dev on whether or not this should be included in Phase 1.

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