Installation files can be downloaded from this link here
- Download the following installation files.
- Hotfix 20230524 Bank Transaction Listing with Bank Details.sql
- Bank Transaction Listing with account details.xlsx
- Run the sql scripts on the database. Instructions on running a hotfix on your database can be found here
- Import the xlsl file in Merge Templates folder for Insol6. How to import Merge templates can be found here
Unblock Files
Sometimes when files are downloaded from an external source the file will unzip as blocked. You can unblock the file from File Explorer.
- Navigate to the file
- Click on the template then Right hand click and select Properties.
If the file is blocked tick the unblock tick box as seen in the screenshot below.
If you do not have an unblock option the template is good to go.
Intermediary Bank Country Code and an Intermediary Bank SWIFT Code (sharefile)
Some bank details for foreign bank accounts that have been imported via the creditors portal will include Intermediary Bank Country Code and an Intermediary Bank SWIFT Code. These fields are not exposed anywhere in the UI so you won't be able to enter data for these into any counterparty records.
This data will need to be added via a script. You will need to know the Counterparty ID and the Admin ID
Counterparty ID
You can search the counterparty via Main Menu > Counterparties. The counterparty ID will display next to the counterparty name.
AdminID
How to find the AdminID for a job can be found in this article: Identifying the AdminID of a Job – Exalt (zendesk.com)
Comments
0 comments
Please sign in to leave a comment.