Electronic Funds Transfer Screens

EFT Bank Setup Wizard

EFT Format Maintenance Screen

EFT File Maintenance Screen

EFT Prenote Generation Screen

EFT Bank Setup Wizard

TWBS Electronic Funds Transfer creates a series of Wizard screens that provides the ability to configure the electronic funds transfer information for each SAP® Business One bank account that needs to be formatted for EFT processing.

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.

Cancel button – Cancels the bank setup process and closes the wizard.

Next button – Moves to the next screen in the bank setup process.

Step 1

Country – The country of the SAP® Business One checking account for EFT configuration.

Bank – The bank of the SAP® Business One checking account for EFT configuration.

Account – The account number of the SAP® Business One checking account for EFT configuration.

Cancel button – Cancels the bank setup process and closes the wizard.

Back button – Moves to the previous screen in the bank setup process.

Next button – Moves to the next screen in the bank setup process.

Step 2

EFT Format – The assigned EFT format of the SAP® Business One checking account for EFT configuration. The TWBS Electronic Funds Transfer application comes with 4 pre installed EFT formats.

NACHA (USA) – EFT format of NACHA (USA), the electronic payments association.

PNC Bank – EFT format of PNC Bank.

Bank of America – EFT format of Bank of America.

Canadian Payment Assoc. – EFT format of Scotia Bank and the Canadian Payment Association.

Define New – Option that allows you to begin the process of creating a custom EFT format from scratch.

Edit Format button – Initiates the process of editing a custom EFT format.

Note – Pre installed EFT formats cannot be edited. To edit a pre installed format, the format must first be copied and then given a custom name.

Copy Format button – Initiates the process of copying a n EFT format (either pre installed or custom) to a new custom EFT format.

Remove Format button – Removes a custom format from TWBS Electronic Funds Transfer.

Note – Pre installed EFT formats cannot be removed. Only

custom created formats can be removed from the system.

Prenote Required checkbox – Designates that a pre note is required by your banking institution to ensure correct EFT formatting and Business Partner information.

Prenote Grace Period – Indicates the pre note grace period required by your banking institution.

Balancing Record Required checkbox – Designates that a balancing record included in your EFT transaction files is required by your banking institution.

Account Type – The account number of the SAP® Business One account for the balancing record.

Checking

Savings

Account No. – The account number of the SAP® Business One account for the balancing record.

Cancel button – Cancels the bank setup process and closes the wizard.

Back button – Moves to the previous screen in the bank setup process.

Next button – Moves to the next screen in the bank setup process.

Step 3

Note – The fields to be completed on Step 3 of the EFT Bank

Setup will vary according to the EFT format specified in Step

<ol start="2" style="list-style-type: decimal;">

<li>

<p>

Any fields in the EFT format file designated as an Entry Field will appear on this screen.

</p>

</li>

</ol>

Cancel button – Cancels the bank setup process and closes the wizard.

Back button – Moves to the previous screen in the bank setup process.

Next button – Moves to the next screen in the bank setup process.

Step 4

Prenote File path – Designates the network file path that will be used to store the generated pre note files.

Transactions File path – Designates the network file path that will be used to store the generated transaction files.

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.

Printer – Indicates the local or network printer to be used for printing EFT remittance reports.

Bin – Indicates the bin (or tray) of the local or network printer to be used for printing EFT remittance reports.

Format – Designates the remittance report format to be used. Several pre installed 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.

From Name – Designates the descriptive name of the sender of the remittance email.

From Email – Designates the email address of the sender of the remittance email.

Email Subject – Designates the subject line text of the remittance email.

Email Body – Designates the email content text of the remittance email.

Archive To – Designates the network file path that will be utilized to save a backup copy of the remittance email.

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

Server Credentials checkbox – Indicates that security credentials need to be provided to facilitate the sending of remittance emails.

Password – Designates the password required for the SMTP Server.

Port # – Designates the port # of the SMTP Server.

Enable SSL checkbox – Enables SSL encryption.

Cancel button – Cancels the bank setup process and closes the wizard.

Back button – Moves to the previous screen in the bank setup process.

Finish button – Completes the EFT bank setup process and saves the configuration information to the database.

EFT Format Maintenance Screen

TWBS Electronic Funds Transfer creates a screen through the SAP® Business One User Interface (UI) that provides the ability to modify the record types and record type lengths included in the EFT file format for EFT processing in SAP® Business One.

Click the Copy Format button or select the Define New option from the EFT Format field on the EFT Bank Setup Wizard step 2 screen to load

the TWBS EFT Format Maintenance screen.

Format Name – The unique name of the new EFT format.

Country – The country of the new EFT format.

Rec. Code – The code of the Record Type for the line of the new EFT format.

Note – The Rec. Code value will be automatically assigned on the selection of the Record Type field.

Record Type – The type of data record for the line of the new EFT format.

Note – When copying a pre existing EFT file format, the Record Type values will

be automatically populated with the values for the EFT file format being used as a copying template. Record Type values can be added or deleted as needed.

