Electronic Funds Transfer (EFT)

The TWBS Electronic Funds Transfer integrates directly with SAP® Business One providing unified transaction file creation, transaction recording and remittance printing eliminating the need for double-entry!

Seamlessly integrated completely within SAP® Business One.

Conveniently creates bank transfer files formatted for your bank.

Essentially prints detailed remittances for vendors.

Effortlessly delivers remittances via e-mail.

Quick and easy to set up.

Accommodates EFT contract termination dates.

Note – The TWBS Electronic Funds Transfer User Guide assumes that the person reading is already well-versed in the Bank Account, Business Partner and Check printing processes that are native to the SAP® Business One system. To attain training in SAP® Business One, contact your SAP® Partner or visit the SAP® Business One Customer Portal website.

Warning – The printing of EFT Remittances is not supported in the 64-bit version of the SAP® Business One 9.0 release of this application at this time.

Note – The TWBS Electronic Funds Transfer is not responsible for any data transmissions to your banking institution. It is only responsible for the generation of data from the SAP® Business One system in the specified EFT format. Transmission of the transaction data files is solely the responsibility of the end customer.

Electronic Funds Transfer Screens

Using Electronic Funds Transfer

Electronic Funds Transfer Training Video Series

Configuring Electronic Funds Transfer

How To Configure an SAP® Business One Bank Account How To Configure SAP® B1 Payment Methods for EFT How To Configure Business Partner Banking Info

How To Configure an SAP® Business One Bank Account

Click the SAP menu option titled TWBS EFT Bank Setup Wizard under the Administration -Setup -Banking menus to load the TWBS EFT Bank Setup Wizard screen.

Click the Next button.

Select the Country for EFT processing.

Select the Bank for EFT processing.

Select the Account for EFT processing.

Click the Next button.

Note – The TWBS Electronic Funds Transfer application comes with 4 pre installed EFT

formats (NACHA-US, PNC Bank, Bank of America, and Canadian Payment Association/Scotia Bank).

Select EFT format name for the format required by your banking institution from the provided list. To create an EFT format in the application you can either select the Define New option to create the format from scratch or you can select one of the existing formats and click the Copy Format button. Creating an EFT format will be covered in the How To Copy an EFT Format section of the EFT user guide.

Note – If you are unsure of the format that is required for your banking institution, please contact them and request a document outlined their required EFT format.

Warning – An EFT format selection is required before the bank configuration can continue.

If your bank requires a pre note to ensure correct EFT formatting and Business Partner information, select the Pre note Required field and add a value to the Pre note Grace Period field based on your banking institutions specifications. If your bank does not require pre notes, you may leave the Pre note Required field unselected.

If your bank requires a balancing record in the EFT file, select the Balancing Record Required box and select the Account Type and Account No. to be applied for the balancing record. If your bank does not require a balancing record, leave the Balancing Record Required field unselected. Click the Next button.

On the EFT Setup Data screen, enter the Entry Data type field information. Many of the values can be found in the account specific information provided by your bank institution. The available fields on this window will vary depending upon which EFT format you chose or created on the previous screen.

Click the Next button.

When EFT transaction and pre note files are created, they will be written to the

folders you specify here. Each time new files are created, you will retrieve them from this location and transmit them to your bank.

Note – File paths entered must be reachable by client workstations that will be using the EFT add-on.

Note – Even if the Pre-note Required field was not selected, a Pre-note File Path must be specified.

Note – The TWBS Electronic Funds Transfer is not responsible for any data transmissions to your banking institution. It is only responsible for the generation of data from the SAP® Business One system in the specified EFT format. Transmission of the transaction data files is solely the responsibility of the end customer.

To print EFT remittances…

Select the Printer and the printer's Bin (or tray) for the printing.

Select the remittance report Format to be used. Several formats are provided for you on installation. These formats can either be used as installed or they can be modified to meet your specifications.

Click the file search button () to the right of the Format field to browse for a remittance format.

Once a remittance format file has been selected, it can be modified through the Configurator by clicking on the Link To arrow () to the left of the Format field. This will open the Configurator and load the selected remittance format file for editing.

