You can set the following Cash Management options from the System Parameters window:
Basic System Parameters
Set of Books: The name of the set of books for Cash Management accounting transactions. This value defaults from the GL Set of Books Name profile option.
Cash Management supports multiple sets of books. Each responsibility is tied to a set of books and an operating unit. In a multiple
organization environment, you set up System Parameters for each operating unit. You assign bank statements to your current operating unit, and reconcile payments and receipts in that operating unit.
Begin Date: Cash Management will not display transactions dated earlier than the Begin Date.
Show Cleared Transactions: If you check this check box, cleared transactions remain available for reconciliation. Otherwise, only uncleared transactions will appear for reconciliation.
Add Lines to Automatic Statements: If you do not check this check box, you cannot add lines to automatically loaded bank statements.
Use Reconciliation Open Interface: You must check this check box if you want to use the Reconciliation Open Interface to reconcile bank statement lines to settlements in Oracle Treasury or transactions external to Oracle Applications.
Show Void Payments: You must check this check box if you want voided payments available for reconciliation.
cleared and the original amount for Remittance Batches (within the specified tolerance). You can change the chosen default value when you run AutoReconciliation.
Float Handling: This parameter specifies how to handle reconciliation of bank statement lines where the value date is later than the current date. The value date may have been provided by the bank,
user–entered, or it may have been derived. Cash Management derives the value date by adding the value in the Float Days field in the Bank Transaction Codes window to the statement line date.
Select how you want the system to handle floats:
• Ignore: Disregard the float and reconcile such transactions.
• Error: For automatic reconciliation, generate a reconciliation error. For manual reconciliation, issue a warning and allow the user to choose whether to either ignore the warning and reconcile the statement line, or to leave the statement line unreconciled.
Matching Order: Setting these options for Payables and Receivables controls how the AutoReconciliation program searches for transactions to match bank statement lines. You can choose to have Cash
Management match Transactions or Batches first. These options also control how the Available Transaction Find window defaults when searching for transactions to manually reconcile.
Archive/Purge: You can set the following options to automatically archive or purge imported bank statement information.
• Purge: If you check this check box, the Bank Statement Import program automatically purges all information from the Bank Statement Open Interface tables once the information has been successfully transferred to the Bank Statement tables. If you import intra–day bank statements, the Intra–Day Bank Statement Import program automatically purges imported bank statement information from the Bank Statement Open Interface tables. You can purge bank statements without first archiving them.
• Archive: If you check this check box, the Bank Statement Import program automatically archives all information from the Bank Statement Interface tables once the information has been successfully transferred to the Bank Statement tables. If you import intra–day bank statements, the Intra–Day Bank Statement Import program automatically archives imported bank statement information from the Bank Statement Open Interface tables. You cannot archive bank statements without also purging them.
You cannot use these two options to automatically archive or purge information from the Bank Statement tables or the Intra–Day Bank Statement tables. You must run the Archive/Purge Bank Statements program.
Lines Per Commit: This is the number of lines that AutoReconciliation will save at a time, and controls the number of transaction rows that AutoReconciliation locks at any given time. The greater the number of lines, the faster AutoReconciliation processes. However, the number of lines you can specify is limited by the amount of memory your system has available.
AutoReconciliation Parameters
The automatic reconciliation parameters control various aspects of AutoReconciliation. The Tolerance Differences parameters affect the functionality of manual reconciliation.
Tolerances: Reconciliation Tolerances include a variance Amount and a variance Percent. (See: Reconciliation Tolerances: page 4 – 7).
Tolerance Differences: There are two Tolerance Differences you can set:
• AP: Use this option to control whether AutoReconciliation charges differences (between the amount cleared by the bank and the transaction amount) to the bank Charges or bank Errors account when the transactions are based in the bank account currency. This option also can be used to default the amount difference between the statement line amount and the
transaction amount to the Charges and Errors field when using the Recalculate button in the Available Batches and the Available Detail Transactions window during manual reconciliation.
This option applies only to Payables transactions and batches.
Receivables transaction amount differences are booked only to
– Charges/Errors: Handle the difference as a bank Charge or a bank Error.
Receivables transaction differences are booked only to the bank Charges account.
– No Action: Do not reconcile. You can view the error condition in the Reconciliation Errors window.
Foreign Currency Bank. If you set the following two options, AutoReconciliation automatically selects the corresponding exchange rates, as defined in Oracle General Ledger, to reconcile statement lines of foreign currency bank statements that do not contain exchange rate information.
• Exchange Rate Type. AutoReconciliation selects the exchange rates for the transaction currency using the Exchange Rate Type you specify. You can choose any Exchange Rate Type defined in Oracle General Ledger.
• Exchange Rate Date. AutoReconciliation selects the exchange rates for the transaction currency using the date source you specify. You can choose any of the following exchange rate dates:
– Statement Line Date. The date the transaction cleared the bank.
– Bank Statement Date. The closing date of the statement.
– Bank Statement GL Date. The accounting date used to clear the statement.
– Transaction Creation Date. The date the transaction was created.
– Transaction Exchange Rate Date. The date associated with the exchange rate that was used to create the transaction.
– Transaction Creation GL Date. The accounting date used to create the transaction.
Open Interface Parameters
You must enter the open interface parameters if you enabled the Use Reconciliation Open Interface check box.
Open Interface Status Code: The status codes you define here are used to search for available, cleared, and reconciled open interface transactions external to Oracle Applications. When you reconcile Treasury settlements, however, the status codes are used only to
display the status of the settlements in the Available Transactions window and the Reconciled Transactions window.
Clear Status: Status of open interface transactions that have cleared or reconciled. If you reconcile only Treasury settlements in the
Reconciliation Open Interface. enter the status code of Reconciled. If you also clear or reconcile external transactions, enter the code you use to identify cleared transactions in the CE_999_INTERFACE_V view.
Float Status: Status of open interface transactions that are available for clearing and reconciliation. If you reconcile only Treasury settlements in the Reconciliation Open Interface, enter the status code of
Available. If you also clear or reconcile external transactions, enter the code that you use to identify available transactions in the CE_999_INTERFACE_V view.
Open Interface Matching Criteria: This parameter specifies the matching criteria for open interface transactions. The default is Transaction Number. If you want to reconcile bank statement lines to Treasury settlements, select the Date and Amount option.
Transaction Number: Matches the open interface transaction by the transaction number. The difference between the bank statement line amount and the transaction amount must be within the reconciliation tolerance.
Date and Amount: Matches the open interface transaction by both the transaction date and transaction amount. The bank statement line amount must be exactly the same as the transaction amount for a match. When the transaction currency and the bank account currency are different, the amount used for matching is calculated according to the bank statement line amount, currency code, exchange rate
information, and bank charges.