Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace:
app:eft_screens

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
app:eft_screens [2019/07/26 15:32]
dtucker 		app:eft_screens [2019/07/29 02:02] (current)
Line 5: Line 5:
 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. 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 <color #22b14c>**TWBS EFT Bank Setup Wizard**</color> under the <color #22b14c>**Administration**</color> {{:app/image35.jpeg?17x16}} <color #22b14c>**Setup**</color> {{:app/image35.jpeg?17x16}} <color #22b14c>**Banking**</color> menus to load the **TWBS EFT Bank Setup Wizard** screen.
  
- +==== Wizard Intro Screen ====
-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.+
  
 {{:app/image802.jpeg?599x400}} {{:app/image802.jpeg?599x400}}
  
-**Cancel button –** Cancels the bank setup process and closes the wizard.+  * **<color #22b14c>Cancel</color> button** - Cancels the bank setup process and closes the wizard. 
 +  * **<color #22b14c>Next</color> button** - Moves to the next screen in the bank setup process.
  
- +==== Wizard Step 1 ====
- +
-**Next button –** Moves to the next screen in the bank setup process. +
- +
- +
- +
-**Step 1**+
  
 {{:app/image803.jpeg?599x400}} {{:app/image803.jpeg?599x400}}
  
-**Country –** The country of the SAP® Business One checking account for EFT configuration.+  * <color #00a2e8>**Country**</color> - The country of the SAP® Business One checking account for EFT configuration. 
 +  * <color #00a2e8>**Bank**</color> - The bank of the SAP® Business One checking account for EFT configuration. 
 +  * <color #00a2e8>**Account**</color> - The account number of the SAP® Business One checking account for EFT configuration.
  
 +  * **<color #22b14c>Cancel</color> button** - Cancels the bank setup process and closes the wizard.
 +  * **<color #22b14c>Back</color> button** - Moves to the previous screen in the bank setup process.
 +  * **<color #22b14c>Next</color> button** - Moves to the next screen in the bank setup process.
  
 +==== Wizard Step 2 ====
  
-**Bank –** The bank of the SAP® Business One checking account for EFT configuration.+{{:app:eft_bank_setup_wiz_03.jpg?nolink&600|}}
  
 +  * <color #00a2e8>**EFT Format**</color> - 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.
 +    * <color #00a2e8>**Define New**</color> – Option that allows you to begin the process of creating a custom EFT format from scratch.
 + 
 +  * **<color #22b14c>Edit Format</color> button** - Initiates the process of editing a custom EFT format.
 +  * **<color #22b14c>Copy Format</color> button** - Initiates the process of copying a n EFT format (either pre installed or custom) to a new custom EFT format.
 +  * **<color #22b14c>Remove Format</color> button** - Removes a custom format from TWBS Electronic Funds Transfer.
  
 +<WRAP center round info 90%>
 +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.
 +</WRAP>
  
-**Account –** The account number of the SAP® Business One checking account for EFT configuration.+<WRAP center round info 90%> 
 +Pre installed EFT formats **cannot** be removed. Only custom created formats can be removed from the system. 
 +</WRAP>
  
 +  * **<color #00a2e8>Pre-note Required</color> checkbox** - Designates that a pre-note is required by your banking institution to ensure correct EFT formatting and Business Partner information.
 +    * <color #00a2e8>**Pre-note Grace Period**</color> - Indicates the pre-note grace period required by your banking institution.
  
 +  * **<color #00a2e8>Balancing Record Required</color> checkbox** - Designates that a balancing record included in your EFT transaction files is required by your banking institution.
 +    * <color #00a2e8>**Account Type**</color> - The account number of the SAP® Business One account for the balancing record.
 +      * <color #00a2e8>**Checking**</color>
 +      * <color #00a2e8>**Savings**</color>
 +    * **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.+  * **<color #00a2e8>Block Fill Lines Required</color> checkbox** - Designates that EFT format requires that data files be populated in a specified number of line blocks. 
 +    * <color #00a2e8>**Block # of Lines Required**</color> - The number of lines required in each block of data in the EFT format file. 
 +    * <color #00a2e8>**Block Fill Character**</color> - The character to be used on fill lines required to complete the final block of data in the EFT format file.
  
 +<WRAP center round info 90%>
 +The <color #00a2e8>**Block Fill Character**</color> can only be specified as a single character. Multiple characters **cannot** be used.
 +</WRAP>
  
 +    * <color #00a2e8>**Block Fill LineLength**</color> - The # of characters to be used for fill lines required to complete the final block of data in the EFT format file.
  
