Wiki

Scale Your Enterprise

User Tools

Site Tools


app:eft_config

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_config [2019/07/25 23:34]
dtucker [How To Configure an SAP® Business One Bank Account]
app:eft_config [2019/07/26 11:38] (current)
Line 3: Line 3:
 ===== How To Configure an SAP® Business One Bank Account ===== ===== How To Configure an SAP® Business One Bank Account =====
  
-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.+  * Click the **<color #22b14c>TWBS EFT Bank Setup Wizard</color>** menu option under the **<color #22b14c>Administration</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Setup</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Banking</color>** menu groups.
  
 {{:app/image802.jpeg?599x400}} {{:app/image802.jpeg?599x400}}
  
-  * Click the **Next** button.+  * Click the <color #22b14c>**Next**</color> button.
  
 {{:app/image803.jpeg?599x400}} {{:app/image803.jpeg?599x400}}
  
-  * Select the **Country** for EFT processing. +  * Select the <color #00a2e8>**Country**</color> for EFT processing. 
-  * Select the **Bank** for EFT processing. +  * Select the <color #00a2e8>**Bank**</color> for EFT processing. 
-  * Select the **Account** for EFT processing. +  * Select the <color #00a2e8>**Account**</color> for EFT processing. 
-  * Click the **Next** button.+  * Click the <color #22b14c>**Next**</color> button.
  
 {{:app/image804.jpeg?599x400}} {{:app/image804.jpeg?599x400}}
  
 <WRAP center round info> <WRAP center round info>
