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:
-
Your imported bank line has a Payor or Memo value uniquely tied to the selected customer.
-
You want NetSuite to apply this customer to future similar bank lines.
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:
-
Go to Transactions > Bank > Automated Cash Application.
-
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.
-
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:
-
Click the customer name field.
-
To clear the field, click the X icon.
-
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.
-
-
-
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
- 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