General Release Information

The release 5.6.0 has been released on the 7th of December 2021 and contains several enhancements and bug fixes. Below you can find more information. We will update your Production account automatically and the Sandbox account can be updated from your (the customer's) end at any given time.

Enhancements

BR-1197 Intercompany journal posting support

We are pleased to announce new functionality - the possibility to create advanced intercompany journals. This new feature will allow the user to create directly from a bank statement transaction line an advanced intercompany journal. Also, the multi-line journal feature will allow the user to create one or multiple lines in one advanced intercompany journal. This new feature will not allow matching bank statement transaction lines against already existing intercompany journal bookings. More information regarding setup and how to use can be found on the page Advanced Intercompany journal.

BR-979 Direct debit foreign currency support

In this version, we extend the direct debit functionality so that it also supports the reversal of foreign currency transactions. This new functionality is directly available and no additional configuration is needed. The pop-up screen will show the amounts in the currency from the bank statement but will highlight the currency from the transaction.

BR-1258 Automation for a total import line

In this release, we introduce the option to set the total account logic from the end-user side. The total line is a sum of all the debits and credits imported on the statement that allows posting the full amount directly to an account of choice. This functionality is really useful for companies that do reconcile payment service providers. On page Setup total line automation a full step-by-step guide can be found on how to activate this functionality.

BR-1224 CODA OMG references are now imported

The CODA file type can sometimes hold additional data stored in the OMG reference section. This data wasn’t imported in the previous version and from this version onwards the OMG references will be imported so this data becomes visible on the bank statement transaction line. The OMG references will also be used in matching algorithms what should lead to better matching performance.

BR-1244 Changes processing logic EFT batches

In this version, the processing logic for EFT and DDR batches has been changed so that all processing is done in the background. During the processing of an EFT or DDR batch, the statement will remain locked to further improve the stability of the processing and handling of transit payment confirmations.

BR-1252 New date format

In this release, we introduce a new date format that is used by Ariwallex Bank. This date format is in the format “2021-11-06T12:02:08+1100” and is now an option in the date format dropdown on the bank statement configuration page

BR-1260 Reconciliation status overview

In this release, we introduce an additional saved search that does provide an overview across all bank accounts and the reconciliation status. The overview will show the till when the bank account is reconciled and how many statements aren’t holding a balanced end balance. This search can be added to the dashboard by searching for the saved search with the title “Bank Statement Reconciliation Status”

Bug Fixes

BR-1218 CAMT.054 imported date doesn’t follow configurations settings

On the bank account configuration, the user has the option to switch the import behavior for the transaction date. The checkbox “Use booking/entry data instead of value date (CAMT/CODA files)” should allow the user to switch this behavior but when importing a CAMT.054 this was not respected correctly and the value date was still imported. In this version, the preference is respected correctly and when turned on the booking/entry date will be the date used for importing the data.

BR-1145 Direct debit created in a closed accounting period

The bank reconciliation does allow to automatically reverse direct debits. In the previous version, the logic didn’t take closed accounting periods into account and therefore did post in closed periods. In this version, the logic is enhanced and will block postings into closed accounting periods

BR-1153 Exchange rate for transit payments is set to 1

Netsuite provides the option to enable the native payment in transit feature. With the feature, the vendor payments are in a transit state. When these vendor payments are in a foreign currency and reconciled with the Bank Reconciliation the system did revert in certain situations the exchange rate to 1 what was not correct. In this version, the behavior has been enhanced so that a correct recalculation is done for the exchange rate

BR-1210 Incorrect naming of the popup filters

During reconciliation, the user can trigger a pop-up to see all transactions related to a certain entity. In this popup, the bank reconciliation SuiteApp provides the option to filter the results to narrow down the results if needed. The filters for “Date from” and “Date till” were reversed and due to this misleading and not filtering as expected. In this release, we have altered the naming convention so the filters for the date are displayed correctly.

BR-1235 Cash Sales are matched with a difference

The bank reconciliation SuiteApp is able to match automatically against cash sales. It happened that the system did match a cash sales that wasn’t equal to the transaction line amount but did auto process the line after saving. This resulted in the situation that the cash sales were linked but the potential difference wasn’t handled. In this version, we have enhanced the matching logic so that the bank reconciliation only auto processes cash sales if the amount is 100% equal. If the amount is not equal the bank reconciliation SuiteApp will only recommend the cash sale and from here the user must first resolve the difference before the transaction can be processed.