360 Canadian EFT Support Overview
Eliminate check signing and expensive wire transfers
Use 360 Canadian EFT for Business Central to quickly and effortlessly setup EFT with any major Canadian Bank. Leverage the time and cost savings of using EFT for Payables, configured in a matter of minutes.
- Speed up the payment process by eliminating manual payments and cheques (checks)
- Pre-configured EFT file formats for major Canadian Banks
- Secure, convenient, and cost-effective Electronic Fund Transfer
Prerequisites
Launch Extension Marketplace from Extension Management
(Optional) If popup blocker is enabled, allow Extension Marketplace screen to popup and click Extension Marketplace again.
In your browser, Business Apps – Microsoft AppSource Popup page will show as another window beside Business Central.
Search for 360 Visibility Apps in Extension Marketplace and select 360 Canadian EFT.
In the Extension Marketplace app page, click on FREE TRIAL.
Fill in the FREE TRIAL form and hit continue to start App installation in Business Central.
In Dynamics 365 Business Central page, select the environment and click install.
Confirm installation language.
Click OK to bring you to the main Business Central page.
Once you click OK, you may need a few minutes to wait for installation. Once installed, 360 Canadian EFT will appear in extensions management (installed extensions page). See (Figure 1) showing existing installed apps.
Setup
(Required) Data Exchange Definition File Download
After the successful installation and registration of the App, you need to import the Data Exchange Definition files as described below:
- Go to Data Exchange Definition.
- On the Data Exchange List, click on “Import Data Exchange Definition”.
- Click “Choose” and select the definition file to import from the unzipped file (ex. SCOTIA BANK – CPA005.txt)
- Verify that Data Exchange Definition is created successfully.
Note: Follow steps 1 to 4 to import the required Data Exchange Definition for all the required banks and ensure that the Type is set to EFT Payment, in case it defaults to Generic Export.
- Now, go to “Bank Export/Import Setup”.
- Now, go to “Bank Export/Import Setup”.
- Code
- Description
- Direction (select “Export EFT” from dropdown)
- Data Exch. Def. Code (select the desired Data Exchange Definition Code)
- Setup/verify the following configurations.
- On the Bank Account Card (Transfer tab):
- Country Export Format is set to “CA”.
- A document no series in entered in the “E-Pay Export No.” field.
- “Last E-Pay File Creation No.” field is set to the appropriate no.
- The Client No. is filled in.
- The Client Name is filled in.
- The Transit No. is filled in.
- Payment Export Format is set to the desired “Bank Export/Import Setup Code”.
- On the Vendor Bank Account (Transfer tab):
Ensure that the “Use for Electronic Payment” Boolean is selected on the relevant Vendor Bank Accounts which would be used for EFT. - On the General Journal Batch page (Payment Journals batch), select the Boolean “Allow Payment Export” on the batch which will be used to enter EFT Payment.
- On the Bank Account Card (Transfer tab):
Create an EFT Payment
- After entering payment line in the payment journal, ensure that that following fields are populated correctly.
- “Recipient Bank Account” field is populated with the Vendor’s Bank Account.
- “Bank Payment Type” field is set to “Electronic Payment”.
- Go to -> Bank -> Export
- On the Edit-Export Electronic Payment page, select/verify the Bank account No. and the Output Method and click OK
- This will produce the Remittance Advice
- Go to Action -> Functions -> Generate EFT File
- Verify the details and click on “Generate EFT Files” to create the file