Yes, we have clients using RBA Scheduler for that bank.
Basically you somehow extract payment details from Sage data (ODBC script, custom report...) and use that as input for Scheduler.
http://rbanderson.squarespace.com/storage/Forum/Help12/ra_import-specifications.html
As long as the bank will accept one of the file formats produced by Scheduler, it should work.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------
Original Message:
Sent: 09-19-2024 20:34
From: Barbara Goldstein
Subject: Canada ACH Generation
BMO Harris. The project is to pay Canadian vendors only out of this bank account.
------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
------------------------------
Original Message:
Sent: 09-19-2024 20:27
From: Kevin Moyes
Subject: Canada ACH Generation
What's the bank? For a Canadian Bank, we use RBA Scheduler, and store the banking details in AP_Vendor UDF's.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 09-19-2024 20:05
From: Barbara Goldstein
Subject: Canada ACH Generation
@Kevin Moyes, our client project is still barely alive. We just learned that the Routing/Transit field in Employee Maintenance Electronic Payment doesn't accept Canadian Transit Codes. Client bank said they could convert an ACH file into EFT, but Sage 100 isn't cooperating by allowing us to use the Canadian format. Were you able to find a way around that snag in your solution? They are on v4.5 btw.
------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
Original Message:
Sent: 03-24-2022 15:17
From: Kevin Moyes
Subject: Canada ACH Generation
The input for Scheduler is a CSV (with two formats, depending on if the destination bank is Canadian or US), so we just use a VBScript (with ODBC query) to get the data, selected by bank code and date (or source journal and journal number).
A custom report exported to CSV would work just as well.
http://rbanderson.squarespace.com/storage/Forum/Help12/ra_import-specifications.html
Scheduler will auto-sense if a file is Canadian or US format based on the first line's first field (over 4 digits = US file).
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Original Message:
Sent: 03-24-2022 14:38
From: Barbara Goldstein
Subject: Canada ACH Generation
Bringing this back up again. @Kevin Moyes, Do your Sage customers generate a Sage ACH/NACHA file that is imported into Scheduler to produce the Canadian formatted file? Or do you generate the files another way? Note: our client with a Canadian branch want to produce vendor payments.
------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
Original Message:
Sent: 03-02-2021 18:27
From: Kevin Moyes
Subject: Canada ACH Generation
The options above are our solutions sending From Canada, not To Canada. What services are available from an EFT perspective would be up to the US Bank. It's fairly recent (in the last few years) where Canadian banks have started offering international EFT.
Some Canadian vendors will have US bank accounts... which is worth asking about.
Credit cards should work (if the vendors will accept CC payments).
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 03-02-2021 17:28
From: Jeff Schwenk
Subject: Canada ACH Generation
Bring this back up for some air. Have client inquiring about Canadian ACH payments. From above, doesn't look easy. They have six to 10 vendors up north. Currently they mail checks. Mail is very slow. What are some ways to speed the payment process? Open a Canadian bank account. Wire transfer total payment to Canadian bank, Get software @Kevin Moyes mentions above to transfer funds to Canadian vendor? How do the big dogs do it? How do the little guys do it?
Thanks in advance.
------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
Original Message:
Sent: 01-09-2020 09:15
From: Kevin Moyes
Subject: Canada ACH Generation
For sending Canada bank to Canada bank, each Canadian bank has their own EFT file format (completely unrelated to NACHA).
For sending Canada bank to US bank, the format is IAT (International ACH Transaction) which is not possible to generate from Sage 100.
To help format the files, we use 3rd party software: https://www.rbanderson.com/scheduler
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON