Wiki

Scale Your Enterprise

User Tools

Site Tools

mbstring extension must be loaded in order to run mPDF

app:eft_how_to

This is an old revision of the document!


Using Electronic Funds Transfer

How To Generate an EFT Prenote

Many US Banks require the pre note verification process before an EFT transaction can be entered for a Business Partner. When the pre note is generated an EFT file is created with $0 transactions for each Business Partner listed. If the bank finds that the file is not formatted correctly, has incorrect account or routing numbers or for some other reason does not work on their system, the bank will inform the sender so corrections can be made.

Occasionally pre notes will need to be re-run for all Business Partners for a selected bank. The Recreate Pre notes process is available on the same form.

Since the Canadian Payments Association (CPA) standard for EFT do not allow for $0 dollar transmissions, Canadian pre note files cannot be transmitted.

Click the SAP menu option titled TWBS EFT Prenote under the Banking menu to load the TWBS EFT Prenote screen.

image851.jpeg

Select the Country for EFT pre note generation.

Select the Bank for EFT pre note generation.

Select the Account for EFT pre note generation.

Note – The Country, Bank, and Account selected for pre note generation should already have been configured. For more information on this process, refer to the How To

image853.jpeg

Configure an SAP® Business One Bank Account page of the user guide.

image854.jpeg

Click the Create Prenote button.

Note – A system message will give you the name and file path of the generated EFT pre note file. The file can be sent to your banking institution for review.

image822.jpeg

How To Designate an Invoice for EFT Processing

The Payment Method associated with an invoice determines how that invoice will be paid. To designate that an Invoice is being used to pay vendors (A/P Invoice) or receive payments from customers (A/R Invoice), be sure that the payment method of the document is a bank transfer payment method associated with a bank account setup for TWBS EFT processing.

Each business partner in SAP® Business One has a default associated payment method.

Click the SAP menu option titled Business Partner Master Data under the Business Partners menu to load the Business Partner Master Data screen. Navigate to the Business Partner that you want to configure for EFT processing. Click on the Payment Run tab.

The Payment Method identified in bold is the default value associated with the business partner.

image855.jpeg

image856.jpeg

When an A/R Invoice (customer's incoming payments) or A/P Invoice (outgoing payments to vendors) marketing documents are created in the SAP® Business One system, the document will be assigned the default value from the corresponding business partner.

image857.jpeg

image858.jpeg

If the payment method of a document is set to a payment method set up for TWBS EFT processing as an incoming or outgoing bank transfer method, the document will be eligible to be included in the EFT transaction file generation process through the Payment Wizard.

Note – The payment method can either be automatically assigned based on business partner default settings or it can be manually selected during the creation of the document.

image85.jpeg

How To Execute SAP® B1 Payment Wizard for EFT Processing

Both incoming and outgoing EFT transactions are processed through the SAP® Business One Payment Wizard. During the process, validation checks will be run. At the completion of the Payment Wizard you will have the option of generating the EFT transaction files to be transmitted to your banking institution.

Click the SAP menu option titled Payment Wizard under the Banking menu to load the Payment Wizard screen.

image859.jpeg

Click the Next button.

image860.jpeg

Select either the Start New Payment Run option.

Click the Next button.

or Load Saved Payment Run

image861.jpeg

Select the Payment Type values to be included in the Payment Wizard run.

Select the Payment Means values to be included in the Payment Wizard run.

Note – The Bank Transfer option of Payment Means must be selected for EFT processing.

image862.jpeg

Click the Next button.

image863.jpeg

Enter the business partner selection criteria and populate the list.

Select the business partners for the Payment Wizard run.

Click the Next button.

image864.jpeg

Enter the document parameters selection criteria for documents to be included in the Payment Wizard run.

The EFT File Effective Date will be automatically defaulted to the current date and used in the generation of the EFT transaction files. If an alternate effective date is desired, specify the date to be used.

Click the Next button.

image865.jpeg

Select the payment methods to be included in the Payment Wizard run.

Click the Next button.

image866.jpeg

Review the business partners and documents selected to be included in the Payment Wizard run. Deselect any business partners and/or documents that you do not want to include.

Click the Next button.

image867.jpeg

Select the Execute Payment Run option.

Click the Next button.

image868.jpeg

Click the Ok button on the Payment Wizard confirmation screen.

image869.jpeg

If the Payment Wizard is successful, click the Ok button on the success message.

image870.jpeg

The Payment Wizard Summary and Printing screen will indicate how many Bank Transfers were added.

To generate the EFT transaction documents, click the Generate EFT Files button.

image871.jpeg

A screen will load. After a few minutes, the screen will list all of the EFT transaction files that have been generated and the location in which the files have been placed according to the bank setup.

Click the Ok button on the message box.

Close the TWBS - Process EFT File screen to return to Step 8 of the Payment Wizard Screen.

To generate EFT remittances, click the Generate EFT Remittances button.

Click the Finish button to complete the Payment Wizard.

image34.jpeg

How To Copy an EFT Format

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.

image802.jpeg

Click the Next button.

image803.jpeg

image22.jpeg Select the Country for EFT processing.

Select the Bank for EFT processing.

image22.jpeg

image22.jpeg Select the Account for EFT processing.

image22.jpeg Click the Next button.

image804.jpeg

Select EFT format name for the EFT format to be used as a template for you EFT Format copy.

Click the Copy Format button.

image872.jpeg

Enter the Format Name of the new EFT format.

Click the Save and Continue button. This will load the EFT File Maintenance screen.

Warning – The EFT File Maintenance may take several minutes to load depending on the size of the EFT format being loaded onto the screen.

image873.jpeg

image874.jpeg

Complete the needed modifications as laid out by your banking institutions EFT file format specification document.

Click the Save button.

Warning – While saving the EFT file format, validations will be performed to ensure that each modified line conforms to the length defined on the EFT Format Maintenance screen.

image875.jpeg

The user will be returned to the EFT Bank Setup Wizard screen and the newly copied format's name will now be displayed in the EFT Format selection combo box.

image34.jpeg

How To Remove an EFT Format

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.

image802.jpeg

Click the Next button.

image803.jpeg

image22.jpeg Select the Country for EFT processing.

Select the Bank for EFT processing.

image22.jpeg

image22.jpeg Select the Account for EFT processing.

image22.jpeg Click the Next button.

image876.jpeg

Select EFT format name for the EFT format to be removed.

image877.jpeg

Note – Pre installed EFT formats cannot be removed. Only custom created formats can be removed from the system.

image878.jpeg

Click the Remove Format button.

image879.jpeg

Click the Yes button on the confirmation message box.

The EFT Format will be removed from the database.

Warning – EFT Format removal is not reversible. Once a format has been removed, it cannot be recovered.

image880.jpegimage34.jpeg

app/eft_how_to.1564380487.txt.gz · Last modified: 2019/07/29 02:08 by dtucker