•  Refresh
  • Tools
  •  
  • Expand All
  • Collapse All
  • Locales
  • Get File Link
  • Report Typo
  • Print
  • Export

Cash Management Preferences

Form ID: (CA101000)

You use this form to specify the settings for the cash management functionality. These settings include the numbering sequences to be used on cash management forms, the cash-in-transit account and corresponding subaccount to be used for funds transfers, and the options for calculating cash account balances and processing cash-related documents.

In This Topic [Hide/Show]

Back to TopForm Toolbar

The form toolbar has only standard buttons.

Back to TopGeneral Tab

The general settings that affect cash management include the numbering sequences for cash management transactions that are generated, the GL account (and subaccount, if applicable) to be used for cash in transit, and various options for processing cash transactions.

Numbering Settings Section

Element Description
Batch Numbering Sequence The numbering sequence to be used for the identifiers of cash management batches.
Transaction Numbering Sequence The numbering sequence to be used for the identifiers of cash adjustments or direct cash transactions.
Transfer Numbering Sequence The numbering sequence to be used for the identifiers of transfers.
Payment Batch Numbering Sequence The numbering sequence to be used for the identifiers of batches of payments.
Bank Statement Numbering Sequence The numbering sequence to be used for the identifiers of bank statements.
Corporate Card Numbering Sequence The numbering sequence to be used for the identifiers of corporate cards.
This box is available if the Expense Management feature is enabled on the Enable/Disable Features (CS100000) form.

Reconciliation Settings Section

Element Description
Unrecognized Receipts Type The entry type (configured for processing unrecognized payments and for payment reclassification) to be used by default on the Reclassify Payments (CA506500) form.
For details on processing unrecognized cash transactions, see Reclassification of Unknown Payments.
Cash-in-Transit Account A special account used (when necessary) as an intermediate account for currency conversions performed during funds transfers. The system uses this account when the transfer date is earlier than the receipt date in the fund transfer.
Cash-in-Transit Subaccount The corresponding subaccount.
Skip Voided Transactions A check box that you select to make the system skip voided transactions during the reconciliation process if both the original and the voided transactions are registered in the same financial period. If the check box is selected, the system will show only the original transaction with the Voided status and the amount of 0.00.
For details, see Bank Reconciliation: Optional Reconciliation Operations.

Receipts to Add to Available Balances Section

The check boxes in this section control how the system uses receipts when calculating the available balances of cash accounts.

Element Description
Unreleased Uncleared A check box that you select to include unreleased and uncleared receipts in calculation.
Unreleased Cleared A check box that you select to include unreleased and cleared receipts in calculation.
Released Uncleared A check box that you select to include released and uncleared receipts in calculation.

Disbursements to Deduct From Available Balances Section

The settings in this section control how the system uses disbursements when it calculates the available balances of the cash accounts.

Element Description
Unreleased Uncleared A check box that you select to include unreleased and uncleared disbursements in calculation.
Unreleased Cleared A check box that you select to include unreleased and cleared disbursements in calculation.
Released Uncleared A check box that you select to include released and uncleared disbursements in calculation.

Posting and Release Settings Section

Element Description
Automatically Post to GL on Release A check box that indicates (if selected) that cash transactions are automatically posted to the general ledger when they are released. This check box is selected by default.
Release AP Documents from CA Module A check box that indicates (if selected) that AP documents can be released from cash management forms. If this check box is not selected, AP documents can be released only from accounts payable forms.
Release AR Documents from CA Module A check box that indicates (if selected) that AR documents can be released from cash management forms. If this check box is not selected, AR documents can be released only from accounts receivable forms.

Data Entry Settings Section

