Supplier/Beneficiary Banking Details

Flag Bank for EFT Payments

Accounts payable (AP) and Cashbook (CB) EFT payments are bank driven. AP suppliers and CB beneficiaries need to be linked to a bank that has been activated for EFT payments as per Figure 1.

Figure 1

Flag Supplier for EFT Payments

To enable EFT payments for a supplier the ‘EFT payments required’ option needs to be ticked. This option will only be enabled if the supplier is linked to an EFT enabled bank. See Figure 2 below for the “EFT payments required” flag.

Figure 2

BTS Supplier Changed Trigger

Note that some of the banking institutions require additional information per Supplier which is not catered for in SYSPRO. For these banking formats, BTS has a trigger process which is called to prompt the user for the additional infiormation. These BTS trigger points are configured durring the intial BTS installation and setup process. and remember that SYSPRO triggers are unique per SYSPRO company so the BTS triggers would need to be setup in each SYSPRO company as required.

See all the BTS BANK FORMATS to verify whether the bank format being used has additional information associated.

EFT out of Cashbook

The SYSPRO Cashbook beneficiary maintenance program is purely for EFT payments out of the Cashbook. All beneficiaries with their relevant banking details will be used for Cashbook EFT payments. The relevant bank linked to these beneficiaries needs to be EFT activated and the captured beneficiaries will only be linked to that specific bank as per Figure 3.

Figure 3

In the AP Supplier maintenance and CB Beneficiary maintenance, the Account number, Bank branch and Account type are compulsory for bank formats that are not Pre-Format.

Output EFT payments to XML format – this option is not required by BTS and it may be unticked
XML file path – this path will be used by BTS to generate the opropriate payment file as required by the specific banking institution and as defined by the BTS configuration.

Account Type

The account types are a 1 digit field that depicts the account type as follows:

1- Current Account
2- Savings Account
3- Transmission Account
4- Bond Account
5- Subscription Shares

The above numbers are shared by all the banks. When using a Bond or Subscription Shares account, the account number is normally 18 digits long. The normal Account number field is only 15 characters long so the user may use the EFT USER 1 field to capture account numbers for these account types.

Pre-Format

CATS PRE-FORMAT: This bank format does not require an Account number, Bank branch or Account type. An alphanumeric credit-line number is used against each supplier and this must be captured in the EFT USER 1 field (“Credit Line (CATS)” as per Figure 2).
NEDBANK PRE-FORMAT: This bank format does not require an Account number, Bank branch or Account type. A numeric credit-line number is used against each supplier and this must be captured in the EFT USER 2 field(“Credit Line (NED)” as per Figure 2).

EFT User1 Rename

The SYSPRO EFT system allows these fields to be renamed and the user may rename them to Credit-line for easier identification when capturing PRE-FORMAT credit-line numbers. Alternatively if the bank format is not pre-format and the account types are Bond or Subscription the user may rename the EFT USER 1 field to Alternate Account. When BTS is installed and the initialisation program is run, it automatically sets up a validation trigger program after an AP supplier is added, changed or deleted and after a CB beneficiary is added, changed or deleted. This program will warn a user if any relevant banking details are missing and will suggest that they be captured before an EFT run is performed. When an EFT batch is extracted the validation program will automatically run and will NOT create a bank file if any of the relevant banking details are missing. A report will automatically print out with a list of suppliers/beneficiaries whose banking details are missing. The user will need to rectify this and re-extract the batch through the SYSPRO EFT module.