The purpose of the Checkbook Reconciliations List View is to show open reconciliation transactions in a Status of ‘New’ or ‘Approved’ and create new transactions to balance a checkbook. From here, users can add new reconciliations, edit existing reconciliations or delete unposted reconciliations. When a reconciliation is Posted, the checkbook balance may be updated and the Checkbook Transaction Inquiry is updated with the reconciliation information. Checkbook reconciliations do not make journal entries when posted.
...
| Toolbar Icons | Description |
|---|
| Delete | | Insert excerpt |
|---|
| Delete LV - Global |
|---|
| Delete LV - Global |
|---|
| nopanel | true |
|---|
|
|
| Edit | | Insert excerpt |
|---|
| Edit - Record View |
|---|
| Edit - Record View |
|---|
| nopanel | true |
|---|
|
|
| Excel | | Insert excerpt |
|---|
| Excel - Global |
|---|
| Excel - Global |
|---|
| nopanel | true |
|---|
|
|
| Favorites | | Insert excerpt |
|---|
| Favorites Add/Remove - Global |
|---|
| Favorites Add/Remove - Global |
|---|
| nopanel | true |
|---|
|
|
| Grid Layout | | Insert excerpt |
|---|
| Grid Layout |
|---|
| Grid Layout |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global Icon |
|---|
| Help - Global Icon |
|---|
| nopanel | true |
|---|
|
|
| Mass Update | | Insert excerpt |
|---|
| Mass Update - Global |
|---|
| Mass Update - Global |
|---|
| nopanel | true |
|---|
|
Status |
| New | | Insert excerpt |
|---|
| New - Global |
|---|
| New - Global |
|---|
| nopanel | true |
|---|
|
|
| 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. Linked Database Field: ERPx_MFCheckbookReconciliation.BankBalanceDate |
| Checkbook | | Insert excerpt |
|---|
| Checkbook - List View/Inquiry Field |
|---|
| Checkbook - List View/Inquiry Field |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx_MFCheckbookReconciliation.CheckbookSK |
| 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 are included on the reconciliation, in the checkbook's currency, displayed in the currency format. This is a calculated field and not stored in the database. |
| Cleared Deposits | Identifies the sum of all the deposit transactions (Deposits and Transfer: Receipt transactions) that are included on the reconciliation, in the checkbook's currency, displayed in the currency format.This is a calculated field and not stored in the database. |
| Cleared Payments | Identifies the sum of all the payment transactions (Payments and Transfer: Sent transactions) that are included on the reconciliation, in the checkbook's currency, displayed in the currency format.This is a calculated field and not stored in the database. |
| Created | | Insert excerpt |
|---|
| Created (Date & Time) - List View/Inquiry |
|---|
| Created (Date & Time) - List View/Inquiry |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedDate |
| Created By | | Insert excerpt |
|---|
| Created By- List View / Inquiry |
|---|
| Created By- List View / Inquiry |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedBy |
| Last Updated | | Insert excerpt |
|---|
| Last Updated (Date & Time) - List View/Inquiry |
|---|
| Last Updated (Date & Time) - List View/Inquiry |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx_MFCheckbookReconciliation.LastUpdated |
| Last Updated By | | Insert excerpt |
|---|
| Last Updated By - List View/Inquiry |
|---|
| Last Updated By - List View/Inquiry |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx_MFCheckbookReconciliation.LastUser |
| Reconcile to Balance | Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation is targeting. Linked Database Field: ERPx_MFCheckbookReconciliation.Amount |
| 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 Field |
|---|
| nopanel | true |
|---|
|
Linked Database Field: ERPx ERPx_MFCheckbookReconciliation.TransactionID |
Related Topics
...