-**Back button –** Moves to the previous screen in the bank setup process.+  * **<color #22b14c>Cancel</color> button** - Cancels the bank setup process and closes the wizard. 
 +  * **<color #22b14c>Back</color> button** - Moves to the previous screen in the bank setup process. 
 +  * **<color #22b14c>Next</color> button** - Moves to the next screen in the bank setup process.
  
- +==== Wizard Step 3 ====
- +
-**Next button –** Moves to the next screen in the bank setup process. +
- +
- +
- +
-**Step 2** +
- +
-{{:app/image804.jpeg?599x400}} +
- +
-**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. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-PNC Bank **–** EFT format of PNC Bank. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-Bank of America **–** EFT format of Bank of America. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-Canadian Payment Assoc. **–** EFT format of Scotia Bank and the Canadian Payment Association. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-Define New **–** Option that allows you to begin the process of creating a custom EFT format from scratch. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**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. +
- +
-{{:app/image85.jpeg?571x86}} +
- +
-**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 +
- +
-{{:app/image829.jpeg?571x35}} +
- +
-custom created formats can be removed from the system. +
- +
-{{:app/image830.jpeg?571x30}} +
- +
-**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. +
- +
- +
- +
-{{:app/image128.jpeg?0x10}} **Account Type –** The account number of the SAP® Business One account for the balancing record. +
- +
-Checking +
- +
- +
- +
-Savings +
- +
- +
- +
-{{:app/image128.jpeg?0x10}} **Account No. –** The account number of the SAP® Business One account for the balancing record. +
- +
-{{:app/image128.jpeg?0x10}} **Cancel button –** Cancels the bank setup process and closes the wizard. +
- +
-{{:app/image128.jpeg?0x10}} **Back button –** Moves to the previous screen in the bank setup process. +
- +
-{{:app/image128.jpeg?0x10}} **Next button –** Moves to the next screen in the bank setup process. +
- +
-{{:app/image66.jpeg?785}} +
- +
-**Step 3**+
  
 {{:app/image809.jpeg?599x401}} {{:app/image809.jpeg?599x401}}
  
-**Note –** The fields to be completed on Step 3 of the EFT Bank+<WRAP center round info 90%> 
 +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. 
 +</WRAP>
  
-{{:app/image831.jpeg?586x113}}+  * **<color #22b14c>Cancel</color> button** - Cancels the bank setup process and closes the wizard. 
 +  * **<color #22b14c>Back</color> button** - Moves to the previous screen in the bank setup process. 
 +  * **<color #22b14c>Next</color> button** - Moves to the next screen in the bank setup process. 
 +==== Wizard Step 4 ====
  
-Setup will vary according to the EFT format specified in Step+{{:app:eft_bank_setup_wiz_05.jpg?nolink&600|}}
  
-<HTML><ol start="2" style="list-style-type: decimal;"></HTML> +  * **Prenote File path** - Designates the network file path that will be used to store the generated pre-note files. 
-<HTML><li></HTML><HTML><p></HTML>Any fields in the EFT format file designated as an Entry Field will appear on this screen.<HTML></p></HTML> +  * **Transactions File path** - Designates the network file path that will be used to store the generated transaction files.
-<HTML></li></HTML><HTML></ol></HTML>+
  
-**Cancel button –** Cancels the bank setup process and closes the wizard.+<WRAP center round info 90%> 
 +File paths entered must be reachable by client workstations that will be using the EFT add-on. 
 +</WRAP>
  
 +<WRAP center round info 90%>
 +Even if the <color #00a2e8>**Pre-note Required**</color> field was not selected, a <color #00a2e8>**Pre-note File Path**</color> must be specified.
 +</WRAP>
  
 +<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.</WRAP>
  
