Suggested by Conrad Cattle – Completed
In Data Exchange Definitions, for creating EFT file exports:
The Detail Field Lookup Table (10304) and the Footer Field Lookup Table (10305) should include the File Creation Number (item 7 in table 10303).
This is a requirement for the standard EFT file upload standard CPA 005 1464.
CPA 005 1464 format files are accepted at the following banks:
HSBC
Toronto Dominion (TD)
Scotiabank
Royal Bank of Canada (RBC)
Bank of Montreal (BMO)
This is the standard EFT Export format of Sage Canada.
Requirements for CPA 1464 are located here:
for ATB (pages 45-47): https://www.atb.com/learn/resources/Documents/EFT_User_Guide.pdf
for BMO (pages 61-66): http://www.bmocm.com/products/treasury/cda/ccbc/implementation/userguides/images/EFT.pdf
for RBC (pages 5-8): https://www.rbcroyalbank.com/ach/file-451771.pdf
for HSBC: they send a PDF to their customers and I can send this to you, unfortunately this site doesn't allow attachments
I have already created a similar request but it didn't have enough detail. It is located here: https://experience.dynamics.com/ideas/idea/?ideaid=e0c833d0-d583-e911-80e7-0003ff689ebe
Status Details
Thank you for the suggestion. We are adding the capability for you to map File Creation Number in Detail and Footer.
Thanks
Søren Alexandersen, Program Manager, Localization
Is there an update on this? Any progress?
The only EFT export format I see doesn't meet the CPA 005 1464 format.
I can confirm, CPA 005 1464 is not available. We've been adding this format to every single customer based in Canada.
The header/footer table is missing some field that we've made custom.
Would be great to have this out of the box on D365 BC