Creating Customer Mapping Rules
On the Automated Cash Application page, you can create a customer mapping rule for an imported bank line when you add or change a customer. You should create a customer mapping rule if both of the following are true:
-
Your imported bank line contains a Payor or Memo value uniquely tied to the selected customer.
-
You want NetSuite to apply this selected customer to future similar bank lines.
To create a customer mapping rule:
-
Go to Transactions > Bank > Automated Cash Application.
-
From the Account list, select the bank or credit card account for which you want to create a customer mapping rule.
NetSuite displays a list of imported bank lines for which NetSuite was unable to find matching payments.
-
From the dropdown list in the Customer column:
-
If no customer name is selected for an imported bank line, select or enter the name of the appropriate customer. By default, the list displays the first 1,000 results returned by the system. If no customers are available from the dropdown list, see Troubleshooting Missing Records from the Customer Dropdown List.
-
If a customer name is selected but is incorrect, select or enter the name of the correct customer.
-
If a customer name is selected, correct, and not read-only, do the following:
-
Click the field of the customer name.
-
To clear the field, click the X icon that appears.
-
Select or enter the name of the customer 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 cannot create a customer mapping rule.
-
-
-
In the confirmation window, click Make Rule.
NetSuite selects the customer and creates a customer mapping rule. If you have an existing customer mapping rule that contradicts your new rule, your new rule overwrites the existing one. To view your newly-created rule, see Viewing Customer Mapping Rules.
Additional Information
- Setting Accounting Preferences
- Generating Customer Payments
- Filtering Imported Bank Lines
- Adding or Changing a Customer
- Customer Match Criteria
- Customer Mapping Rules for Automated Cash Application
- Reviewing Invoices for an Imported Bank Line
- Viewing Open Invoices for a Customer
- Including or Excluding Invoices from Payment Application
- Checking the Process Status for Generated Payments