-**Back button –** Moves to the previous screen in the bank setup process.+  * **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.
  
 +<WRAP center round info 90%>
 +All delivery setup and administration is performed through the APP **Reports Maintenance** screen.
 +</WRAP>
  
 +  * **<color #22b14c>Cancel</color> button** - Cancels the bank setup process and closes the wizard.
 +  * **<color #22b14c>Back</color> button** - Moves to the previous screen in the bank setup process.
 +  * **<color #22b14c>Next</color> button** - Moves to the next screen in the bank setup process.
  
-**Next button –** Moves to the next screen in the bank setup process. +{{:app/image44.jpeg?786}}
- +
-{{:app/image66.jpeg?785}} +
- +
-**Step 4** +
- +
-{{:app/image832.jpeg?598x401}} +
- +
-**Prenote File path –** Designates the network file path that will be used to store the generated pre note files. +
- +
-{{:app/image22.jpeg}} +
- +
-**Transactions File path –** Designates the network file path that will be used to store the generated transaction files. +
- +
-{{:app/image22.jpeg}} +
- +
-**Note –** File paths entered must be reachable by client workstations that will be using the EFT add-on. +
- +
-{{:app/image811.jpeg?584x52}} +
- +
-**Note –** Even if the **Pre-note Required** field was not selected, a **Pre-note File Path** must be specified. +
- +
-{{:app/image811.jpeg?584x52}} +
- +
-**Note –** The TWBS Electronic Funds Transfer is not responsible for any +
- +
-{{:app/image833.jpeg?584x34}} +
- +
-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. +
- +
-{{:app/image834.jpeg?584x100}} +
- +
-**Printer –** Indicates the local or network printer to be used for printing EFT remittance reports. +
- +
-{{:app/image22.jpeg}} +
- +
-**Bin –** Indicates the bin (or tray) of the local or network printer to be used for printing EFT remittance reports. +
- +
-{{:app/image22.jpeg}} +
- +
-**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. +
- +
-{{:app/image22.jpeg}} +
- +
-Click the file search button ({{:app/image835.jpeg?17x17}}) to the right of the **Format** field to browse for a remittance format. +
- +
-{{:app/image22.jpeg}}{{:app/image38.jpeg}} +
- +
-Once a remittance format file has been selected, it can be modified through the Configurator by clicking on the Link To arrow ({{:app/image815.jpeg?14x12}}) to the left of the Format field. This will open the Configurator and load the selected remittance format file for editing. +
- +
-{{:app/image38.jpeg}} +
- +
-{{:app/image128.jpeg?0x10}} **From Name –** Designates the descriptive name of the sender of the remittance email. +
- +
-{{:app/image128.jpeg?0x10}} **From Email –** Designates the email address of the sender of the remittance email. +
- +
-{{:app/image128.jpeg?0x10}} **Email Subject –** Designates the subject line text of the remittance email. +
- +
-{{:app/image128.jpeg?0x10}} **Email Body –** Designates the email content text of the remittance email. +
- +
-{{:app/image128.jpeg?0x10}} **Archive To –** Designates the network file path that will be utilized to save a backup copy of the remittance email. +
- +
-{{:app/image128.jpeg?0x10}} **SMTP Server –** Designates the email server to be used for the sending of the remittance email. +
- +
-{{:app/image128.jpeg?0x10}} **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. +
- +
- +
- +
-{{:app/image128.jpeg?0x10}} **Cancel button –** Cancels the bank setup process and closes the wizard. +
- +
-{{:app/image128.jpeg?0x10}} **Back button –** Moves to the previous screen in the bank setup process. +
- +
-{{:app/image128.jpeg?0x10}} **Finish button –** Completes the EFT bank setup process and saves the configuration information to the database. +
- +
-{{:app/image836.jpeg?804}}+
  
  
Line 246: 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**</color> button or select the <color #00a2e8>**Define New**</color> option from the <color #00a2e8>**EFT Format**</color> field on the **EFT Bank Setup Wizard** step 2 screen to load the **TWBS EFT Format Maintenance** screen.
- +
-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.+
  
 {{:app/image837.jpeg?608x430}} {{:app/image837.jpeg?608x430}}
  
