Viewing Customer Mapping Rules

When you create a customer mapping rule on the Automated Cash Application page (see Creating Customer Mapping Rules), NetSuite displays the rule in the Customer Mapping Rules window.

To view customer mapping rules:

  1. Go to Transactions > Bank > Automated Cash Application.

  2. From the Account list, select the bank or credit card account you want to view.

    NetSuite displays a list of bank lines that don't have matching payments.

  3. To view your customer mapping rules, click View Customer Mapping Rules. This button is active only if you selected an account.

    The Customer Mapping Rules window displays a grid of customer mapping rules for your account, if any exist. Each rule contains a saved association between the Payor and Memo fields of an imported bank line and a customer in NetSuite. The Payor Similar To and Memo Similar To columns display the information NetSuite uses to match incoming bank lines to the Customer column value.

    Note:

    The values for Payor Similar To and Memo Similar To don't need to match the Payor and Memo fields of future imported bank lines exactly. They only need to be similar enough for NetSuite to identify the right customer.

    When comparing rule values to future imported bank lines, the system transforms the values by removing white space and capitalization. For example, NetSuite may assign an imported bank line with the payor “Will Burr” to a customer mapping rule with the payor “Wilbur”.

    If words in the Payor or Memo field of imported banked lines contain numbers or special characters, the system ignores those words when performing mapping. For example, NetSuite maps the payor "L'Oreal Shampoo" to simply "Shampoo". If all words in the Payor or Memo field contain numbers or special characters, NetSuite maps to the reduced value, "".

  4. To filter the list of customer mapping rules:

    • In the Search field, start typing a value from a rule you want to find. You can search for values in any column where you can type, including:

      • Payor Similar To

      • Memo Similar To

      • Customer

      As you type, NetSuite narrows the results in the list.

    • To view only active rules, click Show Active Only.

    • To filter by customer name, select a customer from the Customer list.

      Note:

      On the Automated Cash Application page, the Customer list displays only customer names included in the Customer Mapping Rules window.

  5. To make a rule inactive, clear the Active box.

    Any changes to your rules are saved immediately. The Payor Similar To, Memo Similar To, and Customer values are read-only.

    By default, customer mapping rules are active.

    Important:

    NetSuite doesn't run the Automated Cash Application when you manually run reconciliation rules from the Match Bank Data page.

  6. To remove a customer mapping rule, see Removing Customer Mapping Rules.

  7. When you're done reviewing your rules, click Close.

Additional Information

Related Topics

General Notices