On the Automated Cash Application page, you can add or change customers for imported bank lines.
The Automated Cash Application feature does not support multiple customers per bank line. You cannot generate a payment for multiple customers.
To add or change a customer:
Go to Transactions > Bank > Automated Cash Application.
From the Account list, select the bank or credit card account for which you want to generate customer payments.
NetSuite displays a list of imported bank lines for which NetSuite was unable to find matching payments. A bank line can have one of the following statuses:
Ready To Submit – A customer is selected, and the box for the imported bank line is checked and ready for submission. If a customer name is populated and an invoice number is specified, this status automatically appears.
To Review – A customer is selected, and the box for the imported bank line is active and cleared. You can check the box. If you want, you can expand the row to review the invoice (or invoices) to be applied.
No Customer – A customer is not selected, so the box for the imported bank line is inactive. To make the box active, you must select a customer.
From the dropdown list in the Customer column, select the appropriate customer for the imported bank line. By default, the list displays the first 1,000 results returned by the system. If you do not see the customer, in the field in the Customer column, start typing the name of the customer to narrow your search results.
If no customers are available from the dropdown list, see Troubleshooting Missing Records from the Customer Dropdown List.Note:
A customer name is populated for an imported bank line if NetSuite achieves an exact, preferred, or partial customer match. See Customer Match Criteria. If the customer name is missing or incorrect, you must select the appropriate customer to generate a payment.Important:
Only customers with the same currency and subsidiary (if applicable) as the selected account are available for selection.
In the confirmation window, do one of the following:
To create a new customer mapping rule, click Make Rule.
You should choose this option 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.
NetSuite selects the customer and creates a customer mapping rule. Customer mapping rules enable the system to remember your customer selection for similar bank lines that get imported, based on the Payor and Memo field. For more information, see Customer Mapping Rules for Automated Cash Application.Note:
If you have an existing customer mapping rule that contradicts your new rule, your new rule overwrites the existing one.
If you do not want to create a customer mapping rule for the customer selection, click Don’t Make Rule.
You should choose this option if either of the following is true:
You are making a customer selection that you want NetSuite to only apply to the current bank line and not to others.
The Payor and Memo values are generic and do not have any unique tie to the selected customer.
NetSuite selects the customer but does not create a customer mapping rule.
After you click Make Rule or Don’t Make Rule, the box for the bank line becomes active. The system suggests open invoices for the newly-selected customer based on your accounting preferences. See Reviewing Invoices for an Imported Bank Line.
- Setting Accounting Preferences
- Generating Customer Payments
- Filtering Imported Bank Lines
- 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
- Troubleshooting Missing Records from the Customer Dropdown List
- Checking the Process Status for Generated Payments