Viewing Customer Mapping Rules

To view customer mapping rules:

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

2. From the Account list, select the appropriate bank or credit card account.

   NetSuite displays a list of bank lines for which NetSuite was unable to find matching payments.

3. To view your customer mapping rules, click View Customer Mapping Rules.

   This button is only active if you have selected an account.

   The Customer Mapping Rules window appears, which displays a grid of the customer mapping rules for your account, if any exist. Each rule contains a saved association from the Payor and Memo fields of an imported bank line to 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 value in the Customer column.

   Note:

   The values for Payor Similar To and Memo Similar To do not need to match exactly the Payor and Memo fields of future imported bank lines. They only need to be similar enough for NetSuite to identify an appropriate 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 within 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 within the Payor field (or Memo field) contain numbers or special characters, NetSuite maps to the reduced value, "".

   Warning:

   You can only have one customer mapping rule that maps to the same reduced value. For example, if you have an existing mapping for the payor "Mary's Fit4Less" and you create a new mapping for the payor "Go2Gym!", the new mapping overwrites the existing one as they both reduce to "". Imported bank lines containing the payor "Mary's Fit4Less" would subsequently map to "Go2Gym!".

4. To filter the list of customer mapping rules:

   • In the Search field, start typing a value contained within a rule you want to search for. You can search for values contained within the following columns:

     • Payor Similar To

     • Memo Similar To

     • Customer

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

   • To switch from a list of all rules to only active rules, click Show Active Only.

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

     Note:

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

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

   Note:

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

   By default, customer mapping rules are active.

   Important:

   NetSuite does not 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 are done reviewing your rules, click Close.

Additional Information

Related Topics