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 |
|---|
| Excel | | Insert excerpt |
|---|
| Excel - Global |
|---|
| Excel - Global |
|---|
| nopanel | true |
|---|
|
|
| Grid Layout | | Insert excerpt |
|---|
| Grid Layout |
|---|
| Grid Layout |
|---|
| 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 |
|---|
|
|
| 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 Field |
|---|
| Checkbook Description - List View/Inquiry Field |
|---|
| 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 |
|---|
|
ERPx_ |
| Transaction | | Insert excerpt |
|---|
| Trans. ID - List View/Inquiry Field |
|---|
| Trans. ID - List View/Inquiry Field |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx_ |
...