Enhancements in Cash Application Manager Dashboard
The following are the changes that have been introduced in the Cash Application Manager Dashboard as part of this release:
New filter to select BANK:
Along with the option to filter transactions based on account/payment type, this new drop-down list allows you to further filter transactions from the selected bank(s). Once you select a bank in this drop-down list, the ACCOUNTS / PAYMENT TYPE field will only display payment types associated with the selected bank.
Changes in the ACCOUNTS / PAYMENT TYPE drop-down list
To enhance the user experience, a new option, Select All/Unselect All, has been added to this filter.
Default loading of Transactions in Dashboard
This feature reduces the number of clicks required to render the dashboard for a user to view the transactions. By default, the dashboard will load with transactions from the previous day for a quick review. This will select all the banks and accounts/payment types by default. In case you need to change the date range you can alter from the START DATE and END DATE fields.
Added new columns in the tabular form of transaction data
Last Updated Timestamp: Displays information about the date and time when each transaction was created or modified. This field helps you in identifying when a particular transaction was modified in NetSuite.
Status Reason Code: Displays error message to inform you why a transaction has failed to create a payment. The error message is only displayed for a transaction with Status as Errors/Skipped.
Added a field to reprocess transactions
This enhancement aims to provide a way for you to easily view the skipped/errored out transactions and then make corrections based on the error messages directly from the dashboard. Once the corrections are made, you can select all the transactions that need to be reprocessed and resubmit them.
This field specifically enables you to resubmit the transactions of your choice directly from the dashboard. Select transactions and click the REPROCESS field to initiate re-processing of the selected transactions.
- Archive bank file in NetSuite
A new field, Archive file, has been added in the Settings > File Import tab for the Bank File to NetSuite integration flow. This field allows you to archive the bank file processed using the Bank File to NetSuite integration flow in NetSuite. When you enable this checkbox, the connector displays the NetSuite Archive Folder field. Use this field to specify the NetSuite file cabinet location where the outgoing file must be archived once it has been transferred.
After you enable this feature and the bank file gets processed successfully from the FTP server, the connector creates a copy of the file in NetSuite file cabinet folder.
Note: This feature is not supported when you manually upload the bank file.
Extended the Auto-application of Payments support for ACH
The Invoice Auto-application field allows you to toggle On/Off the auto-application of payment to open invoices for ACH. By default, the auto-application of payments to invoices is On for ACH. If there are no invoices identified in the incoming file and this setting is ON then the payment is applied to the open invoices for the customer in the FIFO order (First-in-first out order). This means, after identifying the customer for a transaction, CAM applies payment on the open invoices in the order of their creation date (Oldest open invoice is closed first). For more information see, Auto-application of Payments to Invoices.
- Addition of a new CAMT.054c / ISO20020 format template
A new template, CAMT.054c / ISO20020 format, has been added to the connector. This XML based template is popular mostly with European banks.