This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
app:eft_screens [2019/07/29 00:03] dtucker [Wizard Step 3] |
app:eft_screens [2019/07/29 02:02] (current) |
||
|---|---|---|---|
| Line 67: | Line 67: | ||
| * **<color # | * **<color # | ||
| * **<color # | * **<color # | ||
| - | |||
| - | {{: | ||
| ==== Wizard Step 3 ==== | ==== Wizard Step 3 ==== | ||
| Line 85: | Line 83: | ||
| {{: | {{: | ||
| - | **Prenote File path –** Designates the network file path that will be used to store the generated pre note files. | + | * **Prenote File path** |
| + | * **Transactions File path** - Designates the network file path that will be used to store the generated transaction | ||
| - | {{: | + | <WRAP center round info 90%> |
| + | File paths entered must be reachable by client workstations that will be using the EFT add-on. | ||
| + | </ | ||
| - | **Transactions | + | <WRAP center round info 90%> |
| + | Even if the <color #00a2e8>**Pre-note Required**</ | ||
| + | </ | ||
| - | {{: | + | <WRAP center round important 90%> |
| + | 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.</ | ||
| - | **Note –** File paths entered must be reachable by client workstations | + | |
| + | * **Incoming Payment Report** | ||
| - | {{: | + | <WRAP center round info 90%> |
| + | All delivery setup and administration is performed through the APP **Reports Maintenance** screen. | ||
| + | </ | ||
| - | **Note –** Even if the **Pre-note Required** field was not selected, a **Pre-note File Path** must be specified. | + | |
| + | | ||
| + | | ||
| - | {{:app/image811.jpeg?584x52}} | + | {{:app/image44.jpeg?786}} |
| - | + | ||
| - | **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 ({{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Once a remittance format file has been selected, it can be modified through the Configurator by clicking on the Link To arrow ({{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Password –** Designates the password required for the **SMTP Server**. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Port # –** Designates the port # of the **SMTP Server**. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Enable SSL checkbox –** Enables SSL encryption. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| Line 170: | Line 117: | ||
| ===== EFT Format Maintenance Screen ===== | ===== 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. | 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 <color #22b14c>**Copy Format**</ | |
| - | + | ||
| - | Click the **Copy Format** button or select the **Define New** option from the **EFT** **Format** field on the [[#page821|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. | + | * <color #00a2e8>**Format Name**</ |
| + | * <color # | ||
| + | * **<color # | ||
| + | <WRAP center round info 90%> | ||
| + | The **<color # | ||
| + | </ | ||
| - | **Country –** The country | + | |
| + | <WRAP center round info 90%> | ||
| + | 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. | ||
| + | </ | ||
| + | * **<color # | ||
| - | **Rec. Code –** The code of the **Record Type** | + | <WRAP center round info 90%> |
| + | The <color #00a2e8>**Max. Length**</ | ||
| + | </ | ||
| - | {{:app/image67.jpeg? | + | * **<color # |
| + | * **<color # | ||
| - | **Note –** The Rec. Code value will be automatically | + | <WRAP center round info 90%> |
| + | When copying an existing EFT file format, the <color #00a2e8>**Order #**</ | ||
| + | </ | ||
| - | {{:app/image838.jpeg? | + | * **<color # |
| + | * **<color # | ||
| - | **Record Type –** The type of data record for the line of the new EFT format. | + | {{:app/image44.jpeg?786}} |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Note –** When copying a pre existing EFT file format, the Record Type values will | + | |
| - | + | ||
| - | {{:app/image839.jpeg?575x220}} | + | |
| - | + | ||
| - | 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. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | [[# | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **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 [[# | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Cancel button –** Cancels the EFT file format creation process and closes the form. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | | + | |
| ===== EFT File Maintenance Screen ===== | ===== 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. | |
| - | + | ||
| - | TWBS Electronic Funds Transfer creates a screen | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Click the **Copy Format** button or select the [[# | + | |
| - | the TWBS EFT Format Maintenance screen. | + | * Click the <color # |
| {{: | {{: | ||
| - | {{: | + | * <color #00a2e8>**Format Name**</ |
| - | {{:app/image80.jpeg?771}} | + | * <color # |
| - | **Record Type –** The type of data record | + | <WRAP center round info 90%> |
| + | The <color #00a2e8>Record Type</ | ||
| + | </ | ||
| - | {{:app/image311.jpeg? | + | * <color # |
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * **<color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * **<color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * **<color # | ||
| - | **Note –** The Record Type values available [[# | + | <WRAP center round info 90%> |
| - | + | All Record Type entries on the **EFT File Maintenance** screen | |
| - | {{: | + | |
| - | + | ||
| - | 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. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | [[# | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **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. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | | + | |
| - | + | ||
| - | **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/ | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **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. | + | |
| - | + | ||
| - | <WRAP center round info> | + | |
| - | All Record Type entries on the EFT File Maintenance | + | |
| </ | </ | ||
| - | * **StartColumn | + | * **<color #00a2e8>StartColumn</ |
| - | <WRAP center round info> | + | <WRAP center round info 90%> |
| - | The StartColumn value will be calculated automatically and may change based upon changes to the Length or Record Type columns. | + | The StartColumn value will be calculated automatically and may change based upon changes to the <color # |
| </ | </ | ||
| - | * **Value | + | * **<color #00a2e8>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 Field** **Data Source** values. | + | * **<color #00a2e8>Table</ |
| - | + | * **<color #00a2e8>Field</ | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | " | + | |
| - | + | ||
| - | * **Field | + | |
| {{: | {{: | ||
| - | **Note –** If using the **Entry Field Data Source** value, the | + | <WRAP center round info 90%> |
| + | If using the <color #00a2e8>**Entry Field Data Source**</ | ||
| + | </ | ||
| - | {{:app/image847.jpeg?571x88}} | + | {{:app/image849.jpeg?772x47}} |
| - | * **Table** should be specified as and the | + | <WRAP center round info 90%> |
| - | * **Field** should be specified as | + | If using the <color #00a2e8>**Data Field Data Source**</ |
| - | + | </ | |
| - | {{: | + | |
| - | + | ||
| - | **Note –** If using the **Data Field Data Source** value, the **Field** can be either a basic table field or a user defined field. | + | |
| - | * **TransferredRecordName | + | * **<color #00a2e8>TransferredRecordName</ |
| - | * **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. | + | * **<color #00a2e8>TransferredFieldName</ |
| {{: | {{: | ||
| - | * **FillChar | + | * **<color #00a2e8>FillChar</ |
| - | * **Back button | + | * **<color #22b14c>Back</ |
| - | * **Save and Continue button | + | * **<color #22b14c>Save and Continue</ |
| - | * **Cancel button | + | * **<color #22b14c>Cancel</ |
| {{: | {{: | ||