This is an old revision of the document!
Table of Contents
Container Management (Web Client) Screens
- 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.
