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 on the Country Maintenance form.

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 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 forms to enable validation when entering data. The length of the section must not be less than the value specified here.

  Note: If you set Min and Max values, Greentree Desktop performs a validation when you enter data, regardless of the validation setting.

Max - Enter the maximum number of characters 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.

Note: If you set Min and Max values, Greentree Desktop performs a validation when you enter data, regardless of the validation setting.

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

Validation

This option determines how Greentree Desktop 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 when you enter the number. When supplier or customer details are saved, the user is prompted whether or not to proceed.
• Error - An error displays if a validation issue occurs 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 U.S. tax. Change the label in this field so that ACH No. displays throughout Greentree Desktop 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 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 to apply to the selected bank account:

Branch

Select:

• None - Greentree Desktop doesn't perform validation using of the branch component of this bank account number unless you enter Min and Max values in External Bank Maintenance..
• Range - Greentree Desktop performs validation using the branch component of the bank account number falling in 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, you can import a list of valid BSBs into Greentree Desktop using the External Bank Maintenance form. You can purchase this import file in Australia. Due to copyright laws, MYOB cannot redistribute this file.

Account

Select the check digit routine to use to validate the account number. You can also select None, meaning Greentree Desktop does not validate the account component for these bank account numbers.

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.

Note: You can set up minimum and maximum validation rules using this form. You may have suppliers with bank account details that 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
• Country Maintenance