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 |
| ||||||||||||
| Grid Layout |
| ||||||||||||
| Help |
| ||||||||||||
| Inquiry Criteria |
| ||||||||||||
| |||||||||||||
| Fields | Description | ||||||||||||
| Account ID | The ID of the AP Vendor, Fisherman, or Loan the payment was made for. This is only populated for Payment records. Linked Database Field: ERPx_APVendor.VendorID | ||||||||||||
| Account Name | The Name of the AP Vendor, Fisherman, or Loan the payment was made for. This is only populated for Payment records. Linked Database Field: ERPx_APVendor.VendorName | ||||||||||||
| 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 |
| ||||||||||||
| Checkbook Amount | A text box to show the amount of the transaction, in the checkbook's currency, displayed in the currency format. This column has a grand total at the bottom. Amounts that DEBIT the Checkbook's Cash Account are displayed as positives and amounts that CREDIT the Checkbook's Cash Account are displayed as negatives. For example, deposits will be displayed as positive and Payments will be displayed as negative. Linked Database Field: ERPx_MFCheckbookTransaction.Amount | Checkbook Currency | The Currency ID of the Checkbook. | For Transfers, this will be the Currency assigned to the 'From Checkbook'.
Linked Database Field: ERPx_MFCheckbook.CurrencySK | |||||||||
| Checkbook Description |
| ||||||||||||
| Cleared Amount | The amount that cleared the bank. This is only populated for reconciled transactions. This column has a grand total at the bottom. Amounts that DEBIT the Checkbook's Cash Account are displayed as positives and amounts that CREDIT the Checkbook's Cash Account are displayed as negatives. For example, deposits will be displayed as positive and Payments will be displayed as negative. The 'Cleared Amount' will always match the 'Checkbook Amount' unless the record cleared the bank for a different amount. The 'Cleared Amount' is the Checkbook's Currency amount, formatted in the checkbook's currency. Linked Database Field: ERPx_MFCheckbookTransaction.ReconciledAmount | ||||||||||||
| Comment | Displays the 'Comment' that was entered on the Transaction. Linked Database Field: ERPx_MFCheckbookTransaction.Comment | GL Date | |||||||||||
| Insert excerpt | GL Date - List View/Inquiry Field | GL Date - List View/Inquiry Field | |||||||||||
| nopanel | true | GL Period | |||||||||||
| Insert excerpt | GL Period - List View/Inquiry Field | GL Period - List View/Inquiry Field | |||||||||||
| nopanel | true | GL Year | |||||||||||
| Insert excerpt | GL Year - List View/Inquiry Field | GL Year - List View/Inquiry Field | |||||||||||
| nopanel | true | ||||||||||||
| Home Amount | The checkbook or cleared amount converted to the Home Currency, and displayed in the home currency format, as follows:
This column displays a total at the bottom. | ||||||||||||
| Payee Name | The name entered as the Payee on Payments. This is only populated for Payment records. This is most often the value in the 'Check Name' property on the AP Vendor, Fishermen, or Loan account master file. Linked Database Field: ERPx_MFCheckbookTransaction.PayeeName | ||||||||||||
| Payment Source | Identifies which Functional Area the payment was made from. Payments made to AP Vendors will have a Payment Source of "Purchasing". Payments made to Fishermen or Loans will have a Source of "Fisherman Accounting". | ||||||||||||
| Reconciled Batch | Identifies the batch that the transaction was reconciled in. Reconciliation Batch ID's are auto-assigned as [YYYYMMDDHHMMSS] the batch was processed. This is only populated for transactions that have been reconciled. Linked Database Field: ERPx_ | ||||||||||||
| Reconciled | A Yes/No value to identify if the transaction has been reconciled. If "Yes" then the transaction has been reconciled, if "No", it has not. Linked Database Field: ERPx_ | ||||||||||||
| Reconciled By | Identify the user that reconciled the batch. This is only populated for transactions that have been reconciled and is formatted to be the user's [User First Name] + [User Last Name]. This is a system assigned value that is not editable by a user. Linked Database Field: ERPx_ | ||||||||||||
| Reconciled Date | Identifies the actual date the transaction was reconciled. This is a system assigned value that is not editable by a user. Linked Database Field: ERPx_ | ||||||||||||
| Reconciled Thru | Identifies the last day of the bank statement being reconciled or the date the transactions were reconciled thru if not from a statement. This is manually entered on the Reconcile transaction. Linked Database Field: ERPx_ | ||||||||||||
| Reconciliation Group | Identifies what group the transactions belong to on the Checkbook Reconciliation transaction. The groups are assigned as follows:
Linked Database Field: ERPx_ | ||||||||||||
| Reference | Displays the Reference from the transaction record view. Linked Database Field: ERPx_MFCheckbookTransaction.Reference | ||||||||||||
Source Transaction | A hyperlink that displays the source transaction's Transaction #. This is only populated for Reversal transactions. Linked Database Field: ERPx_ | ||||||||||||
| Status | |||||||||||||
| Insert excerpt | Status - List View/Inquiry Field | Status - List View/Inquiry Field | |||||||||||
| nopanel | true | Trans. Date | | Insert excerpt | | Doc Date - List View/Inquiry Field | Doc Date AdjustmentsIdentifies 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 |
| ||||||||||||
| Created By |
| ||||||||||||
| Last Updated |
| ||||||||||||
| Last Updated By |
| ||||||||||||
| Reconcile to Balance | Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation was targeting. | ||||||||||||
| Status |
| ||||||||||||
| Transaction |
Linked Database Field: ERPx_MFCheckbookTransaction.TransactionID | Transaction Type | A text box to show the type of transaction. The options include:
Linked Database Field: ERPx_ |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...