You can set the following Cash Management options from the System Parameters window:
All options, except for Set of Books, are updatable.
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 transactions external to Oracle Applications.
Show Void Payments: You must check this check box if you want voided payments available for reconciliation.
General Parameters
The general parameters control various aspects of AutoReconciliation.
The options are also used as default settings on many of the manual reconciliation windows. The defaults can be overridden when you are doing manual reconciliations.
Clear Status: Status of open interface transactions that have cleared.
Float Status: Status of open interface transactions that are available for reconciliation.
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.
Carefully choosing these options can lead to better performance during the AutoReconciliation process.
Receivable Activity: This parameter is the default for the
Miscellaneous Receipts window, and the default Receivable Activity to which AutoReconciliation charges differences between the amount 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
2 – 21 Setting Up
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.
Show Void Payments: Check this check box if you want voided payments available for reconciliation.
Automatic Reconciliation Parameters
The automatic reconciliation parameters control various aspects of AutoReconciliation. The options have no effect on manual
reconciliation.
Tolerances: Reconciliation Tolerances include a variance Amount and a variance Percent. (See: Reconciliation Tolerances: page 4 – 8).
Tolerance Differences: There are two Tolerance Differences you can set:
• AP: Use this option to control whether the AutoReconciliation program charges differences (between the amount cleared by the bank and the transaction amount) to the bank Charges or bank Errors account.
This option applies only to Payables transactions and batches.
Receivables transaction amount differences are booked only to the bank Charges account.
• Foreign: Use this option to control how AutoReconciliation handles bank discrepancies caused by exchange rate fluctuations resulting from foreign currency transactions in a multi–currency bank account. There are three options:
– Gain/Loss: Handle the difference as an exchange rate gain/loss.
2 – 23 Setting Up
– 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.
Archive/Purge: There are two Archive/Purge check boxes you can set:
• Purge: If you check this check box, the AutoReconciliation program will automatically purge all information from the bank statement open interface tables once the information has been successfully transferred to the bank statement tables.
• Archive: If you check this check box, the AutoReconciliation program will automatically archive all information from the bank statement interface tables once the information has been successfully transferred to the bank statement tables.
You cannot archive transactions without also purging them.
However, you can purge transactions without archiving. Also note, the purge and archive check boxes on the System
Parameters window affect only the bank statement interface tables. To purge or archive/purge bank statement tables, you must run the Archive/Purge 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.