Versions Compared

Version Old Version 1 New Version 2
Changes made by

Tom Williams

Tom Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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

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.
Toolbar IconsDescription
Excel
Insert excerpt
Excel - Global
Excel - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout
Grid Layout
nopaneltrue
Help
Insert excerpt
Help - Global Icon
Help - Global Icon
nopaneltrue
Inquiry CriteriaMore Actions - Global
nopaneltrue

Insert excerpt
Inquiry Criteria - Global
Inquiry Criteria - Global
nopaneltrue

  • 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 Balances as of From: a text box to enter a starting GL Date. If entered, this must be in a valid date formatdate for reconciliation transactions. A blank assumes All.  
  • GL Date Balances as of To: a text box to enter an ending GL Date. If entered, this must be in a valid date formatdate for reconciliation transactions. 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
Insert excerpt
More Actions - Global
  • 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".
Print
Insert excerpt
Print - Global
Print - Global
nopaneltrue
Refresh
Insert excerpt
Refresh - GlobalRefresh - Global
nopaneltrue
View Applications
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
Insert excerpt
Checkbook - List View/Inquiry Field
Checkbook - List View/Inquiry Field
nopaneltrue
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
Insert excerpt
Checkbook Description - List View/Inquiry Field
Checkbook Description - List View/Inquiry Field
nopaneltrue
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

Insert excerpt
GL Date - List View/Inquiry Field
GL Date - List View/Inquiry Field
nopaneltrue

Linked Database Field: ERPx_

GL Period
Insert excerpt
GL Period - List View/Inquiry Field
GL Period - List View/Inquiry Field
nopaneltrue
GL Year
Insert excerpt
GL Year - List View/Inquiry Field
GL Year - List View/Inquiry Field
nopaneltrue
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
Insert excerpt
Status - List View/Inquiry Field
Status - List View/Inquiry Field
nopaneltrue
ERPx_MFCheckbookTransaction.TransactionStatusSK
Trans. Date
Insert excerpt
Doc Date - List View/Inquiry Field
Doc Date - List View/Inquiry Field
nopaneltrue
ERPx_MFCheckbookTransaction.TransactionDate
Transaction

Insert excerpt
Trans. ID - List View/Inquiry Field
Trans. ID - List View/Inquiry Field
nopaneltrue
 

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*/

...