| Insert excerpt |
|---|
| Def - Checkbook Reconciliation |
|---|
| Def - Checkbook Reconciliation |
|---|
| nopanel | true |
|---|
|
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: YYYY2020.MM01.DD 13 and newer
...
| Toolbar Icons | Description |
|---|
| Delete | | Insert excerpt |
|---|
| Delete - LV - Global |
|---|
| Delete - LV - Global |
|---|
| nopanel | true |
|---|
|
|
| Edit | | Insert excerpt |
|---|
| Edit - Record ViewRV Header |
|---|
| Edit - Record ViewRV Header |
|---|
| nopanel | true |
|---|
|
|
| Excel | | Insert excerpt |
|---|
| Excel - Global (old) |
|---|
| Excel - Global (old) |
|---|
| nopanel | true |
|---|
|
|
| Favorites | | Insert excerpt |
|---|
| Favorites Add/Remove - Global |
|---|
| Favorites Add/Remove - Global |
|---|
| 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 |
|---|
|
|
| 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 | - List View/Inquiry Field - List View/Inquiry FieldLinked 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 FieldLV |
|---|
| Checkbook Description - List View/Inquiry FieldLV |
|---|
| 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 | (Date & Time) - List View/Inquiry (Date & Time) - List View/Inquiry Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedDate |
| Created By | - List View / Inquiry- List View / Inquiry Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedBy |
| Last Updated | (Date & Time) - List View/Inquiry (Date & Time) - List View/Inquiry Linked Database Field: ERPx_MFCheckbookReconciliation.LastUpdated |
| Last Updated By | - List View/Inquiry - 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 | - List View/Inquiry Field - List View/Inquiry Field ERPx 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 ERPx_MFCheckbookReconciliation.TransactionID |
Related Topics
...