Articles in this section

Matching settings in Cash Application Manager

Tom Santiago
Updated
  1. Customer Has Priority: By default, CAM gives a higher preference to the invoice (if identified) to create a customer who pays for a transaction. If checked, CAM considers the customer identified using the bank file customer to create payment over the invoice customer.
    Note: If the NetSuite customer is not identified and the invoice is identified, CAM creates the payment on the invoice customer. If the NetSuite customer is identified and the invoice is from a different customer, CAM creates a payment on the NetSuite customer in an unapplied state, and the invoice is ignored. If the NetSuite customer is identified and the invoices are from multiple customers, CAM creates a payment on the NetSuite customer in an unapplied state, and the invoices are ignored.
  2. Identify invoice using amount: If checked, CAM searches for an invoice under the identified customer in NetSuite and creates a payment. This setting considers the amount against an invoice (that is available in the bank file but not identified) and searches for open invoices with the amount and uses the identified invoice to create a payment. If there is more than one invoice found with the same amount, no invoice is selected, and the payment is created in unapplied status. Check this box to identify invoices using the invoice or transaction amount for a customer if no match is found using the invoice. When you check this box, the Select customer match method to identify invoice using amount and Select NetSuite customer saved search to identify invoice using amount settings are populated.

    Note: This setting takes precedence over the Invoice Auto-application checkbox.

    • Select customer match method to identify invoice using amount: Refresh the setting to select one or more match methods to retrieve the customer match methods using the listed criteria. The setting restricts identifying invoices using amounts only for the selected match methods.
    • Select NetSuite customer saved search to identify invoice using amount: Select an appropriate customer saved search with the list of customers to whom identifying invoice using amount is applicable.
  3. Apply payments to open invoices: If checked, CAM creates payments on the identified customer on the transaction with the open invoices in NetSuite in a first-in-first-out (FIFO) order until the entire transaction amount is consumed. See Auto-application of Payments to Invoices (Wires and ACH) for more details. Check this box to apply payments to open invoices for the customers if there is no invoice detail in the bank file for a given transaction. When you check this box, the Select customer match method to apply payments to invoice and Select NetSuite customer saved search to apply payments to invoice settings are populated. 

    Note: This feature is applicable only when there are no invoices under the transaction in the bank file.

    • Select customer match method to apply payments to invoice: Refresh the setting to select one or more match methods to retrieve the customer match methods using the listed criteria. The setting restricts applying payments to open invoices only for the selected match methods.
    • Select NetSuite customer saved search to apply payments to invoice: Select an appropriate customer saved search with the list of customers to whom applying payments to invoice is applicable.

  4. Auto-apply on Open Invoices Total in NetSuite: This setting is available only when the Invoice Auto-application checkbox is checked. If checked, CAM restricts the auto-application to work only when the transaction amount is equal to the invoice open amount total of identified customers. See Auto-apply when the Open Invoice total matches the transaction amount for more details.

  5. Advanced Search for Customers: If checked, CAM uses advanced logic to search and identify the customers when your bank doesn’t send the same name that is stored in NetSuite. 

  6. Threshold: This text box is available when the Advanced Search for Customers checkbox is checked. The value provided in this text box limits the number of results found using this advanced search logic. The threshold value lies between 0.1 and 0.9, and a threshold of 0.0 requires a perfect match, a threshold of 1.0 would match anything.