Element Description
Hold Transactions on Entry A check box that indicates (if selected) that newly entered transactions will by default get the On Hold status on entry.
Validate Control Totals on Entry A check box that (if selected) adds the Control Total box to the Summary area of the Cash Transactions (CA304000) form, so a user can enter the transaction amount manually. This amount will be validated when users enter transactions.
Validate Tax Totals on Entry A check box that (if selected) adds the Tax Amount box to the Summary area of the Cash Transactions (CA304000) form, so a user can enter the tax amount manually in the transaction.
Require Document Ref. Nbr. on Entry A check box that indicates (if selected) that a user must fill in the Document Ref. box with the noted number while creating a record on the following forms: If this check box is cleared, the Document Ref. box is optional.
Default Date Range The range (starting with the current business date) to be used by default on cash management reports: Day, Week, Month, or Financial Period.

Back to TopApprovals Tab

This section is available only if the Approval Workflow feature is enabled on the Enable/Disable Features (CS100000) form.

In the table, you specify the approval map or maps to be used to assign cash documents to employees for approval.

Table Columns

You use this table to select the approval map or maps to be used in the approval process.

The table toolbar has only standard buttons.

Column Description
Active A check box that indicates (if selected) that cash transactions should be approved before they can be released. The system will use the map specified in the Approval Map column for processing the approval.
Type The type of documents that need to be approved by using the specified approval map. One of the following options can be selected:
Approval Map The approval map that has been configured for documents of this type on the Assignment and Approval Maps (EP205500) form.
Pending Approval Notification The notification template that will be used for email notifications. You can create new templates or edit existing ones by using the Email Templates (SM204003) form.
Only original approvers assigned through an approval map can receive notifications about pending approvals. If an approver has an assigned delegate and approvals are reassigned to this delegate, the delegate will not receive pending approval notifications. For more information about delegates, see Approval Configuration: Delegation of Approvals.

Back to TopBank Statements Tab

The system uses the settings on this tab as the default settings on the Process Bank Transactions (CA306000) form for finding relevant cash transactions for manual matching or automatic matching.

Disbursement Matching Section

The system uses these settings as the default settings for the manual matching of transactions.

Element Description
Days Before Bank Transaction Date For the system to categorize a cash transaction as matching, the maximum number of days between the date of a cash transaction (disbursement) and the selected transaction on the bank statement.
The maximum possible value that you can specify in this box is 365.
Days After Bank Transaction Date For the system to categorize a cash transaction as matching, the maximum number of days between the date of the selected transaction on the bank statement and the date of a disbursement.
The maximum possible value that you can specify in this box is 365.
Allow Matching to Credit Memo A check box that indicates (if selected) that the system will allow the matching of disbursement bank transactions to accounts receivable credit memos. If the check box is cleared (the default state), disbursement bank transactions are matched to accounts payable bills.

Receipt Matching Section

Here you specify the default settings for manual matching of transactions.

Element Description
Days Before Bank Transaction Date For the system to categorize a cash transaction as matching, the maximum number of days between the date of a cash transaction (receipt) and the selected transaction on the bank statement.
The maximum possible value that you can specify in this box is 365.
Days After Bank Transaction Date For the system to categorize a cash transaction as matching, the maximum number of days between the date of the selected transaction on the bank statement and the date of a receipt.
The maximum possible value that you can specify in this box is 365.
Allow Matching to Debit Adjustment A check box that indicates (if selected) that the system will allow the matching of receipt bank transactions to accounts payable debit adjustments. If the check box is cleared (the default state), receipt bank transactions are matched to accounts receivable invoices.

Invoice Matching Section

This section is used to filter selected invoices as possible matches for bank transactions. Here you specify the default settings for manual matching of AR invoices and AP bills.

Element Description
Match by Cash Account A check box that (if selected) indicates that the system will match bank transactions to invoices with the same cash account or an empty cash account. The check box is cleared by default.
Match by Discount and Due Date A check box that (if selected) indicates that the system will match bank transactions to AR invoices by the discount and due date. The check box is cleared by default.
Days Before Discount Date The number of days before the discount date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected.
The maximum possible value that you can specify in this box is 365.
Days Before Due Date The number of days before the due date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected.
The maximum possible value that you can specify in this box is 365.
Days After Due Date The number of days after the due date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected.
The maximum possible value that you can specify in this box is 365.

