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 Icons	Description
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".
Print	Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed.
Fields	Description
Balance as of	Identifies the date that the 'Bank Balance' was calculated thru for the reconciliation. This would be the statement date if reconciling from a bank statement. This defaults to blank but is required before any transactions can be added to the Grid. This date must be <= the 'Transaction Cutoff' date but it is not required to be in an open fiscal period.
Checkbook	Error rendering macro 'excerpt-include' : No link could be created for 'Checkbook - List View/Inquiry Field'.
Checkbook Currency	The Currency ID of the 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 Adjustments	Identifies the sum of all the Adjustment transactions that were included on the reconciliation, in the checkbook's currency, displayed in the currency format.
Cleared Deposits	Identifies the sum of all the deposit transactions (Deposits and Transfer: Receipt transactions) that were included on the reconciliation, in the checkbook's currency, displayed in the currency format.
Cleared Payments	Identifies the sum of all the payment transactions (Payments and Transfer: Sent transactions) that were included on the reconciliation, in the checkbook's currency, displayed in the currency format.
Created	Error rendering macro 'excerpt-include' : No link could be created for 'Created (Date & Time) - List View/Inquiry'.
Created By	Error rendering macro 'excerpt-include' : No link could be created for 'Created By- List View / Inquiry'.
Last Updated	Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated (Date & Time) - List View/Inquiry'.
Last Updated By	Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated By - List View/Inquiry'.
Reconcile to Balance	Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation was targeting.
Status	Error rendering macro 'excerpt-include' : No link could be created for 'Status - List View/Inquiry Field'. ERPx_
Transaction	Error rendering macro 'excerpt-include' : No link could be created for 'Trans. ID - List View/Inquiry Field'. Linked Database Field: ERPx_

Page Header

Related Topics

Page Definitions

Technical Details