Support for uninstalling a bank from the CAM connector
The CAM connector has been enhanced to allow you to uninstall the connector from your integrator.io account. If you uninstall all or the only bank associated with your connector, the connector tile is also removed from your integrator.io account and all associated information with the connector is deleted from your integrator.io account. After uninstalling, you can reinstall the connector from the marketplace as long as you have a valid subscription
For more information, see How to uninstall a bank from the connector?
Enhancements in Cash Application Manager Dashboard
The Cash Application Manager dashboard has been designed to be a one-stop-shop for the end-users for all of their cash application management activities. With the aim of making it more functional and meaningful in the end-user’s journey, we have brought in some significant changes. Some of the important new changes include the addition of new fields like currency and subsidiary information, the ability to edit a transaction record in the dashboard and option to drill down on a transaction to view invoices, credit memos and payments related details - all of it without having to leave the dashboard, thus reducing the number of clicks and tabs required to manage your cash application process.
Shown below is the new CAM dashboard:
Prior to this enhancement, the dashboard only allowed you to view the transaction information. For editing, you were required to open individual transaction records in NetSuite and make the required changes, which required you to navigate away from the dashboard.
To edit a transaction, click the Edit button. The dashboard page is displayed in the Edit mode.
In the Edit mode, the dashboard allows you to make changes in the following columns:
- Transaction Currency
- Transaction Amount
- NetSuite Customer
This feature will come handy especially when certain transactions are unidentified and as a user you’d like to set the right customer right from the dashboard. In another use case, a user could also edit the currency and amount in case the transaction amount and currency do not match the original invoice currency and amount.
The following are the additional changes that have been introduced in the Cash Application Manager Dashboard as part of this release:
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 the NetSuite 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.
This feature will allow CAM to improve match rate by learning from manual selections of customers on any unidentified transactions, when a customer name is supplied in the bank file but not identified in NetSuite.
When you edit a transaction and update a NetSuite Customer, the dashboard opens a dialog box that provides you with an option to set the Bank file customer name as an alias for the selected NetSuite customer name.
- Yes, if you want CAM to automatically use the new customer name every time a transaction has the customer name same as specified in the Bank File Customer column. When you select yes, CAM saves the NetSuite customer against the Bank File customer in the Celigo Cash App Alias List . While processing, CAM first searches for the Bank file customer name in NetSuite for an exact match, and if the match is not found, it searches for the bank file customer name in the aliases list to identify the right NetSuite customer.
- No, if you aren’t sure if the bank file customer is the correct alias for the selected NetSuite customer. .
- Always remember the alias, if you want CAM to always save the bank file customer name as an alias, every time a user selects a NetSuite customer on a transaction.. Once you select this option, the Remember Alias field will always be shown as selected on the dashboard. To deactivate this feature, uncheck the Remember Alias field.
You can find the list of all the saved aliases against the NetSuite customer names by navigating to Cash Application Manager > Records > Celigo Cash App Alias in NetSuite. The Celigo Cash App Alias List page is displayed. You can use this page to edit or delete any alias added by you from the Dashboard page.
New graphical chart to show match methods
To improve the match rate CAM now comes equipped with different methods of invoice and customer searches, like the fuzzy search (approximate matches) and alias matching. For the end-users it may be of use to segregate and review the transactions based on the match method.
To this end, a new chart ‘Match Method’ has been added in the dashboard. The Match Method chart enables you to find and access the transactions based on the following categories:
- Exact Match: Customer identified using the MICR number, Invoice, or the customer name..
- Alias Match: Customer identified using the ‘Alias matching’ functionality.
- Approximate Match: Customer identified using the fuzzy logic search.
- Manual Match: Customer identified and updated manually by the user.
This chart allows a user to easily review the transactions for accuracy, especially in the cases when they are matched using aliases or fuzzy search.
Transaction details Sub-list
The dashboard has been enhanced to display the transaction records details as a sub-list within the dashboard by allowing you to drill-down on each transaction. From the Transaction No. column, click the expand arrow against the transaction number to access more details. The transaction detail sub-list shows all the Invoices, Credit memos and Payments related to a particular transaction without having to navigate away from the dashboard. This feature would eliminate the need to open a transaction in NetSuite and reduce multiple clicks to access payment or invoice related details.
New columns added in the transaction table
The following are the new columns added into the dashboard as part of this release:
- Date Created
- Transaction Currency
- Bank File Customer
- NetSuite Customer
- Transaction Subsidiary
- Transaction Memo