Finding Available Detail and Batch Transactions for Reconciliation
Use the Find Available window to locate Oracle Payables and Oracle Receivables detail or batch transactions that are available for reconciliation. If you have Oracle General Ledger installed, you can also search for journal entries.
Note: From the Find Available window, you can use the Clear button to erase the current search criteria, or Cancel to exit the window.
To find available detail transactions:
1. Navigate to the Find Bank Statements window.
2. Select a bank statement, then choose Review. Optionally, choose New and enter a new bank statement header.
4. Choose Detail from the Detail/Batch/Open region, then select one or more types to find detail transactions that match your criteria. You may select to view Receipt, Payment, Miscellaneous transactions, Journal, and Statement Line. The Statement Line option is applicable only to statement lines with Miscellaneous Payment or Miscellaneous Receipt transaction types that can match against statement lines.
5. (Optional) Refine or focus your search further by selecting one of 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, or Deposit Dates to use when finding miscellaneous transactions. Certain fields only appear if you select Receipts or Miscellaneous in step 4 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.
- Ordering: The sort criteria you select determines how the resulting transactions are displayed in the 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, transaction (Trx) 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.
6. Choose Find to find all transactions that match your search criteria, or choose Find and Mark to find and automatically mark any matching transactions for reconciliation.
To find available batches:
1. Navigate to the Find Bank Statements window.
2. Select a bank statement, then choose Review. Optionally, choose New and enter a new bank statement header.
4. Choose Batch from the Detail/Batch/Open region, then select Remittance and/or Payment to find batches that match your criteria.
5. (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.
Note: You cannot enter search criteria for the Agent, Receipt, or Journal alternative regions.
6. Choose Find to find all batches that match your search criteria, or choose Find and Mark to find and automatically mark, for reconciliation, the transactions within any matching batches.
To find available Reconciliation Open Interface transactions:
1. Navigate to the Find Bank Statements window.
2. Select a bank statement, then choose Review. Optionally, choose New and enter a new bank statement header.
4. 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.
5. (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.
Note: You cannot enter search criteria for the Miscellaneous or Journal alternative regions.
6. Choose Find to find all open interface transactions that match your search criteria, or choose Find and Mark to find and automatically mark matching transactions for reconciliation.
See Also
Reconciling Available Transactions and Batches
Entering Bank Statements Manually
Reconciling Bank Statements Manually
Creating Reconciled Bank Statement Lines
Reviewing Reconciled Transactions
Changing the Reconciliation Status
Using Attachments
Creating Payments and Receipts Transactions
Creating Miscellaneous Transactions
Recording Exceptions
Entering Reversals
Reconciling Corrections and Adjustments to Bank Errors
Manually Clearing and Unclearing Receipts and Payments