Creating Customer Mapping Rules

On the Automated Cash Application page, create a customer mapping rule for an imported bank line when you add or change a customer. Create a customer mapping rule if both of the following are true:

Warning:

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

To create a customer mapping rule:

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

  2. From the Account list, select the bank or credit card account you want to create a customer mapping rule for.

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

  3. From the list in the Customer column:

    • If no customer name is selected for an imported bank line, select or enter the appropriate customer. By default, the list displays the first 1,000 results. If no customers are available from the list, see Troubleshooting Missing Records from the Customer.

    • If a customer name is selected but is incorrect, select or enter the correct customer.

    • If a customer name is selected, correct, and not read-only, do the following:

      1. Click the customer name field.

      2. To clear the field, click the X icon.

      3. Select or enter the customer name again.

      Note:

      If NetSuite finds an exact match for an imported bank line and the customer or invoice information is correct, the box for the bank line is automatically checked. The customer name is read-only and you can't create a customer mapping rule.

  4. In the confirmation window, click Make Rule.

    NetSuite selects the customer and creates a customer mapping rule. If an existing rule contradicts your new rule, the new rule overwrites the old one. To view your newly-created rule, see Viewing Customer Mapping Rules.

Additional Information

Related Topics

General Notices