Possible for Canadian company to issue EFT payments in US dollars?

(0) Share

Report

Posted on by Rob F.

483

Hi, my company has just kicked off our project to finally make the move from NAV 2013 to Business Central Cloud. We are working on the setup and testing of EFT payments and have run into a major roadblock and hoping someone out there might be able to help.

Currently in NAV we have a customized process to export EFT payments in an EDI file format that is supported by Royal Bank. We issue payments in Canadian dollars from a Canadian dollar bank account, and payments in US dollars from a US dollar bank account (i.e. different accounts both held at the same bank). Everything works seamlessly. When we evaluated our options on how to replicate this in BC with our partner, they recommended that instead of building a custom data exchange definition for the existing EDI format that we should use the ACH format that comes OOB with BC since it is designed to work with Royal Bank as-is.

The developer set everything up and then we started testing. For Canadian dollar payments we ran into a few small issues with fields not matching exactly to the RBC spec (found here RBC ACH Help Centre - References (rbcroyalbank.com)) but otherwise the file output seemed ok. However, when we tried testing payments in US dollars from our US bank account we found that the dollar amounts in the file were the converted Canadian equivalent amounts instead of the expected US dollar amounts (e.g. a payment for $1,000 USD is showing as $1,270). We then realized this converted amount also showed up on the Remittance Advice report and the Generate EFT File page.

After searching online I found this Microsoft page which apparently indicates that BC's EFT functionality cannot be used with foreign currency bank accounts.

Make Payments with AMC Banking (US) or SEPA Credit Transfer (EU) - Business Central | Microsoft Docs

At this point I'm confused as there must be other Canadian companies on NAV/BC out there who use US dollar bank accounts to pay vendors in US dollars. If anyone has any insight into this scenario or how it can be handled either through some alternate configuration, customization, or third-party add-on I'd love to hear about it.

Thank you.

All responses (6)

Answers (1)

George S. 25 on at

Like (0)

Report

RE: Possible for Canadian company to issue EFT payments in US dollars?

Thanks Rob.

It's quite surprising that this isn't possible as the transaction posts fine through AP and the GL, hopefully Microsoft will give it some attention at some point.
Rob F. 483 on at

Like (0)

Report

RE: Possible for Canadian company to issue EFT payments in US dollars?

Hi George, we are using the app that is linked in Steve's reply. It works very well process-wise, the file formats were ready to use without any custom development, and the support from the vendor has been excellent so far. It's definitely worth a look.
George S. 25 on at

Like (0)

Report

RE: Possible for Canadian company to issue EFT payments in US dollars?

Hello Rob.

May I ask what you folks decided upon for a solution? I've come across the same issue and find it a bit hard to believe It's not possible.
Rob F. 483 on at

Like (0)

Report

RE: Possible for Canadian company to issue EFT payments in US dollars?

Update - Steve, the app you suggested has the functionality I'm looking for, but it comes with a cost vs. paying zero for the same capability now in our almost 10 year old NAV system.

If anyone else out there working at a Canadian company was successful in getting US dollar EFT exports to work in Business Central, or if you are a partner who has been able to do this with a customer please let me know.
Rob F. 483 on at

Like (0)

Report

RE: Possible for Canadian company to issue EFT payments in US dollars?

Thank you Steve. That app looks like a good option, and it at least confirms that it is possible to issue EFT payments from a foreign currency account in BC.
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Possible for Canadian company to issue EFT payments in US dollars?

Rob,

You might check into this APP : appsource.microsoft.com/.../pubid.odt|aid.a8033775-8a11-441a-bbbd-0f16dc6852ff|pappid.a8033775-8a11-441a-bbbd-0f16dc6852ff

You can email them to confirm your process will work.

Hope this helps.

Thanks,

Steve