The Cash Application Manager (CAM) Dashboard is a graphical way to resolve and reconcile bank payments in NetSuite. The payments are automatically matched to the corresponding invoice and customer base.
The dashboard interface allows you to access transactions from one or more banks with search and sort options to manage high record volumes. The dashboard displays transactions by batch number, transaction number, lockbox batch date, amount, customer, and status. You can use the dashboard to easily resolve unmatched or partially matched records in NetSuite.
Access the Cash Application Manager Dashboard from NetSuite's main menu.
The CAM dashboard enables you to access your bank accounts and load the transactions into the section for a specific time range. The filtered transactions are then displayed with links to their NetSuite records.
Account, Date Range, and Load Transactions
- Select your accounts from the Accounts section, and check the checkboxes next to the banks you want to filter on.
- Select the appropriate date range.
- Click Load Transactions.
The transactions display in both graphical and tabular format. This dashboard allows you to view and resolve a large cache of transactions at a glance with sort and search functionality. You can resolve all exceptions with ease from this dashboard.
- Bank: Use this field to select one or more banks available in the list. The list populates based on the active banks you have in the Integration App. You can select one or more options in this list depending on the transactions you’d like the dashboard to display.
- Account / Payment Type: This field is a subset of the bank that displays all the available accounts in the selected bank. You can select one or more options in this list depending on the transactions you’d like the dashboard to display.
Note: The values you see in the drop-down menu are not the actual accounts in NetSuite, but the file/payment types.
- Start Date & End Date: Use the start and end dates to fetch the list of transactions for a specific period of time. These fields hold the last working day’s date by default.
- Load Transactions: Use this button to retrieve all the transactions returned by the criteria you've defined in the options.
- Transaction Status Pie Chart: This pie chart is a visual representation of the number of transactions received in the selected period of time and their respective statuses.
- Match Method Pie Chart: This pie chart is a visual representation of the number of customers with transactions that matched your search criteria.
- Edit/Save: Use this button to change the dashboard to edit mode. In edit mode, you can update the following fields:
Click Save after you make your modifications.
- Refresh: Use this button to refresh the dashboard to bring it back to the original search results. Use this after you perform a search to find specific transactions or to filter transactions using any of the pie charts available.
- Remember Alias: Check this checkbox if you want CAM to save the bank file customer name as an alias each time a user selects a NetSuite customer on a transaction. Once you select this option, the Remember Alias field always displays as selected on the dashboard. Uncheck the checkbox to deactivate this feature.
- Search: Use the field in the search bar to filter out transactions based on any alphanumeric strings.
- Sublist View of Transactions: Each transaction has more records/data attached to it (like customer payment, invoices, credit memos, journal entries, etc.). Expand the transaction record in the dashboard to see this data.
Search NetSuite Customer
In the Edit mode, the dashboard allows you to search and add a NetSuite customer against a transaction. The search becomes active and provides matching NetSuite customer suggestion when you enter at least three characters in theNetSuite Customer column. The NetSuite
customer appears in suggestion only if an open invoice exists in NetSuite for that customer.
To see the complete list of NetSuite customers matching the keyword search, click on the search button.
Also when you click within the NetSuite Customer field, you may see a list of customer names with * mark at the end. The * mark indicates the customer identified as possible match using the fuzzy search logic.
For more details on the fields that can be edited and remembering aliases, see Cash Application Manager | August 2018 (version 3.0.0).