Table of Contents
Electronic Funds Transfer Screens
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.
Wizard Intro Screen
- Cancel button - Cancels the bank setup process and closes the wizard.
- Next button - Moves to the next screen in the bank setup process.
Wizard 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.
Wizard 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 pre-installed EFT formats or you can create your own format either from scratch or by using one of the existing EFT formats as a copying template.
- 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.
- 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.
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.
Pre installed EFT formats cannot be removed. Only custom created formats can be removed from the system.
- Pre-note Required checkbox - Designates that a pre-note is required by your banking institution to ensure correct EFT formatting and Business Partner information.
- Pre-note 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.
- Block Fill Lines Required checkbox - Designates that EFT format requires that data files be populated in a specified number of line blocks.
- Block # of Lines Required - The number of lines required in each block of data in the EFT format file.
- Block Fill Character - The character to be used on fill lines required to complete the final block of data in the EFT format file.
The Block Fill Character can only be specified as a single character. Multiple characters cannot be used.
- Block Fill LineLength - The # of characters to be used for fill lines required to complete the final block of data in the EFT format file.
- 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.
Wizard Step 3
The fields to be completed on Step 3 of the EFT Bank Setup will vary according to the EFT format specified in Step 2. Any fields in the EFT format file designated as an Entry Field will appear on this screen.
- 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.
Wizard 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.
File paths entered must be reachable by client workstations that will be using the EFT add-on.
Even if the Pre-note Required field was not selected, a Pre-note File Path must be specified.
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.
- Outgoing Payment Report - Designates the APP report that will be used to generate outgoing EFT payment remittances.
- Incoming Payment Report - Designates the APP report that will be used to generate incoming EFT payment remittances.
All delivery setup and administration is performed through the APP Reports Maintenance screen.
- 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.
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 column - The code of the Record Type for the line of the new EFT format.
The Rec. Code column value will be automatically assigned on the selection of the Record Type field.
- Record Type column - The type of data record for the line of the new EFT format.
When copying an 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 column - The maximum length of characters of the data record for the lines of the new EFT format.
The Max. Length column 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 column - The country of the new EFT format.
- Order # column - The # for the order in which the data record will appear when the EFT transaction file is generated.
When copying an 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.
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 column - The type of data record for the EFT format field.
The Record Type column values available for selection will be dependent on the information entered for the EFT file format on the EFT Format Maintenance screen.
- Description column - The description of the EFT format field.
- Source column - 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.
- Required column - 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 column - 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 column - The length in characters of the EFT format field.
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 column - The character position of the Record Type where the EFT format field will begin.
The StartColumn value will be calculated automatically and may change based upon changes to the Length or Record Type columns.
- Value column – The value of the EFT format field. This column is used in conjunction with the Constant Data Source value.
- Table column – 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.
- Field column – 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.
If using the Entry Field Data Source value, the Table should be specified as @TWBS_EFT_VALUES and the Field should be specified as U_Value.
If using the Data Field Data Source value, the Field can be either a basic table field or a user defined field.
- TransferredRecordName column – 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 column – 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 column – 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 Pre-note 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..
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 section of the user guide.
- Ok button – Closes the form.
- Create Pre-note button – Initiates the generation of the pre-note file.
- Recreate Pre-note button – Initiates the re-generation of the pre note file in cases of modifications.