To deliver EFT remittances by email…

Enter the From Name for the descriptive name of the sender of the remittance email.

Enter the From Email for the email address of the sender of the remittance email.

Enter the Email Subject for the subject line text of the remittance email.

Enter the Email Body for the email content text of the remittance email.

Define a network path in the Archive To field to designate a place for a backup copy of the remittance email.

Enter the SMTP Server for the email server to be used for the sending of the remittance email.

If your SMTP Server requires you to enter credentials, select the Server

Credentials box.

Enter the Password required for the SMTP Server.

Enter the Port # of the SMTP Server.

Select the Enable SSL checkbox to turn on SSL encryption.

Click the Finish button.

Note – This configuration process should be repeated for each SAP® Business One account that will be used in .

How To Configure SAP® B1 Payment Methods for EFT

Click the SAP menu option titled Payment Methods under the Administration -Setup -Banking menus to load the Payment Methods - Setup screen.

If the form doesn't load in Add mode, click the Add () button on the SAP icon bar.

Note – In order to process both Incoming (Customer payments) to you and Outgoing (Vendor payments to your vendors) EFT transactions, separate Incoming and Outgoing Bank Transfer Payment Methods will need to be created for each CountryBankAccount combination to be used for Electronic Funds Transferring.

Enter a Payment Method Code for your new Payment Method.

Enter a Description for your new Payment Method.

Select a Payment Type (Incoming or Outgoing) for your new Payment Method.

Select the option of Bank Transfer for the Payment Means of your new Payment Method.

Select the Country for the House Bank Account for your new Payment Method.

Select the Bank for the House Bank Account for your new Payment Method.

Select the Account for the House Bank Account for your new Payment Method.

Note – If the Payment Type is Outgoing, this is the account from which the funds will be drawn for the transfer. If the Payment Type is Incoming, this is the account to which funds will be deposited.

Click the Add button.

Outgoing Payment Method Sample

Incoming Payment Method Sample

How To Configure Business Partner Banking Info

Click the SAP menu option titled Business Partner Master Data under the Business Partners menu to load the Business Partner Master Data screen.

Note – Bank account data for business partners is entered and maintained on the Payment Terms tab of the Business Partner Master Data form.

Navigate to the Business Partner that you want to configure for EFT processing.

Click on the Payment Run tab.

Select Include next to the bank transfer payment method(s) you would like to use with this business partner.

Note – TWBS EFT does not control how Payment methods are assigned to invoices. Payment methods are assigned to invoices by the SAP Business One Payment Wizard.

Note – The House Bank field is an optional SAP® Business One field. If it is used in versions prior to SAP® Business One 2005 SP1, it will override any bank associated with a payment method. For versions SAP® Business One 2005 SP1 and after, the House Bank field will no longer override the payment method bank.

Click on the Payment Terms tab.

Click the Choose From List icon to the right of the Bank Country field. This will load the Business Partner Bank Accounts - Setup screen.

Select the business partner's bank.

Note – If the Business Partners bank is not listed, click the SAP menu option titled Banks under the Administration -Setup -Banking menus to load the Banks - Setup screen. Once the bank setup has been completed, you can return to this step.

Enter the Account number for the business partner's bank account. Click the Update button on the Business Partner Bank Accounts - Setup screen.

Click the Ok button on the Business Partner Bank Accounts - Setup screen to return to the Business Partner Master Data screen.

Enter the EFT DFI Transit Routing number and EFT Account Type into the fields on the Payment Terms tab.

If you wish to use a termination date, enter a valid date into the optional EFT Termination Date field.

If you are using a pre note, the EFT Activation Date field will be filled in when the pre note is created. If the bank associated with the Business Partner’s bank transfer payment method does not require a pre note, then the activation date will be ignored by the system.

Click the Add button for a new business partner or the Update button for an existing business partner.

Warning – Any changes made to EFT data (DFI Transit Routing number, Account Type, or bank Account) on the Payment Terms tab will cause the activation date to be set to null. If pre notes are required, this will result in the business partner becoming ineligible for EFT until they have once again been pre noted and the pre note grace period has passed.