Other Matching Settings Section

This section is used to specify other settings for matching bank transactions to documents.

Element Description
Allow Matching to Unreleased Batch Payments A check box that indicates (if selected) that unreleased batch payments are available for matching to bank transactions on the Process Bank Transactions (CA306000) form. When a user initiates the processing of the matched transactions (by clicking Process on the form toolbar of that form), the system releases matched batches.
For details, see Batch Payment Matching.
Skip Reconciled Transactions in Matching A check box that indicates (if selected) that when bank transactions are imported on the Process Bank Transactions (CA306000) form, the system skips the checks and deposits that have been reconciled and that belong to closed reconciliation statements.

Auto-Match Thresholds Section

This section specifies the settings that the system uses to find the best match during the auto-matching process.

Element Description
Absolute Relevance Threshold The absolute relevance threshold the system will use when finding the best match. The default (recommended) value is 75.
Relative Relevance Threshold The relative relevance threshold the system will use when finding the best match. The default (recommended) value is 20.

Import Settings Section

Element Description
Ignore Currency Check on Bank Statement Import A check box that indicates (if selected) that the system ignores the currency check when you import bank statements. Select the check box if you want to import statements that use a currency ID or code that does not match the currency ID associated with the cash account for which you are performing the import.
Allow Empty FITID A check box that indicates (if selected) that the system ignores any empty FITID value—the value that is uploaded to the Ext. Tran. ID column on the Import Bank Transactions (CA306500) form—when you import the bank statement file.
Import Bank Statements to Single Cash Account A check box that indicates (if selected) that importing a bank statement from a file should be performed to only a specific cash account. The user can import the data only after selecting the cash account on the Import Bank Transactions (CA306500) form.
Statement Import Service The service to be used for importing bank statements if the Import Bank Statements to Single Cash Account check box is cleared. The available option is PX.Objects.CA.OFXStatementReader. The service supports importing bank statements in the following formats: OFX (Open Financial Exchange) and QFX (Quicken File eXchange).

Back to TopRelevance Calculation Tab

The system uses the settings on this tab as the default settings in relevance calculation for automatic matching of payments, expense receipts, and invoices.

Payment and Expense Receipt Relevance Section

Element Description
Ref. Nbr. Weight The relative weight of the evaluated difference between the reference numbers of the bank transaction and the cash transaction.
Consider Empty Ref. Nbr. as Matching A check box that (if selected) indicates that a bank transaction with an empty reference number is automatically matched to a cash transaction with an empty reference number. If this check box is cleared (the default value), the transactions with empty reference numbers are not considered as matching.
Doc. Date Weight The relative weight of the evaluated difference between the dates of the bank transaction and the cash transaction.
Doc. Payee Weight The relative weight of the evaluated difference between the names of the customer (or vendor) on the bank transaction and the cash transaction.
Amount Weight The relative weight of the evaluated difference between the amounts of the bank transaction and the expense receipt.
Amount Difference Threshold (%) The evaluated difference between the amount of the bank transaction and the amount of the expense receipt in the claim currency.
Payment Clearing Average Delay The average number of days for a payment to be cleared with the bank.
Estimated Deviation (Days) The number of days before and after the average delay date during which 50% of payments are generally cleared.

Invoice Relevance Section

The settings in this section are used to calculate the matching relevance for invoices.

Element Description
Invoice Nbr. Weight The relative weight of the evaluated difference between the invoice number of the bank transaction and the invoice number in the system. The default value is 87.50.
Doc. Date Weight The relative weight of the evaluated difference between the dates of the bank transaction and the invoice. The system compares the transaction date to the due date and discount date of the invoice.
Doc. Payee Weight The relative weight of the evaluated difference between the names of the customer on the bank transaction and on the invoice. The default value is 12.50.
Average Payment Delay The average number of days after the due date or discount date.
Estimated Deviation (Days) The number of days before and after the average delay date during which 50% of invoices are paid. The default value is 2.