Validating bank details in EFT Processing

For More Info:

See example on EFT Banks screen in the video below: 

What does EFT validate?

You can configure EFT Processing to validate:

  • Field size: minimum and maximum length of EFT details.

  • Valid values: ability to add a list of valid values for certain fields.

Note: In earlier versions, you could only validate the branch code and account number.

When does EFT display a warning message?

When entering EFT details , EFT Processing displays messages in Red to indicate that the requirements are not met. This applies to: 

  • EFT Bank

  • Vendor/Supplier EFT details (Orchid EFT screen)

  • Customer EFT details (on Orchid EFT screen)

  • Employee EFT Details (on Orchid EFT screen)

The warning lets you save the records with the information you already have.

Note: You can update the records at a later stage when you have all the required details.

When does EFT validate the fields?

EFT Processing validates and displays error messages: 

  • When you generate an EFT File in AP Payment Request, AR Payment Request and Employee Payment Request screens. Using EFT: Overview and Tips

  • When you download the file using the EFT File list screen. EFT File List

Note: If the details do not meet the configure requirements, you cannot generate or download a file.

What fields are validated?

EFT Bank

  • Account number and bank code (this has been available in all releases).

  • Extra1 to Extra10 for EFT bank

  • EFT Bank: [SourceReference] used as BankAPPaymentReference, BankARPaymentReference

EFT Vendor and EFT Employee

  • Account number and bank code (this has been available in all releases).

  • All extra fields for Vendor/Supplier/Employee (Extra1 to Extra50)

  • Vendor /Employee payment reference [DestReference]

EFT Customer

  • Account number and bank code (this has been available in all releases).

  • All extra fields for Customer (Extra1 to Extra50)

  • Customer payment reference [DestReference]

How to add validation

Field validation is configured in the EFT Format based on the bank specifications. See details: 

Configuring bank details validation in EFT Processing