-**Format Name –** The unique name of the new EFT format.+  * <color #00a2e8>**Format Name**</color> - The unique name of the new EFT format. 
 +  * <color #00a2e8>**Country**</color> - The country of the new EFT format.
  
 +  * **<color #00a2e8>Rec. Code</color> column** - The code of the **Record Type** for the line of the new EFT format.
  
 +<WRAP center round info 90%>
 +The **<color #00a2e8>Rec. Code</color> column** value will be automatically assigned on the selection of the Record Type field.
 +</WRAP>
  
-**Country –** The country of the new EFT format.+  * **<color #00a2e8>Record Type</color> column** - The type of data record for the line of the new EFT format.
  
 +<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.
 +</WRAP>
  
 +  * **<color #00a2e8>Max. Length</color> column** - The maximum length of characters of the data record for the lines of the new EFT format.
  
-**Rec. Code –** The code of the **Record Type** for the line of the new EFT format.+<WRAP center round info 90%> 
 +The <color #00a2e8>**Max. Length**</color> 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 <color #00a2e8>**Max. Length**</color> column. 
 +</WRAP>
  
-{{:app/image67.jpeg?11x11}}+  * **<color #00a2e8>Country</color> column** - The country of the new EFT format. 
 +  * **<color #00a2e8>Order #</color> column** - The # for the order in which the data record will appear when the EFT transaction file is generated.
  
-**Note –** The Rec. Code value will be automatically assigned on the selection of the Record Type field.+<WRAP center round info 90%> 
 +When copying an existing EFT file format, the <color #00a2e8>**Order #**</color> value will be assigned in the way that it was populated for the EFT file format being used as a copying template. 
 +</WRAP>
  
-{{:app/image838.jpeg?569x52}}+  * **<color #22b14c>Save and Continue</color> button** - Saves the EFT file format record type information and opens the **EFT File Maintenance** screen. 
 +  * **<color #22b14c>Cancel</color> button** - Cancels the EFT file format creation process and closes the form.
  