-The TWBS Electronic Funds Transfer application comes with 4 pre installed EFT formats (NACHA-US, PNC Bank, Bank of America, and Canadian Payment Association/Scotia Bank).+The TWBS Electronic Funds Transfer application comes with several EFT formats to choose from or you can design your own.
 </WRAP> </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 [[#page854|How To Copy an EFT Format]] section of the EFT user guide.+  * 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 #00a2e8>**Define New**</color> option to create the format from scratch or you can select one of the existing formats and click the <color #22b14c>**Copy Format**</color> button. Creating an EFT format will be covered in the **How To Copy an EFT Format** section of the EFT user guide.
  
 <WRAP center round info> <WRAP center round info>
Line 32: Line 32:
 </WRAP> </WRAP>
  
-  * If your bank requires a pre note to ensure correct EFT formatting and Business Partner information, select the **Pre note Required** field and add a value to the **Pre note Grace Period** field based on your banking institutions specifications. If your bank does not require pre notes, you may leave the **Pre note Required** field unselected+  * If your bank requires a pre-note to ensure correct EFT formatting and Business Partner information, select the <color #00a2e8>**Pre-note Required**</color> field and add a value to the <color #00a2e8>**Pre-note Grace Period**</color> field based on your banking institutions specifications. If your bank does not require prenotes, you may leave the <color #00a2e8>**Pre-note Required**</color> field unchecked
-  * 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.  +  * If your bank requires a balancing record in the EFT file, select the <color #00a2e8>**Balancing Record Required**</color> box and select the <color #00a2e8>**Account Type**</color> and <color #00a2e8>**Account No.**</color> to be applied for the balancing record. If your bank does not require a balancing record, leave the <color #00a2e8>**Balancing Record Required**</color> field unchecked.  
-  * Click the **Next** button.+  * Click the <color #22b14c>**Next**</color> button.
  
 {{:app/image809.jpeg?599x401}} {{:app/image809.jpeg?599x401}}
  
-  * 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 institution. The available fields on this window will vary depending upon which EFT format you chose or created on the previous screen. 
-  * Click the **Next** button.+  * Click the <color #22b14c>**Next**</color> button.
  
 {{:app/image810.jpeg?598x438}} {{:app/image810.jpeg?598x438}}
  
-  * 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.+  * 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> <WRAP center round info>
Line 50: Line 50:
  
 <WRAP center round info> <WRAP center round info>
-Even if the **Pre-note Required** field was not selected, a **Pre-note File Path** must be specified.+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>
  
Line 56: Line 56:
 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. 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> </WRAP>
 +
 +**OUTDATED**
  
   * To print EFT remittances...   * To print EFT remittances...
Line 83: Line 85:
 ===== How To Configure SAP® B1 Payment Methods for EFT ===== ===== How To Configure SAP® B1 Payment Methods for EFT =====
  
- +  *  Click the SAP menu option titled <color #22b14c>**Payment Methods**</color> under the **<color #22b14c>Administration</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Setup</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Banking</color>** menu groups to load the **Payment Methods** setup screen. 
- +  *  If the form doesn't load in Add mode, click the <color #22b14c>**Add**</color> {{:app/image816.jpeg?23x25}} button on the SAP icon bar.
-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't load in Add mode, click the **Add** ({{:app/image816.jpeg?23x25}}button on the SAP icon bar.+
  
 {{:app/image817.jpeg?523x601}} {{:app/image817.jpeg?523x601}}
  
-**Note –** In order to process both Incoming (Customer payments) to you and Outgoing (Vendor payments to your vendors) EFT transactions, separate Incoming and Outgoing Bank Transfer Payment Methods will need to be created for each **Country**/**Bank**/**Account** combination to be used for Electronic Funds Transferring.+<WRAP center round info> 
 +In order to process both Incoming (Customer payments) to you and Outgoing (Vendor payments to your vendors) EFT transactions, separate Incoming and Outgoing Bank Transfer Payment Methods will need to be created for each **Country**/**Bank**/**Account** combination to be used for Electronic Funds Transferring. 
 +</WRAP>
  
-{{:app/image818.jpeg?571x168}}+  *  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.
  
-{{:app/image22.jpeg}} Enter a **Payment Method Code** for your new Payment Method.+<WRAP center round info> 
 +If the <color #00a2e8>**Payment Type**</color> is <color #00a2e8>**Outgoing**</color>, this is the account from which the funds will be drawn for the transfer. If the <color #00a2e8>**Payment Type**</color> is <color #00a2e8>**Incoming**</color>, this is the account to which funds will be deposited. 
 +</WRAP>
  
-{{:app/image22.jpeg}} Enter a **Description** for your new Payment Method.+   Click the <color #22b14c>**Add**</color> button.
  
-{{:app/image22.jpeg}} Select a **Payment Type** (**Incoming** or **Outgoing**) for your new Payment Method. +==== Outgoing Payment Method Sample ====
- +
-Select the option of **Bank Transfer** for the **Payment Means** of your new Payment Method. +
- +
-{{:app/image22.jpeg}} +
- +
-Select the **Country** for the House Bank Account for your new Payment Method. +
- +
-{{:app/image22.jpeg}} +
- +
-Select the **Bank** for the House Bank Account for your new Payment Method. +
- +
-{{:app/image22.jpeg}} +
- +
-Select the **Account** for the House Bank Account for your new Payment Method. +
- +
-{{:app/image22.jpeg}} +
- +
-**Note –** If the **Payment Type** is **Outgoing**, this is the account from which the funds will be drawn for the transfer. If the **Payment Type** is **Incoming**, this is the account to which funds will be deposited. +
- +
-{{:app/image819.jpeg?571x114}} +
- +
-Click the **Add** button. +
- +
- +
- +
-**Outgoing Payment Method Sample**+
  
 {{:app/image820.jpeg?766x563}} {{:app/image820.jpeg?766x563}}
  
-**Incoming Payment Method Sample**+==== Incoming Payment Method Sample ====
  
 {{:app/image821.jpeg?786x578}} {{:app/image821.jpeg?786x578}}
- 
- 
- 
- 
- 
-  
  
 {{:app/image44.jpeg?786}} {{:app/image44.jpeg?786}}
Line 145: Line 120:
 ===== How To Configure Business Partner Banking Info ===== ===== How To Configure Business Partner Banking Info =====
  
 +  * Click the SAP menu option titled <color #22b14c>**Business Partner Master Data**</color> under the <color #22b14c>**Business Partners**</color> menu to load the **Business Partner Master Data** screen.
  
 +<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.
 +</WRAP>
  
-Click the SAP menu option titled **Business Partner Master Data** under the **Business Partners** menu to load the Business Partner Master Data screen. +  * Navigate to the Business Partner that you want to configure for EFT processing. 
- +  Click on the <color #22b14c>**Payment Run**</color> tab. 
- +  Select <color #00a2e8>**Include**</color> next to the bank transfer payment method(s) you would like to use with this business partner.
- +
-**Note –** Bank account data for business partners is entered and maintained on the Payment Terms tab of the Business Partner Master Data form. +
- +
-{{:app/image822.jpeg?575x148}} +
- +
-Navigate to the Business Partner that you want to configure for EFT processing. +
- +
-{{:app/image22.jpeg}} +
- +
-Click on the Payment Run tab. +
- +
-{{:app/image22.jpeg}} +
- +
-Select **Include** next to the bank transfer payment method(s) you would like to use with this business partner. +
- +
-{{:app/image22.jpeg}}+
  
 {{:app/image823.jpeg?730x590}} {{:app/image823.jpeg?730x590}}
  
-**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?575x148}} +</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. +
- +
-{{:app/image824.jpeg?586x167}} +
- +
-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.
 +</WRAP>
  
 +  * Click on the <color #22b14c>**Payment Terms**</color> tab.
  
 {{:app/image825.jpeg?731x589}} {{:app/image825.jpeg?731x589}}
  
