Canadian Localization - RBC ACH094 Plug-in

Thank you, that was helpful! Oddly… still only getting the U.S. ACH Plug-in as my export method. Maybe there is an issue with whatever version we are on.

I actually had a customized export/payment method created from our VAR months ago when we switched to RBC to create this payment type. I just figured that if now being offered natively from Acumatica that it might be good to have one less customization that need to worry about each time we do an upgrade. 

​@afranklin and ​@paragshah 

Have either of you been successful in creating a valid RBC ACH094 payment file using the new RBC ACH094 Plug-in and have it accepted by RBC?

we abandoned the project after our bank advised us against this file type

​@afranklin 

Thanks for the reply!

I am assisting a client with configuration of a payment method using the RBC ACH094 plug-in. Everything appears to be configured as per the available documentation, but the exported payment text file submitted to the RBC EBB team has multiple issues.

• The first line, Routing Record: $$AAPDACH0094[TEST[NL$$, is missing from the file
• On line beginning with 622, the vendor’s Receiving DFI Routing Number (position 04-12) did not populate and the addenda record (position 13-16) populated as “6” instead of “0006”
• On line beginning with 710, for funds coming from USD account (position 07-24) export file was populated with “000000000000030000”. RBC EBB advised it should be all zeros.
• On line beginning with 711, the vendor’s legal name (position 04-38) and physical address (position 39-73) were populated. RBC EBB advised it should be the Acumatica user Company legal name and physical address.

You noted previously that your VAR created a customized export/payment method for RBC.  Was it for USD ACH payments using the RBC ACH094 file format? Does it work?

Why did your bank advise against using the RBC ACH094 file type?