-**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. +
- +
- +
- +
-[[#page830|**Note –** The Max. Length value is used on the EFT File]] [[#page830|Maintenance Screen when editing and saving an EFT]] [[#page830|file format. All Record Type entries on the EFT File]] [[#page830|Maintenance Screen **must** add up to the number of]] characters specified in the Max. Length column. +
- +
-{{:app/image840.jpeg?571x141}} +
- +
-**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. +
- +
-{{:app/image841.jpeg?571x113}} +
- +
-**Save and Continue button –** Saves the EFT file format record type information and opens the [[#page830|EFT File Maintenance Screen]]. +
- +
- +
- +
-**Cancel button –** Cancels the EFT file format creation process and closes the form. +
- +
- +
- +
- +
- +
- +
- +
- **TWBS Advanced Productivity Pack [[#page828|(APP) User Guide]]**+
  
 ===== 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 [[#page828|through the SAP® Business One]] User Interface (UI) that provides the ability to modify [[#page828|the details of the record type]] lines for an EFT file format for EFT processing in [[#page828|SAP® Business One.]] 
  
- +  * Click the <color #22b14c>**Copy Format**</color> button or select the <color #00a2e8>**Define New**</color> option from the <color #00a2e8>**EFT Format**</color> field on the **EFT Bank Setup Wizard** step 2 screen to load the **TWBS EFT Format Maintenance** screen.
- +
-Click the **Copy Format** button or select the [[#page828|**Define New** option from the **EFT**]] **Format** field on the [[#page821|EFT Bank Setup Wizard]] [[#page828|step 2 screen to load]] +
- +
- +
- +
-the TWBS EFT Format Maintenance screen.+
  
 {{:app/image842.jpeg?772x422}} {{:app/image842.jpeg?772x422}}
  
-{{:app/image22.jpeg}} **Format Name –** The unique name of the new [[#page828|EFT format.]]+  * <color #00a2e8>**Format Name**</color> - The unique name of the new EFT format.
  
-{{:app/image80.jpeg?771}}+  * <color #00a2e8>**Record Type**</color> **column** - The type of data record for the [[#page828|EFT format field.]]
  
-**Record Type –** The type of data record for the [[#page828|EFT format field.]]+<WRAP center round info 90%> 
 +The <color #00a2e8>Record Type</color> column values available for selection will be dependent on the information entered for the EFT file format on the **EFT Format Maintenance** screen. 
 +</WRAP>
  
-{{:app/image311.jpeg?11x11}}+  * <color #00a2e8>**Description**</color> **column** - The description of the EFT format field. 
 +  * <color #00a2e8>**Source**</color> **column** - The data source of the EFT format field of the new EFT format. 
 +    * <color #00a2e8>**Blank**</color> - The value will consist of blank (empty) spaces.  
 +    * <color #00a2e8>**Constant**</color> - The value will consist of a constant hard-coded value specified in the <color #00a2e8>**Value**</color> column. 
 +    * <color #00a2e8>**Data Field**</color> - The value will be obtained from another database field specified in the <color #00a2e8>**Table**</color> and <color #00a2e8>**Field**</color> columns. 
 +    * <color #00a2e8>**Entry Field**</color> - The value will be entered on the EFT Bank Setup]] [[#page821|Wizard step 3 screen at the time of EFT Bank setup.]] 
 +    * <color #00a2e8>**System Field**</color> - The value will be obtained from the system based on the value specified in the <color #00a2e8>**Data Type**</color> column. 
 +    * <color #00a2e8>**Transferred Field**</color> - The value will be obtained from another record field specified in the <color #00a2e8>**TransferredRecordName**</color> and <color #00a2e8>**TransferredFieldName**</color> columns. 
 +  * **<color #00a2e8>Required</color> column** - Indicates if the EFT format field is required. 
 +    * <color #00a2e8>**Mandatory**</color> - The data record is mandatory. 
 +    * <color #00a2e8>**Optional**</color> - The data record is optional. 
 +    * <color #00a2e8>**Required**</color> - The data record is required. 
 +  * **<color #00a2e8>Data Type</color> column** - The data type of the EFT format field. 
 +    * <color #00a2e8>**Alphanumeric**</color> 
 +    * <color #00a2e8>**Blank**</color> 
 +    * <color #00a2e8>**Transaction Code**</color> 
 +    * <color #00a2e8>**Batch Date**</color> 
 +    * <color #00a2e8>**Immediate Origin Code**</color> 
 +    * <color #00a2e8>**Transaction Trace Number**</color> 
 +    * <color #00a2e8>**Transit Routing Number**</color> 
 +    * <color #00a2e8>**Company Entry Description**</color> 
 +    * <color #00a2e8>**Company Descriptive Date**</color> 
 +    * <color #00a2e8>**Julian Date (NACHA)**</color> 
 +    * <color #00a2e8>**Transaction Amt**</color> 
 +    * <color #00a2e8>**Numeric**</color> 
 +    * <color #00a2e8>**Service Class Code**</color> 
 +    * <color #00a2e8>**Entry Addenda Count**</color> 
 +    * <color #00a2e8>**Batch Entry Hash**</color> 
 +    * <color #00a2e8>**Total Debit Entry Amt**</color> 
 +    * <color #00a2e8>**Trace Number Seq**</color> 
 +    * <color #00a2e8>**Batch Tim**</color> 
 +    * <color #00a2e8>**File ID Modifier**</color> 
 +    * <color #00a2e8>**Total Credit Entry Amt**</color> 
 +    * <color #00a2e8>**Batch Number**</color> 
 +    * <color #00a2e8>**Total Debit Entry Amt**</color> 
 +    * <color #00a2e8>**Total Credit Entry Amt**</color> 
 +    * <color #00a2e8>**Batch Count**</color> 
 +    * <color #00a2e8>**Block Count**</color> 
 +    * <color #00a2e8>**Entry/Addenda Count**</color> 
 +    * <color #00a2e8>**Entry Hash**</color> 
 +    * <color #00a2e8>**Count of Debits**</color> 
 +    * <color #00a2e8>**Count of Credits**</color> 
 +    * <color #00a2e8>**Canadian Batch Number**</color> 
 +    * <color #00a2e8>**Julian Date (Canada)**</color> 
 +    * <color #00a2e8>**Entry Effective Date**</color> 
 +    * <color #00a2e8>**Payment Number**</color> 
 +  * **<color #00a2e8>Length</color> column** - The length in characters of the EFT format field.
  
-**Note –** The Record Type values available [[#page828|for]] selection will be dependant on the [[#page828|information]] entered for the EFT file format on the [[#page828|EFT]]+<WRAP center round info 90%> 
 +All Record Type entries on the **EFT File Maintenance** screen **must** add up to the number of characters specified in the <color #00a2e8>**Max. Length**</color> column of the **EFT Format Maintenance** screen. 
 +</WRAP>
  
-{{:app/image843.jpeg?575x126}}+  * **<color #00a2e8>StartColumn</color> column** - The character position of the <color #00a2e8>**Record Type**</color> where the EFT format field will begin.
  
-Format Maintenance Screen.+<WRAP center round info 90%> 
 +The StartColumn value will be calculated automatically and may change based upon changes to the <color #00a2e8>**Length**</color> or <color #00a2e8>**Record Type**</color> columns. 
 +</WRAP>
  
-{{:app/image844.jpeg?575x39}} +  * **<color #00a2e8>Value</color> column** – The value of the EFT format field. This column is used in conjunction with the **Constant** **Data Source** value.
- +
-**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. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**Constant –** The value will consist of a constant hard-coded value specified in the **Value** column. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**Data Field –** The value will be obtained from another database field specified in the **Table** and **Field** columns. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-[[#page821|**Entry Field –** The value will be entered on the EFT Bank Setup]] [[#page821|Wizard step 3 screen at the time of EFT Bank setup.]] +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**System Field –** The value will be obtained from the system based on the value specified in the **Data Type** column. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**Transferred Field –** The value will be obtained from another record field specified in the **TransferredRecordName** and **TransferredFieldName** columns. +
- +
-{{:app/image6.jpeg?10x10}} +
- +
-**Mandatory –** Indicates if the EFT format field is required. +
- +
- +
- +
-**Mandatory –** The data record is mandatory. +
- +
-{{:app/image38.jpeg}} +
- +
-**Optional –** The data record is optional. +
- +
-{{:app/image38.jpeg}} +
- +
-**Required –** The data record is required. +
- +
-{{:app/image38.jpeg}} +
- +
- **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. +
- +
-[[#page830|**Note –** All Record Type entries on the EFT File Maintenance]] [[#page830|Screen **must** add up to the number of characters specified in]] [[#page828|the Max. Length column of the EFT Format Maintenance]] [[#page828|Screen.]] +
- +
-{{:app/image819.jpeg?571x114}} +
- +
-**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. +
- +
-{{:app/image838.jpeg?569x52}} +
- +
-**Value –** The value of the EFT format field. This column is used in conjunction with the **Constant** **Data Source** value.+
  
 {{:app/image845.jpeg?707x37}} {{:app/image845.jpeg?707x37}}
  
-**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** +  * **<color #00a2e8>Table</color> column** – The table from which the value of the EFT format field will be obtained. This column is used in conjunction with the <color #00a2e8>**Data Field**</color> and <color #00a2e8>**Entry Field**</color> <color #00a2e8>**Data Source**</color> values. 
- +  * **<color #00a2e8>Field</color> column** – The field of the <color #00a2e8>**Table**</color> from which the value of the EFT format field will be obtained. This column is used in conjunction with the <color #00a2e8>**Data Field**</color> and <color #00a2e8>**Entry Field**</color> <color #00a2e8>**Data Source**</color> values.
- +
- +
- +
- +
-"@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.+
  
 {{:app/image846.jpeg?772x46}} {{:app/image846.jpeg?772x46}}
  
-**Note –** If using the **Entry Field Data Source** value, the+<WRAP center round info 90%> 
 +If using the <color #00a2e8>**Entry Field Data Source**</color> value, the <color #00a2e8>**Table**</color> should be specified as <color #ff7f27>**@TWBS_EFT_VALUES**</color> and the Field should be specified as <color #ff7f27>**U_Value**</color>. 
 +</WRAP>
  
-{{:app/image847.jpeg?571x88}}+{{:app/image849.jpeg?772x47}}
  
-**Table** should be specified as and the+<WRAP center round info 90%> 
 +If using the <color #00a2e8>**Data Field Data Source**</color> value, the <color #00a2e8>**Field**</color> can be either a basic table field or a user defined field. 
 +</WRAP>
  
-**Field** should be specified as +  * **<color #00a2e8>TransferredRecordName</color> column** – The <color #00a2e8>**Record Type**</color> of the field from which the value of the EFT format field will be obtained. This column is used in conjunction with the <color #00a2e8>**Transferred Field**</color> <color #00a2e8>**Data Source**</color> value.  
- +  * **<color #00a2e8>TransferredFieldName</color> column** – The <color #00a2e8>**Description**</color> of the field from which the value of the EFT format field will be obtained. This column is used in conjunction with the <color #00a2e8>**Transferred Field**</color> <color #00a2e8>**Data Source**</color> value.
-{{:app/image848.jpeg?571x60}}{{:app/image849.jpeg?772x47}} +
- +
-**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.+
  
 {{:app/image850.jpeg?772x22}} {{:app/image850.jpeg?772x22}}
  
-**FillChar –** The character to be used as a specific filler character for the entirety of the entered **Length** value.+  * **<color #00a2e8>FillChar</color> column** – The character to be used as a specific filler character for the entirety of the entered <color #00a2e8>**Length**</color> value.
  
 +  * **<color #22b14c>Back</color> button** - Returns to the **EFT Format Maintenance** screen without saving the EFT file format information.
 +  * **<color #22b14c>Save and Continue</color> button** - Saves the EFT file format information. 
 +  * **<color #22b14c>Cancel</color> button** - Cancels the EFT file format creation process and closes the form.
  
- +{{:app/image44.jpeg?786}}
-**Back button –** Returns to the [[#page828|EFT Format Maintenance Screen]] without saving the EFT file format information. +
- +
-{{:app/image22.jpeg}} +
- +
-**Save and Continue button –** Saves the EFT file format information. **Cancel button –** Cancels the EFT file format creation process and closes the form. +
- +
-{{:app/image22.jpeg}}{{:app/image22.jpeg}}+
  
  
 ===== EFT Prenote Generation Screen ===== ===== 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 <color #22b14c>**TWBS EFT Prenote**</color> under the <color #22b14c>**Banking**</color> menu to load the **TWBS EFT Pre-note** 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.+
  
 {{:app/image851.jpeg?399x275}} {{:app/image851.jpeg?399x275}}
  
-**Country –** The country of the SAP® Business One checking account for EFT pre note generation.. +  * <color #00a2e8>**Country**</color> – The country of the SAP® Business One checking account for EFT pre-note generation.. 
- +  * <color #00a2e8>**Bank**</color> – The bank of the SAP® Business One checking account for EFT pre-note generation.. 
- +  * <color #00a2e8>**Account**</color> – The account number 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 [[#page807|more information on this process, refer to the How To]] [[#page807|Configure an SAP® Business One Bank Account page]] of the user guide. +
- +
-{{:app/image852.jpeg?571x140}} +
- +
-**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. +
- +
-{{:app/image34.jpeg?804}} +
- +
  
 +<WRAP center round info>
 +The <color #00a2e8>**Country**</color>, <color #00a2e8>**Bank**</color>, and <color #00a2e8>**Account**</color> 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.
 +</WRAP>
  
 +  * **<color #22b14c>Ok</color> button ** – Closes the form.
 +  * **<color #22b14c>Create Pre-note</color> button ** – Initiates the generation of the pre-note file.
 +  * **<color #22b14c>Recreate Pre-note</color> button ** – Initiates the re-generation of the pre note file in cases of modifications.
  
 +{{:app/image44.jpeg?786}}
    
app/eft_screens.1564169571.txt.gz · Last modified: 2019/07/26 15:32 by dtucker

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki