Viewing Available Transactions
You can use View Available Transactions window to review those Oracle Payables and Oracle Receivables transactions that are available for reconciliation. You can also review any Oracle General Ledger journal entries that are available for reconciliation. You can access the View Available Transactions window from the Navigator, the View Bank Statement window, or the View Bank Statement Lines window.
Note: You cannot reconcile available transactions or journal entries from the View Available Transactions window.
Prerequisite
Have bank statements entered and/or reconciled in Cash Management.
To query available detail transactions from the Navigator:
1. Navigate to the Find Available window.
2. Choose Detail from the Detail/Batch/Open region, then select one or more transaction types to find detail transactions that match your criteria. You may select to view Receipt, Payment, Miscellaneous transactions, Journal, and Statement Line.
3. Edit the default sort criteria in the Ordering alternative region of the window. The sort criteria you select determines how the resulting transactions are displayed in the View Available Transactions window.
- Use the Primary poplist to select your primary sort category and the Secondary poplist to select your secondary sort category. The sort categories are transaction Type, Trx (transaction) Number, Date, and Amount.
- Use the primary Order poplist to select a sort order for the primary sort category. Use the secondary Order poplist to select a sort order for the secondary category. The options are Ascending or Descending.
4. Select the Bank alternative region.
Cash Management displays some additional fields where you can enter the bank Account Number, Account Name, and Bank Name. The Branch Name and Currency Code fields are display only.
5. (Optional) Refine or focus your search further by selecting the following alternative regions:
- Transaction: Cash Management displays some additional fields where you can enter ranges of transaction Numbers, Dates, Amounts, Maturity Dates, Batch Names, and Remittance Numbers to find only transactions within those ranges. You can also choose to find only those transactions with a specific Currency Code.
- Agent: Cash Management displays some additional fields where you can enter a Customer Name and Customer Number to use when finding Oracle Receivables transactions. You can also enter a Supplier Name and Supplier Number to use when finding Oracle Payables transactions.
- Receipt: Cash Management displays some additional fields where you can enter a Reference Type, Reference Number, Receipt Class, Payment Method, and Deposit Dates to use when finding miscellaneous transactions. Some fields are only available if you select Receipts or Miscellaneous in step 2 above.
- Journal: Cash Management displays some additional fields where you can enter a Period Name, Journal Entry Name, Document Number, or Line Number to use when finding journal entries.
6. Choose Find to find all transactions that match your search criteria. The View Available Transactions window appears, showing the available transaction lines. For each transaction you can view the transaction Type and Number, Original Currency and Amount, bank Account Currency Amount and Amount Cleared, Cleared Date, and GL Date.
At the bottom of the window, you can see three fields showing the Status, Date, and Maturity Date for the selected transaction line.
7. Choose Exchange from the poplist to view the Exchange Date, Type, and Rate, as well as the bank Account Currency Charges and Errors.
8. Choose Reference from the poplist to view the Batch Name, Agent Name, Deposit Number, and Reference Type and Number.
To find available batches from the Navigator:
1. Navigate to the Find Available window.
2. Choose Batch from the Detail/Batch/Open region, then select Remittance and/or Payment to find batches that match your criteria.
3. Edit the default sort criteria in the Ordering alternative region of the window. The sort criteria you select determines how the resulting transactions are displayed in the View Available Transactions window.
4. Select the Bank alternative region.
5. Enter your Bank Account information or select one from the available list of values.
6. (Optional) Refine or focus your search further by selecting the Transaction alternative region. You can enter transaction Dates, Amounts, Batch Names, Remittance Numbers, or the Currency Code to search for.
Note: You cannot enter search criteria for the Agent, Miscellaneous, or Journal alternative regions.
At the bottom of the window, you can see three fields showing the batch Type, Date, and Remittance Number for the selected batch line.
8. Choose Exchange from the poplist to view the Exchange Date, Type, and Rate, as well as the bank Account Currency Charges and Errors.
To query available transactions and batches from the View Bank Statement window or View Bank Statement Lines windows:
1. Select Available from the related window. The Find Available window appears.
2. Complete your search criteria for transactions or batches as described in the previous two tasks.
Note: You do not need to select a bank since you will have already done this from the View Bank Statement Reconciliation window.
3. Choose Find to perform your search. Refer to the previous two tasks for the steps to follow when reviewing the results of your search.
To find available Reconciliation Open Interface transactions:
1. Navigate to the Find Available window.
2. Choose Open Interface from the Detail/Batch/Open region, then select Receipts and/or Payments to find open interface transactions that match your criteria.
The Open Interface option appears only if you have checked the Use Reconciliation Open Interface check box in the System Parameters window.
3. (Optional) Refine or focus your search further by selecting the Transaction alternative region. You can enter transaction Dates, Amounts, Batch Names, Remittance Numbers, or the Currency Code to search for. You can also enter sort criteria, which determines how the resulting transactions are displayed in the Available Transactions window.
4. Choose Find to perform your search.
See Also
Reconciling Bank Statements Manually
Finding Available Transactions, Batches, and Journal Entries for Reconciliation
Reconciling Available Transactions, Batches, and Journal Entries
Creating Miscellaneous Transactions
Recording Exceptions
Entering Reversals
Marking a Bank Statement as Complete