/
BC Steps to Setup, Export and Transmit EFT

BC Steps to Setup, Export and Transmit EFT

Setup:

  1. Create/import the Data Exchange Definition.
    This can be either set up manually by entering the format specifications as per the bank requirements (or) importing an existing XML file.

     

  2. Bank Export/Import Setup
    Create a setup code for Export-EFT for the Data Exchange Definition configured in the previous setup. Fill out the information as seen in the highlighted line below:

    1. Code

    2. Name

    3. Direction

    4. Processing Codeunit ID

    5. Processing Codeunit Name

    6. Processing XMLport ID

    7. Processing XMLport Name

    8. Data Exch. Def. Code

    9. Preserve Non-Latin Characters

    10. Check Export Codeunit

    11. Check Export Codeunit Name



  3. Bank Account fields
    Setup the following fields in the Bank Account card:

    1. Last Remittance Advice No.:

    2. Country Export Format

    3. E-Pay Export File Name

    4. E-Pay Trans. Program Path

    5. E-Pay Export File Path



  4. Vendor Bank Account
    Create a Vendor Bank Account from the Vendor Card (found under Navigate > Bank Accounts), and fill in the following mandatory fields:

    1. Code

    2. Name

    3. Bank Code

    4. Bank Branch No.

    5. Bank Account No.

    6. Use for Electronic Pay

Exporting and the Remittance Advise and EFT file:

Payment Journal

  1. Select the lines to pay for EFT vendors through Suggest Vendor Payments or manual filling.
    NOTE: The Payment Journal Batch should have the following elements filled in:

    1. Bal. Account Type

    2. Bal. Account No. Allow Payment Export


      The Lines should be set to Electronic Payment at Bank Payment Type:



  2. To export the Remittance Advise, select Related > Payments > Electronic Payments > Export…



    Set the Output format to PDF for the remittance advise file:



    This will export Remittance Advise to the chosen file path:

  3. To export the EFT File, select Actions > Functions > Generate EFT File.


    This will show the list of lines for which the file will be comprised of. Click “Generate EFT File” again under this window:



    Enter the path to download this file. You will then see the file downloaded in the chosen path:




  4. Now, you have an option to Void the payment line and re-export the files again – in event of any mistakes on the file or the payment line(s)
    To void the Payment batch, select Bank > Void:


    Click on Void, which will uncheck the Check Printed and Exported to Payment File boxes on the Payment Lines, letting you re-run the Export process again.

  5. Once exported, use this file to upload into the Bank Website Portal. After a successful acknowledgment from the Bank portal, do the next step, ie., Post:

  6. Select Post/Print > Post.