The transaction number in the description from the bank is not containing the prefix used in NetSuite
An example for this would be: INV-000123 is in the description from the bank actually 000123. In this situation, an option could be to extend the NetSuite system and the bank reconciliation matching parameters. We only recommend taking this action when there are multiple occurrences present in the created insights document. Creating this additional matching option exists out of 2 steps.
- Creating an additional transaction body field
- Creating an additional matching parameter.
Expected at his point is that the administrator knows how to create an additional transaction body field. On this new transaction body field, a formula should be used to populate this new field. The formula will simply take the transaction id and split it on your findings and take the expected value as the value to populate the field with. The formula for this particular example will look as follow.
It is important that the store value checkbox is not checked. The formula used in this situation trims the invoice number on a fixed set of characters:
LTRIM({tranid}, 'INV-')
On the transaction, we now see the following:
The next step is to extend the bank account configuration so it does take this parameter as a matching value. To do this navigate to Setup > Bank Reconciliation > Bank Account Configuration and open the related bank account configuration. Now scroll to the bottom of the page and click on the subtab labeled “Additional Parameters&Fields” and press on the button labeled “New Banks Statement Matching Parameter”. In this screen enter the name of the newly created field and after selecting the transaction id field will be automatically populated.
Save the configuration and directly create the next entry. In this entry type directly in the field labeled “Transaction Field Id” the value “tranid” and save. This must be done otherwise the system will only use your newly created field due to the fact that this custom configuration will overwrite the standard logic. From this moment onward the system will check not only the standard transaction ID from Netstuite but also your customized transaction ID field and matching should increase.