EFT Vendors Overview

How to use the screen

Use this form to add EFT details for Vendors defined in Sage 300 A/P.

Field names might be different depending on the Primary Bank set up in EFT Options.

Use the Tab for EFT Processing (A/P and A/R)

Field names also depend on the File Type entered on the EFT Vendor and EFT Customer screens, if using the multiple account details, one per EFT file type option.

Use the for EFT Processing (Payroll) or File Type entered on the EFT Employee screen.  

For detailed field description, see EFT Vendors - Setup Screen

  • Choose Vendor number from the Finder or type the Vendor code

  • Remit To (Optional) : Use this when you have A/P Vendors with different bank account details for different transactions. When creating the A/P Payment, you can select the appropriate Remit-to code (and therefore the correct bank details. This applies to the Vendor's bank account details.

  • File Type (Optional):  The “file type” on the EFT Vendor allows you to specify different bank account details for your EFT vendors/EFT customers depending on the bank or file type you are using to make EFT Payments.

    Note: This field is only available if the "Allow multiple Vendor bank account Details, one per EFT File type" is ticked in EFT Setup > Options> A/P Tab.

    Tip: If you only make EFT transactions from one bank account and only have one EFT File Type in use, do not select this option and use the default EFT File Type. This simplifies the data entry and reduces the risks of duplicate account details.

  • Enter the Vendor's bank details.

  • : select one of Entered, Active or Inactive.

Status needs to be Active to use the record (EFT Vendor, Customer or Employee) in the Create EFT File process.

Example:

You can control who is allowed to make vendors “active” and “inactive” using the Approve/View Unencrypted Vendor Bank Details security group.

Refer to tutorial on Approving changes of EFT Vendor/Customer/Employee details

Importing EFT Vendors

You can import EFT Vendors. For details refer to Importing EFT Details

Tip: When importing EFT Vendors, EFT Customers and EFT Banks, you should not import the Encrypted Bank Branch and Account number and Credit Card Number fields (fields containing an "X").
These fields should only be set using the associated views, and set to the calculated encrypted value. - EFT Import functionality prevents such fields to be imported. Fields starting with X (binary XBSBNO and XACCNO) shouldn't be in the import file.