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: 2020.01.13 and newer
| Toolbar Icons | Description |
|---|---|
| Delete |
|
| Excel | |
| Grid Layout | |
| Help | |
| Inquiry Criteria |
|
| 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. |
| 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 | |
| Checkbook Currency | The Currency ID of the Checkbook. Linked Database Field: ERPx_MFCheckbook.CurrencySK |
| Checkbook Description | |
| 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 | |
| Created By | |
| Last Updated | |
| Last Updated By | |
| Reconcile to Balance | Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation was targeting. |
| Status | Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK |
| Transaction |
Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID |
Page Definitions |
Technical Details |
Deleting a Reconciliation does not impact the general ledger, it just un-assigns the checkbook transactions that were on the reconciliation and removes the reconciliation from history. Users can delete the last reconciliation for a checkbook with no restrictions. However, if a reconciliation is selected for delete, and there are posted reconciliations where the 'Bank Balance as of' occurred after the selected reconciliation, then all those reconciliations must be deleted as well. For example, if you reconcile as of the last day of each month, and your last reconciliation was as of 8/31/19, and you want to delete the 7/31/19 reconciliation, you must select both the 7/31/19 and 8/31/19 reconciliations for deletion.