General Release Information

The release 5.2.0 has been released on 23 November 2020 and contains several enhancements and several bug fixes. Below you can find more information related to the new features and bug fixes. We will update your production account automatically and the sandbox account can be updated from the customer's end at any given time.

Enhancements

BR-921 New reconciliation functionality in the pop-up

The pop-up is now extended with new functionality and will from now on also allow the following situation to be reconciled

• Payment differences on foreign currencies

• Payment differences on closed transactions

• Allow selection of multiple closed transactions

• Exchange rate recalculation of closed transactions in foreign currency

BR-927 Support for vendor prepayments

In this version, we have added support for the native Netsuite feature “Vendor Prepayments”. The vendor prepayments will be visible in the closed transaction section in the reconciliation popup and the matching algorithm will also automatically match vendor prepayments

BR-926 Extension in field options Multi-line Journal Matching

The Multi-LIne Journal option is extended in this version and will now allow the user to also set the following field individually for each expected journal posting

• Department

• Location

• Class

• Name

• Account

More information regarding this new feature can be found in the "Multi-Line Journal" documentation

Open

BR-933 Use entity’s default AR/AP account

If default AR/AP account is set on the entity, the created transaction for that entity will be posted against this account.

Good to know - Hierarchy of the AR/AP accounts used in the transactions:

Accounts Receivable side:
1. Customer’s default AR account
2. Default AR account set on the Bank Account Configuration
3. Default AR set in the Accounting Preferences

Accounts Payable side:
1. Vendor’s default AP account
2. Default AP account set on the Bank Account Configuration
3. Account based on the Vendor Bill will default to the Accounts Payable used on the last Vendor Bill saved per Subsidiary (sticky field) – SuiteAnswers 91652

Open

BR-967 Support for EFT batches in foreign currency

This version introduces the option to reconcile payment batches that are in a foreign currency where the Bank Reconciliation Suite App will also recalculate the exchange rate if needed. Reconciliation of foreign currency batches is only possible at this point if the bank account is in the base currency from the company and the payment batch may only contain one foreign currency.

BR-962 Freeze header of statement

From now on the header from the statement lines will freeze to the top section of the user's screen so that the header is always visible. This new feature is enabled by default after the upgrade. The feature can be disabled under general preferences.

BR-964 Receive payment from an employee

It’s now possible to receive a payment from an employee. This can be achieved by only selecting the employee or by selecting the employee and a particular account. The system will then create a journal posting related to the employee.

BR-959 Support for the CAMT.053 extended file format

The CAMT.053 extended is a new file type from the Nordics and from this version on the CAMT.053 Extended is fully supported. This new file format can be found in the bank file format list as “CAMT.053E” and does support the multiple statement configuration setup.

BR-930 Splitting delimiters are now configurable

In the previous Bank Reconciliation Suite App version, the system used a predefined set op splitting delimiters that were responsible for splitting the description data. In this version we only see the space as a preset and all other delimiters can be set from the user side. By default, we will still populate the field with the presets, but from here the user is allowed to change them. The additional delimiters can be set for each bank account individually in the field labeled “Additional Delimiters”. The default for this field will be: ,:;/. and during the update, we will include already set delimiters.

BR-923 New (Russian) debit/credit identifier

In this version, we have added a new Russian debit/credit identifier with the following convention

• Исходящий (debit)

• Входящий (credit)

Bug Fixes

BR-932 Filtering of voided transactions

When viewing closed transactions in the pop-up the Bank Reconciliation did also show voided transactions to the user. This new version now filters the transactions correctly so that voided transactions are no longer showing in the pop-up.

BR-584 Correct calculation of payment base currency

During the reconciliation of foreign currency transactions, the pop-up did populate by default an incorrect value for the field “payment base currency”. This new version is now populating the value correctly that triggers an correct recalculation of the exchange rate.

BR-897 Closed transaction variance zero but can't proceed

In certain situations, the user could experience that reconciling a closed transaction was not possible and did receive the message stating “On one or more lines the amount under Applied is different than under Amount. This is not possible when matching closed transactions”. This message did appear even if the amounts were fully equal. This new version resolves the background calculation and will let the user reconcile these transactions as expected without an error notification

BR-889 Incorrect filtering of sales orders in the pop-up

The popup in the Bank Reconciliation offers the option to filter the shown transactions based on the transaction type. When enabling this filtering the popup did not exclude the sales orders. The filter is not correctly filtering also the sales orders.

BR-909 Filtering of the transaction with a payment hold

The pop-up showed the user also transactions that did contain a payment hold. This new version now filters the transaction and will exclude transactions that are containing a payment hold.

BR-961 Filtering of the Direct Debit reversal list

The pop-up that shows potential payments that can be reversed with the direct debit reversal option in the Alt Match column is now filtering base on the predefined amount of reversal days prior that are set in the field “DIRECT DEBIT REVERSAL: DAYS PRIOR TODAY” under SETUP->COMPANY->GENERAL PREFERENCES->CUSTOM PREFERENCES field.

BR-957 Someone else edited the statement

In certain situations, the user could receive the error message stating “Someone else edited the statement” while this wasn’t actually the case. This version resolves this and will only show this message if indeed the same statement is accessed by another employee.

BR-943 The reconciliation report showing payment batch as un-reconciled

The reconciliation report now correctly shows a payment batch as reconciled or un-reconciled. Previously it did show up as unreconciled in all scenarios.

BR-936 Vendor payment in foreign currency

During the reconciliation of a payment in transit that was in a foreign currency the user could get the error stating “YOU_CANNOT_CHANGE_THE_VALUE_FOR_THE_1_FIELD_FOR_A_STATUS_THAT_IS_ASSOCIATED_WITH_TRANSACTIONS”. This version now correctly supports vendor payments that are in transit in a foreign currency

BR-960 Individual bill payment stays in the status “In Transit”

When the native Netsuite Payment in Transit is activated the user can still create vendor payment within the Bank Reconciliation Suite App and these are no longer created with the status “In Transit”, but are not directly confirmed

BR-949 Filtering of payment bill payments that are in the status “In Transit”

The pop-up showed vendor bills in the open transactions table if the payment was in the status “In Transit”. These vendor bills are now excluded from the open transactions list.

BR-966 Check changes in number after matching

The check number was subjected to change if matching happened. In this new version, the numbering won't change anymore if the bank account configuration setting “WHEN MATCHING A CLOSED TRANSACTION” is set to “Only link the transaction to the statement”.

BR-969 Extended CODA multi-statement automatic import

The automatic import option for statements did not fully support the CODA multiple statement configuration. This version is now able to also auto-import CODA multiple statement files.