-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**</color> field. This will load the **Business Partner Bank Accounts - Setup** screen. 
- +  Select the business partner's bank.
- +
- +
-Select the business partner's bank. +
- +
- +
- +
-**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+
- +
-{{:app/image826.jpeg?571x142}} +
- +
-Enter the **Account** number for the business partner's bank account. Click the **Update** button on the Business Partner Bank Accounts - Setup screen.+
  
 +<WRAP center round info>
 +If the Business Partners bank is not listed, click the SAP menu option titled **Banks** 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 **Banks - Setup** screen. Once the bank setup has been completed, you can return to this step.
 +</WRAP>
  
 +  * Enter the <color #00a2e8>**Account**</color> number for the business partner's bank account. Click the <color #22b14c>**Update**</color> button on the **Business Partner Bank Accounts - Setup** screen.
  
 {{:app/image827.jpeg?579x327}} {{:app/image827.jpeg?579x327}}
  
-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**</color> button on the **Business Partner Bank Accounts - Setup** screen to return to the **Business Partner Master Data** screen
 +  * Enter the <color #00a2e8>**EFT DFI Transit Routing**</color> number and <color #00a2e8>**EFT Account Type**</color> into the fields on the <color #22b14c>**Payment Terms**</color> tab. 
 +  * If you wish to use a termination date, enter a valid date into the optional <color #00a2e8>**EFT Termination Date**</color> field. 
 +  * If you are using a pre-note, the <color #00a2e8>**EFT Activation Date**</color> 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 <color #22b14c>**Add**</color> button for a new business partner or the <color #22b14c>**Update**</color> button for an existing business partner.
  
- +<WRAP center round important> 
- +Any changes made to EFT data (<color #00a2e8>**DFI Transit Routing**</color> number, <color #00a2e8>**Account Type**</color>, or bank <color #00a2e8>**Account**</color>) on the <color #22b14c>**Payment Terms**</color> 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. 
-Enter the **EFT DFI Transit Routing** number and **EFT Account Type** into the fields on the Payment Terms tab. +</WRAP>
- +
- +
- +
-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?571x235}} +
- +
-**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.+
  
 {{:app/image44.jpeg?786}} {{:app/image44.jpeg?786}}
app/eft_config.1564112051.txt.gz · Last modified: 2019/07/25 23:34 by dtucker