The total line automation is designed to add automatically at the end of the bank statement a total line. This total line is automatically calculated by the system by doing a sum of all the debit and credit lines. On the bank account configuration, the user can define an account to where this amount must be posted. This is useful when for example a payment service provider account is reconciled. With this total line, the user can post the total sum of the payout specification to a temporary clearing account.
The total line automation can only be used when the bank statement is imported as a multiple statement import. All bank account configurations that do use this bank file format will automatically add the total line.
For the setup, the administrator must take 2 steps. Both steps are explained step by step in the paragraphs below.
Bank file format
The second step of the process is deploying a script that interacts with the bank statement so that the additional total line can be added. Before the deployment can be made the internal ID from the multiple statement configuration must be retrieved. To do this open the bank account configuration by navigating to Setup > ZoneReconcile Setup > Bank Account Configurations. Open the Bank Account Configuration in view mode in which you want to deploy the automation of the total line logic. Click on the hyperlink that is shown in the field labeled “Bank file format”
A new page will open and in the browser URL, you will find the actual internal ID of the record. Write down this internal ID because we need this ID in the next step of the installation process.
To deploy the responsible script for the total line automation navigate to Customization > Scripting > Scripts. Set the filter to “User Event”. Search for a script named “BS UE Add Total Row” and press view on the line. A new page will open and on this page press the grey button labeled “Deploy script”.
On the page that opens set the following values
- Applies to: Bank Statement
- Status: Released
- Subtab Audience: Set here or all roles, or edit this as required
- Subtab Parameters: Set the internal id from the bank file format written down in the previous step
Do not forget to set the Audience correctly, when not set correctly it will mean that the functionality will not trigger and will not add the expected total line.
Additional configuration field
To default the account for the total line, an additional setup field must be created on the bank account configuration. To create this field navigate in the main menu to Customization > Lists, Records, & Fields > Record Types and search for the record named “Bank Account Configuration” and open this record type by clicking on the name.
On the screen that opens click on the grey button labeled “New Field”. A new page will open. On this page set the following values:
- Label: Default Account Total Row
- ID: _ff_dev_acc_total_row (Copy this exactly including the first underscore)
- Type: List/Record
- List/Record: Account
- Subtab: Preferences
- Help: This is the default account that we will use for posting the total sum of the statement (optional but recommended to guide the end-user)
Save the configuration by pressing the blue button labeled “Save”.
Navigate back to the bank account configuration page and on this page, the newly created field should be visible. When importing a new statement for the selected bank file format type the bank statement should show an additional total line at the end of the bank statement.