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
Comments
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
Category: Financial Management
Is there an update on this? Any progress?
The only EFT export format I see doesn't meet the CPA 005 1464 format.
Category: Financial Management
Hi Lisa
We're beginning to look into this area (EFT in general) and would like to create a small V-team with partners to make sure we're making the right changes. If interested, could you please send me an email at soalex@microsoft.com
Thanks in advance!
Best regards
Søren Alexandersen
Program Manager, Business Central Localization
Category: Financial Management
Business Central Team (administrator)