Max. Length – The maximum length of characters of the data record for the line of the new EFT format.

**Note –** The Max. Length value is used on the EFT File Maintenance Screen when editing and saving an EFT file format. All Record Type entries on the EFT File Maintenance Screen **must** add up to the number of characters specified in the Max. Length column.

Country – The country of the new EFT format.

Order # – The # for the order in which the data record will appear when the EFT transaction file is generated.

Note – When copying a pre existing EFT file format, the Order # value will be assigned in the way that it was populated for the EFT file format being used as a copying template.

Save and Continue button – Saves the EFT file format record type information and opens the EFT File Maintenance Screen.

Cancel button – Cancels the EFT file format creation process and closes the form.

TWBS Advanced Productivity Pack (APP) User Guide

EFT File Maintenance Screen

TWBS Electronic Funds Transfer creates a screen through the SAP® Business One User Interface (UI) that provides the ability to modify the details of the record type lines for an EFT file format for EFT processing in SAP® Business One.

Click the Copy Format button or select the **Define New** option from the **EFT** Format field on the EFT Bank Setup Wizard step 2 screen to load

the TWBS EFT Format Maintenance screen.

Format Name – The unique name of the new EFT format.

Record Type – The type of data record for the EFT format field.

Note – The Record Type values available for selection will be dependant on the information entered for the EFT file format on the EFT

Format Maintenance Screen.

Description – The description of the EFT format field.

Source – The data source of the EFT format field of the new EFT format.

Blank – The value will consist of blank (empty) spaces.

Constant – The value will consist of a constant hard-coded value specified in the Value column.

Data Field – The value will be obtained from another database field specified in the Table and Field columns.

**Entry Field –** The value will be entered on the EFT Bank Setup Wizard step 3 screen at the time of EFT Bank setup.

System Field – The value will be obtained from the system based on the value specified in the Data Type column.

Transferred Field – The value will be obtained from another record field specified in the TransferredRecordName and TransferredFieldName columns.

Mandatory – Indicates if the EFT format field is required.

Mandatory – The data record is mandatory.

Optional – The data record is optional.

Required – The data record is required.

Data Type – The data type of the EFT format field.

Alphanumeric

Blank

Transaction Code

Batch Date

Immediate Origin Code

Transaction Trace Number

Transit Routing Number

Company Entry Description

Company Descriptive Date

Julian Date (NACHA)

Transaction Amt

Numeric

Service Class Code

Entry Addenda Count

Batch Entry Hash

Total Debit Entry Amt

Trace Number Seq

Batch Tim

File ID Modifier

Total Credit Entry Amt

Batch Number

Total Debit Entry Amt

Total Credit Entry Amt

Batch Count

Block Count

Entry/Addenda Count

Entry Hash

Count of Debits

Count of Credits

Canadian Batch Number

Julian Date (Canada)

Entry Effective Date

Payment Number

Length – The length in characters of the EFT format field.

**Note –** All Record Type entries on the EFT File Maintenance Screen **must** add up to the number of characters specified in the Max. Length column of the EFT Format Maintenance Screen.

StartColumn – The character position of the Record Type where the EFT format field will begin.

Note – The StartColumn value will be calculated automatically and may change based upon changes to the Length or Record Type columns.

Value – The value of the EFT format field. This column is used in conjunction with the Constant Data Source value.

Table – The table from which the value of the EFT format field will be obtained. This column is used in conjunction with the Data Field and Entry

“@TWBS_EFT_VALUES” “U_Value”.

Field Data Source values.

Field – The field of the Table from which the value of the EFT format field will be obtained. This column is used in conjunction with the Data Field and Entry Field Data Source values.

Note – If using the Entry Field Data Source value, the

Table should be specified as and the

Field should be specified as

Note – If using the Data Field Data Source value, the Field can be either a basic table field or a user defined field.

TransferredRecordName – The Record Type of the field from which the value of the EFT format field will be obtained. This column is used in conjunction with the Transferred Field Data Source value. TransferredFieldName– The Description of the field from which the value of the EFT format field will be obtained. This column is used in conjunction with the Transferred Field Data Source value.

FillChar – The character to be used as a specific filler character for the entirety of the entered Length value.

Back button – Returns to the EFT Format Maintenance Screen without saving the EFT file format information.

Save and Continue button – Saves the EFT file format information. Cancel button – Cancels the EFT file format creation process and closes the form.

EFT Prenote Generation Screen

TWBS Electronic Funds Transfer creates a screen through the SAP® Business One User Interface (UI) that provides the ability to generate pre notes to be submitted to your banking institution for data and format verification.

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

Country – The country of the SAP® Business One checking account for EFT pre note generation..

Bank – The bank of the SAP® Business One checking account for EFT pre note generation..

Account – The account number of the SAP® Business One checking 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.

Ok button – Closes the form.

Create Prenote button – Initiates the generation of the pre note file.

Recreate Prenote button – Initiates the re-generation of the pre note file in cases of modifications.