This is an old revision of the document!
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.
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
Configure an SAP® Business One Bank Account page of the user guide.
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.
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.
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.
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.
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.
Click the Next button.
Select either the Start New Payment Run option.
Click the Next button.
or Load Saved Payment Run
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.
Click the Next button.
Enter the business partner selection criteria and populate the list.
Select the business partners for the Payment Wizard run.
Click the Next button.
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.
Select the payment methods to be included in the Payment Wizard run.
Click the Next button.
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.
Select the Execute Payment Run option.
Click the Next button.
Click the Ok button on the Payment Wizard confirmation screen.
If the Payment Wizard is successful, click the Ok button on the success message.
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.
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.
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.
Select EFT format name for the EFT format to be used as a template for you EFT Format copy.
Click the Copy Format button.
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.
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.
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.
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.
Select EFT format name for the EFT format to be removed.
Note – Pre installed EFT formats cannot be removed. Only custom created formats can be removed from the system.
Click the Remove Format button.
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.