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.
Software Version: 2020.01.10 and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Delete | Error rendering macro 'excerpt-include' : No link could be created for 'Delete LV - Global'. |
| Edit | Error rendering macro 'excerpt-include' : No link could be created for 'Edit - Record View'. |
| Excel | Error rendering macro 'excerpt-include' : No link could be created for 'Excel - Global'. |
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| 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'. |
| Mass Update | Opens the mass update dialog, which allows to mass update the following properties: Status |
| New | Opens a new blank record for data entry. |
| 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. Linked Database Field: ERPx_MFCheckbookReconciliation.BankBalanceDate |
| Checkbook | Error rendering macro 'excerpt-include' : No link could be created for 'Checkbook - List View/Inquiry Field'. Linked Database Field: ERPx_MFCheckbookReconciliation.CheckbookSK |
| 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 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 | Error rendering macro 'excerpt-include' : No link could be created for 'Created (Date & Time) - List View/Inquiry'. Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedDate |
| Created By | Error rendering macro 'excerpt-include' : No link could be created for 'Created By- List View / Inquiry'. Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedBy |
| Last Updated | Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated (Date & Time) - List View/Inquiry'. Linked Database Field: ERPx_MFCheckbookReconciliation.LastUpdated |
| Last Updated By | Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated By - List View/Inquiry'. 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 | Error rendering macro 'excerpt-include' : No link could be created for 'Status - List View/Inquiry Field'. Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK |
| Transaction | Error rendering macro 'excerpt-include' : No link could be created for 'Trans. ID - List View/Inquiry Field'. Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.