The purpose of the Checkbook Reconciliation Inquiry is to view Checkbook Reconciliations. All checkbook reconciliations, both open and posted can be viewed from here.
...
| Toolbar Icons | Description |
|---|
| Delete | | - Global | - Global 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.
|
| Excel | | Insert excerpt |
|---|
| Excel - Global (old) |
|---|
| Excel - Global (old) |
|---|
| nopanel | true |
|---|
|
|
| Grid Layout | | Insert excerpt |
|---|
| Grid Layout - Global |
|---|
| Grid Layout - Global |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global Icon |
|---|
| Help - Global Icon |
|---|
| nopanel | true |
|---|
|
|
| Inquiry Criteria | | Insert excerpt |
|---|
| Inquiry Criteria - Global |
|---|
| Inquiry Criteria - Global |
|---|
| nopanel | true |
|---|
|
- 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 | | Insert excerpt |
|---|
| Print - Global |
|---|
| Print - Global |
|---|
| nopanel | true |
|---|
|
|
| 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 | | Insert excerpt |
|---|
| Checkbook - List View/Inquiry Field |
|---|
| Checkbook - List View/Inquiry Field |
|---|
| nopanel | true |
|---|
|
|
| Checkbook Currency | The Currency ID of the Checkbook. Linked Database Field: ERPx_MFCheckbook.CurrencySK |
| Checkbook Description | | Insert excerpt |
|---|
| Checkbook Description - List View/Inquiry FieldLV |
|---|
| Checkbook Description - List View/Inquiry FieldLV |
|---|
| nopanel | true |
|---|
|
|
| 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 | | Insert excerpt |
|---|
| Created (Date & Time) - List View/Inquiry |
|---|
| Created (Date & Time) - List View/Inquiry |
|---|
| nopanel | true |
|---|
|
|
| Created By | | Insert excerpt |
|---|
| Created By- List View / Inquiry |
|---|
| Created By- List View / Inquiry |
|---|
| nopanel | true |
|---|
|
|
| Last Updated | | Insert excerpt |
|---|
| Last Updated (Date & Time) - List View/Inquiry |
|---|
| Last Updated (Date & Time) - List View/Inquiry |
|---|
| nopanel | true |
|---|
|
|
| Last Updated By | | Insert excerpt |
|---|
| Last Updated By - List View/Inquiry |
|---|
| Last Updated By - List View/Inquiry |
|---|
| nopanel | true |
|---|
|
|
| Reconcile to Balance | Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation was targeting. |
| Status | | Insert excerpt |
|---|
| Status - List View/Inquiry Field |
|---|
| Status - List View/Inquiry Field |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK |
| Transaction | | Insert excerpt |
|---|
| Trans. ID - List View/Inquiry Field | Trans. ID - List View/Inquiry FieldTransaction ID |
|---|
| Transaction ID |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID |
Related Topics
...