External Bank Maintenance

---

Use this form to set up country bank account formats to validate bank account numbers for suppliers who are paid by direct credit and customers who use direct debit. Validation ensures bank account numbers are correct when they're entered into Greentree Desktop. This eliminates errors during the payment and receipt processes.

External Bank Maintenance

You can define a format for each country, based on what is set up in Country Maintenance.

Country

Select the country for which bank validation applies.

Definition

For the bank, branch, account and suffix components of a bank account, you can specify:

• Min - Enter the minimum number of characters allowed for this section of the bank account number. If a minimum value is entered for a section, a separate field displays on the AP or AR maintenance form to enable validation when entering data. The length of the section must not be less than the value specified here.

  If you set Min and Max values, Greentree performs a validation during data entry, regardless of the validation setting.

• Max - Enter the maximum number of characters allowed for this section of the bank account number. If a maximum value is entered for a section, a separate field displays on the maintenance form to enable validation when entering data. The length of the section must not be greater than the value specified here.

  If you set Min and Max values, Greentree performs a validation during data entry, regardless of the validation setting.

For bank, branch and account components, you can also specify:

Validation

This determines how Greentree handles the bank account validation for each section:

• None - No validation is done for this section when the number is entered.
• Warning - A warning displays if a validation issue occurs in relation to this section when you enter the number. When supplier or customer details are saved, the user is prompted whether or not to proceed based on this warning.
• Error - An error displays if a validation issue occurs in relation to this section when the number is entered. The user can't save supplier or customer details until they enter a valid section length.

Transit No

This only displays if the selected country uses North American tax. Change the label in this field so that ACH No. appears throughout Greentree instead of Transit No.

Maintain Bank Details

Click this button to view bank details and set up additional validation conditions using the bank code. The Bank Detail Maintenance form opens:

Bank Detail Maintenance

For New Zealand companies, this form is pre-populated with detail for known banks. For Australian companies, you can import the detail using the BSB (Bank-State-Branch) Import Process, which you can run from the External Bank Maintenance form.

Code

Select the bank code for which the validation rules apply.

Description

This field displays the name of the bank for which the validation rules apply — for example, ASB New Zealand, Bank of New Zealand, National Australia Bank. and the like.

Validation

Select branch and account options depending on the level of validation you want to apply to the selected bank account:

Branch

Select one of these:

• None - Greentree doesn't perform validation using of the branch component of this bank account number unless you enter min/max values in External Bank Maintenance..
• Range - Greentree performs validation using the branch component of the bank account number falling within the defined ranges. When you select this option, a From/To range table displays on the form. You can enter a new range.

For New Zealand companies, a group of default bank settings is imported on this form.

For Australian companies, a list of valid BSBs can be imported into Greentree using the External Bank Maintenance form. This import file can be purchased in Australia. It cannot be redistributed within Greentree due to copyright protection laws.

Account

Select one of these:

• None - Greentree does not validate the account component for these bank account numbers.
• Check Digit - NZ Standard - Uses the NZ standard check digit routine to validate the account number.
• Check Digit - NZ NAB - Uses the NZ National Australia Bank's check digit routine to validate the account number.
• Check Digit - NZ Countrywide - Uses the NZ Countrywide bank's check digit routine to validate the account number.

Australian Banks

If you select an Australian bank, click the Import Australian BSBs (Bank-State-Branch) on the External Bank Maintenance form to open the import form.

Source File

Enter or select the directory path and file name for the BSB file to import.

Clear existing Banks

Select this option to erase any existing BSB bank information that's already loaded to the Bank Details form.

Remove - from BSB

Select this option to remove the dash (-) from the BSBs when they are imported.

Click OK to import the BSBs. A message displays if the import is successful. Imported details can be viewed/edited using the Bank Detail Maintenance form.

If you are setting up min/max validation rules using the External Bank Maintenance form, and you already have suppliers with bank account details that may differ from the format you have set (for example, they may include dashes), use the AP External Bank Conversion system script to convert existing formats into the new format.

• System Scripts

---