Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Would someone using the EFT for Payables with RBC or anyone knowledeable in properly setting up the RBC EFT for Payables file format, be kind enough to share the layout of the file, so that we can substitute our own values?
I understand that you may have some apprehension about sharing this information, but if such is your concern, would it not be possible to replace any confidential information with dummy data that will act like useful placeholders?
I am sure there are many of us who would very much appreciate such a magnanimous gesture, instead of the typical 'details are available in the eBanking documentation' response. I sincerely hope that there is someone out there that is both knowledgeable and considerate enough to extend their offer of help, to be of assistance to those of us who are not quite proficient with the application.
If I could get some help with this File Format, I would in return, create a detailed document & publish it on this forum, so that many more could benefit from it.
I thank you all in advance.
I am wondering if you ever got the RBC EFT for Payables File Fomat figured out? We are in the process of trying to implement EFT for payables with RBC and I wondered how you made out.
Thanks for any input or advice that you may have.
Hi All - I wish you luck!! I have in the past suggested that we create a repository of tested and implemented 'hand made' EFT file formats. But got absolutely no response. I'd still be interested in getting something like this going though.
If anyone wants to send me the RBC file specification document - I'll take a look and see if there is anything that jumps out as being a potential problem.
At the end of the day - make your absolute best attempt at the file - and submit it to the bank for testing -- they will quickly identify the problem areas.
I second Ian in this topic... the EFT file format is very specific for each bank. We use EFT format, but don't have the RBC in our list of financial partners. At the end of the day, it's not that much difficult and as Ian said, start with something and let it check by the bank, or even better let them send you a sample of how the file is supposed to look. Some banks use a single line of data which contains all, and some are more likely to use a header-detail type style. I think GP has some default templates for the TD and NB in Canada. You can start of one those templates. If you don't find them, contact me by e-mail and I'll send you a template for the TD Bank (80 columns row format).
I am working with this for Dynamics GP. In Dynamics GP, there is an EFT format predefined for RBC that looks like it matches their specification. I have used this to format an output file for CAD transactions to Canadian vendors. However, for US vendors they require additional IAT lines. These are included in the predefined RBC format, but I can't seem to get GP to generate the lines. If anyone knows what settings are needed to get GP to create the RBC IAT lines in the output file, I'd appreciate any suggestions. Thanks.
Hi Everyone: Thank you for all of your responses. I realize now that there are standard file formats for 5 of the large Canadian banks.
If you google for EFT file Format Specifications for Canadian Banks, including the Royal Bank of Canada, you'll be able to see them. There is some Client specific tweaking, but very little. Theses specific items are based on the EFT Bank Maintenance information, under Financials > Checkbook (besides of course, the vendor banking information).
As soon as I am able to get some time, I'll do a write up for the benefit of those whoare new to the porocess, as I was several months ago.
If you have any specific question I can help you with in the meantime, please post it here or drop me a note @ email@example.com.
Regards to all.
I see this post was several years ago and I hope you have successfully managed to get the IAT lines generated. I also hope you would share your results - how did you get this to work?
Business Applications communities