To Set Up Default Transaction Matching Settings
On the Cash Management Preferences (CA101000) form, you specify the default matching settings to be used by the automatic matching process on the Process Bank Transactions (CA306000) form by performing the following instructions.
To Set Up Default Matching Settings
- Open the Cash Management Preferences (CA101000) form.
- On the Bank
Statements
tab, review the settings and change them if needed as follows:
- In the Disbursement Matching section, specify the number of days allowed before or after the bank transaction date (or both) for transactions to be considered matching.
- Optional: Select the Allow Matching to Credit Memo check box if you want to automatically match receipt bank transactions to AR credit memos.
- In the Receipt Matching section, specify the number of days before or after the bank transaction date (or both) allowed for transactions to be considered matching.
- In the Invoice Matching section, select whether invoices should be matched by cash account or by discount and due dates by selecting the Match by Cash Account and Match by Discount and Due Date check boxes respectively. If you have selected the latter option, specify the needed number of days in the boxes of this section that become available.
- In the Other Matching Settings section, specify additional matching settings by selecting the needed check boxes.
- In the Auto-Match Thresholds section, review the
default values of absolute and relative thresholds and change them, if
necessary.Note: The default values of the Absolute Relevance Threshold box (75) and the Relative Relevance Threshold box (25) are recommended values.
- On the Relevance Calculation tab, review the settings and
change them if needed as follows:
- In the Payment and Expense Receipt Relevance section, specify the relative weights for matching payee names, document dates, reference numbers, and average delay for payments and estimated deviation to be used for relevance calculation. Depending on how the payments received from different customers and expenses vary, you should base these weights on the importance of each factor in identifying the documents.
- Optional: Select the Consider Empty Ref. Nbr. as Matching check box if you want the system to automatically match transactions with empty reference numbers.
- In the Invoice Relevance section, specify the relative weights for matching payee names, document dates, reference numbers, and average delay for invoice payments and estimated deviation to be used for relevance calculation.
- Click Save on the form toolbar.
The saved settings will be applied on the Process Bank Transactions form if no settings have been specified and saved on this form for a particular cash account.