This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
app:eft_config [2019/05/08 00:13] dtucker created |
app:eft_config [2019/07/26 11:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Electronic Funds Transfer Configuration ====== | ====== Electronic Funds Transfer Configuration ====== | ||
| - | |||
| - | **Electronic Funds Transfer (EFT)** | ||
| - | |||
| - | |||
| - | |||
| - | The TWBS Electronic Funds Transfer integrates directly with SAP® Business One providing unified transaction file creation, transaction recording and remittance printing eliminating the need for double-entry! | ||
| - | |||
| - | Seamlessly integrated completely within SAP® Business One. | ||
| - | |||
| - | |||
| - | |||
| - | Conveniently creates bank transfer files formatted for your bank. | ||
| - | |||
| - | |||
| - | |||
| - | Essentially prints detailed remittances for vendors. | ||
| - | |||
| - | |||
| - | |||
| - | Effortlessly delivers remittances via e-mail. | ||
| - | |||
| - | |||
| - | |||
| - | Quick and easy to set up. | ||
| - | |||
| - | |||
| - | |||
| - | Accommodates EFT contract termination dates. | ||
| - | |||
| - | |||
| - | |||
| - | **Note –** The TWBS Electronic Funds Transfer User Guide assumes that the person reading is already well-versed in the Bank Account, Business Partner and Check printing processes that are native to the SAP® Business One system. To attain training in SAP® Business One, contact your SAP® Partner or visit the SAP® Business One Customer Portal website. | ||
| - | |||
| - | {{: | ||
| - | |||
| - | **Warning –** The printing of EFT Remittances is not supported in the 64-bit version of the SAP® Business One 9.0 release of this application at this time. | ||
| - | |||
| - | {{: | ||
| - | |||
| - | **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. | ||
| - | |||
| - | {{: | ||
| - | |||
| - | [[# | ||
| - | |||
| - | |||
| - | |||
| - | [[# | ||
| - | |||
| - | |||
| - | |||
| - | [[# | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| + | ===== How To Configure an SAP® Business One Bank Account ===== | ||
| - | **Configuring Electronic Funds Transfer** | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | [[# | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | **How To Configure an SAP® Business One Bank Account** | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Click the SAP menu option titled | + | |
| {{: | {{: | ||
| - | Click the **Next** button. | + | * Click the <color #22b14c>**Next**</ |
| - | + | ||
| {{: | {{: | ||
| - | {{: | + | * Select the <color #00a2e8>**Country**</ |
| - | + | | |
| - | Select the **Bank** for EFT processing. | + | |
| - | + | | |
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| {{: | {{: | ||
| - | **Note –** The TWBS Electronic Funds Transfer application comes with 4 pre installed | + | <WRAP center round info> |
| + | The TWBS Electronic Funds Transfer application comes with several | ||
| + | </ | ||
| - | {{:app/image805.jpeg? | + | * Select EFT format name for the format required by your banking institution from the provided list. To create an EFT format in the application you can either select the <color # |
| - | formats (NACHA-US, PNC Bank, Bank of America, and Canadian Payment Association/ | + | <WRAP center round info> |
| - | + | If you are unsure of the format that is required for your banking institution, | |
| - | {{: | + | </WRAP> |
| - | + | ||
| - | Select EFT format name for the format required by your banking institution from the provided list. To create an EFT format in the application you can either select the **Define New** option to create the format from scratch or you can select one of the existing formats and click the **Copy Format** button. Creating an EFT format will be covered in the [[# | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Note –** If you are unsure of the format that is required for your banking institution, | + | |
| - | + | ||
| - | {{:app/image808.jpeg? | + | |
| - | + | ||
| - | **Warning –** An EFT format selection is required before the bank configuration can continue. | + | |
| - | + | ||
| - | If your bank requires a pre note to ensure correct EFT formatting and Business Partner information, | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | If your bank requires a balancing record in the EFT file, select the **Balancing** **Record Required** box and select the **Account Type** and **Account No.** to be applied for the balancing record. If your bank does not require a balancing record, leave the **Balancing Record Required** field unselected. Click the **Next** button. | + | |
| + | <WRAP center round important> | ||
| + | An EFT format selection is required before the bank configuration can continue. | ||
| + | </ | ||
| + | * If your bank requires a pre-note to ensure correct EFT formatting and Business Partner information, | ||
| + | * If your bank requires a balancing record in the EFT file, select the <color # | ||
| + | * Click the <color # | ||
| {{: | {{: | ||
| - | On the EFT Setup Data screen, enter the Entry Data type field information. Many of the values can be found in the account specific information provided by your bank institution. The available fields on this window will vary depending upon which EFT format you chose or created on the previous screen. | + | * On the **EFT Setup Data** screen, enter the **Entry Data** type field information. Many of the values can be found in the account specific information provided by your banking |
| - | + | | |
| - | + | ||
| - | + | ||
| - | Click the **Next** button. | + | |
| {{: | {{: | ||
| - | When EFT transaction and pre note files are created, they will be written to the | + | * When EFT transaction and pre-note files are created, they will be written to the folders you specify here. Each time new files are created, you will retrieve them from this location and transmit them to your bank. |
| + | <WRAP center round info> | ||
| + | File paths entered must be reachable by client workstations that will be using the EFT add-on. | ||
| + | </ | ||
| + | <WRAP center round info> | ||
| + | Even if the <color # | ||
| + | </ | ||
| + | <WRAP center round info> | ||
| + | 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. | ||
| + | </ | ||
| + | **OUTDATED** | ||
| - | folders you specify here. Each time new files are created, | + | * To print EFT remittances... |
| + | * Select the **Printer** and the printer' | ||
| + | * Select the remittance report **Format** to be used. Several formats | ||
| + | * 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 ({{: | ||
| + | * To deliver EFT remittances by email... | ||
| + | * Enter the **From Name** for the descriptive name of the sender of the remittance email. | ||
| + | * Enter the **From Email** for the email address of the sender of the remittance email. | ||
| + | * Enter the **Email Subject** for the subject line text of the remittance email. | ||
| + | * Enter the **Email Body** for the email content text of the remittance email. | ||
| + | * Define a network path in the **Archive To** field to designate a place for a backup copy of the remittance email. | ||
| + | * Enter the **SMTP Server** for the email server to be used for the sending of the remittance email. | ||
| + | * If your **SMTP Server** requires you to enter credentials, | ||
| + | * Enter the **Password** required for the **SMTP Server**. | ||
| + | * Enter the **Port #** of the **SMTP Server**. | ||
| + | * Select the **Enable SSL** checkbox to turn on SSL encryption. | ||
| + | * Click the **Finish** button. | ||
| - | **Note –** File paths entered must be reachable by client workstations | + | <WRAP center round info> |
| + | This configuration process should | ||
| + | </ | ||
| - | {{:app/image811.jpeg?584x52}} | + | {{:app/image44.jpeg?786}} |
| - | **Note –** Even if the **Pre-note Required** field was not selected, a **Pre-note File Path** must be specified. | + | ===== How To Configure SAP® B1 Payment Methods for EFT ===== |
| - | {{: | + | |
| - | + | | |
| - | **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. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | To print EFT remittances... | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Select | + | |
| - | + | ||
| - | {{:app/image38.jpeg}} | + | |
| - | + | ||
| - | Select the remittance report | + | |
| - | + | ||
| - | {{:app/image38.jpeg}} | + | |
| - | + | ||
| - | Click the file search button ({{: | + | |
| - | + | ||
| - | {{:app/image814.jpeg}} | + | |
| - | + | ||
| - | Once a remittance format file has been selected, it can be modified through the Configurator by clicking on the Link To arrow ({{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Enter the **From Name** for the descriptive name of the sender of the remittance email. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Enter the **From Email** for the email address of the sender of the remittance email. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Enter the **Email Subject** for the subject line text of the remittance email. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Enter the **Email Body** for the email content text of the remittance email. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Define a network path in the **Archive To** field to designate a place for a backup copy of the remittance email. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Enter the **SMTP Server** for the email server to be used for the sending of the remittance email. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | If your **SMTP Server** requires you to enter credentials, | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Credentials** box. | + | |
| - | + | ||
| - | Enter the **Password** required for the **SMTP Server**. | + | |
| - | + | ||
| - | {{:app/image6.jpeg?10x10}} | + | |
| - | + | ||
| - | Enter the **Port #** of the **SMTP Server**. | + | |
| - | + | ||
| - | {{:app/image6.jpeg? | + | |
| - | + | ||
| - | Select the **Enable SSL** checkbox | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Note –** This configuration process should be repeated for each SAP® Business One account that will be used in . | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | **How To Configure SAP® B1 Payment Methods | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Click the SAP menu option titled **Payment Methods** under the **Administration** -**Setup** -**Banking** menus to load the Payment Methods - Setup screen. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | If the form doesn' | + | |
| {{: | {{: | ||
| - | **Note –** In order to process both Incoming (Customer payments) to you and Outgoing (Vendor payments to your vendors) EFT transactions, | + | <WRAP center round info> |
| + | In order to process both Incoming (Customer payments) to you and Outgoing (Vendor payments to your vendors) EFT transactions, | ||
| + | </ | ||
| - | {{: | + | * Enter a **Payment Method Code** for your new Payment Method. |
| + | * Enter a **Description** for your new Payment Method. | ||
| + | * Select a **Payment Type** (**Incoming** or **Outgoing**) for your new Payment Method. | ||
| + | * Select the option of **Bank Transfer** for the **Payment Means** of your new Payment Method. | ||
| + | * Select the **Country** for the House Bank Account for your new Payment Method. | ||
| + | * Select the **Bank** for the House Bank Account for your new Payment Method. | ||
| + | * Select the **Account** for the House Bank Account for your new Payment Method. | ||
| - | {{: | + | <WRAP center round info> |
| + | If the <color #00a2e8>**Payment | ||
| + | </ | ||
| - | {{: | + | |
| - | {{: | + | ==== Outgoing Payment Method Sample |
| - | + | ||
| - | Select the option of **Bank Transfer** for the **Payment Means** of your new Payment Method. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Select the **Country** for the House Bank Account for your new Payment Method. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Select the **Bank** for the House Bank Account for your new Payment Method. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Select the **Account** for the House Bank Account for your new Payment Method. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Note –** If the **Payment Type** is **Outgoing**, | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Click the **Add** button. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Outgoing Payment Method Sample** | + | |
| {{: | {{: | ||
| - | **Incoming Payment Method Sample** | + | ==== Incoming Payment Method Sample |
| {{: | {{: | ||
| + | {{: | ||
| + | ===== How To Configure Business Partner Banking Info ===== | ||
| + | * Click the SAP menu option titled <color # | ||
| + | <WRAP center round info> | ||
| + | Bank account data for business partners is entered and maintained on the Payment Terms tab of the Business Partner Master Data form. | ||
| + | </ | ||
| - | + | | |
| - | + | | |
| - | **How To Configure Business Partner Banking Info** | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Click the SAP menu option titled **Business Partner Master Data** under the **Business Partners** menu to load the Business Partner Master Data screen. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Note –** Bank account data for business partners is entered and maintained on the Payment Terms tab of the Business Partner Master Data form. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Navigate to the Business Partner that you want to configure for EFT processing. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Click on the Payment Run tab. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Select **Include** next to the bank transfer payment method(s) you would like to use with this business partner. | + | |
| - | + | ||
| - | {{: | + | |
| {{: | {{: | ||
| - | **Note –** TWBS EFT does not control how Payment methods are assigned to invoices. Payment methods are assigned to invoices by the SAP Business One Payment Wizard. | + | <WRAP center round info> |
| - | + | TWBS EFT does not control how Payment methods are assigned to invoices. Payment methods are assigned to invoices by the SAP Business One Payment Wizard. | |
| - | {{:app/image822.jpeg? | + | </WRAP> |
| - | + | ||
| - | **Note –** The House Bank field is an optional SAP® Business One field. If it is used in versions prior to SAP® Business One 2005 SP1, it will override any bank associated with a payment method. For versions SAP® Business One 2005 SP1 and after, the House Bank field will no longer override the payment method bank. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Click on the Payment Terms tab. | + | |
| + | <WRAP center round info> | ||
| + | The House Bank field is an optional SAP® Business One field. If it is used in versions prior to SAP® Business One 2005 SP1, it will override any bank associated with a payment method. For versions SAP® Business One 2005 SP1 and after, the House Bank field will no longer override the payment method bank. | ||
| + | </ | ||
| + | * Click on the <color # | ||
| {{: | {{: | ||
| - | Click the Choose From List icon to the right of the **Bank Country** field. This will load the Business Partner Bank Accounts - Setup screen. | + | * Click the **Choose From List** icon to the right of the <color #00a2e8>**Bank Country**</ |
| - | + | * Select | |
| - | + | ||
| - | + | ||
| - | Select the business partner' | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Note –** If the Business Partners bank is not listed, click the SAP menu option titled **Banks** under the **Administration** -**Setup** -**Banking** menus to load the Banks - Setup screen. Once the bank setup has been completed, you can return to this step. | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Enter the **Account** number for the business partner' | + | |
| + | <WRAP center round info> | ||
| + | If the Business Partners bank is not listed, click the SAP menu option titled **Banks** under the **<color # | ||
| + | </ | ||
| + | * Enter the <color # | ||
| {{: | {{: | ||
| - | Click the **Ok** button on the Business Partner Bank Accounts - Setup screen to return to the Business Partner Master Data screen. | + | * Click the <color #22b14c>**Ok**</ |
| - | + | | |
| - | + | | |
| - | + | | |
| - | Enter the **EFT DFI Transit Routing** number and **EFT Account Type** into the fields on the Payment Terms tab. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | If you wish to use a termination date, enter a valid date into the optional **EFT** **Termination Date** field. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | If you are using a pre note, the **EFT Activation Date** field will be filled in when the pre note is created. If the bank associated with the Business Partner’s bank transfer payment method does not require a pre note, then the activation date will be ignored by the system. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Click the **Add** button for a new business partner or the **Update** button for an existing business partner. | + | |
| - | {{:app/image828.jpeg? | + | <WRAP center round important> |
| + | Any changes made to EFT data (<color # | ||
| + | </ | ||
| - | **Warning –** Any changes made to EFT data (**DFI Transit Routing** number, **Account Type**, or bank **Account**) on the Payment Terms tab will cause the activation date to be set to null. If pre notes are required, this will result in the business partner becoming ineligible for EFT until they have once again been pre noted and the pre note grace period has passed. | + | {{: |