28
Dear Microsoft Team,
As you, probably, know Canadian EFT (ACH) formats vary from bank to bank. You have already set the default CA EFT to RBC. Excellent. Our existing and particularly prospective clients that use other banks need a bit more flexibility to choose Business Central. For example, those that use Scotiabank (CPA005 EFT standard) need that OOB EFT functionality in Business Central must allow the following:
1) Date format: YYYDDD (current is YYYYDDD and substring Transformation Rule does not work as it should);
2) File Creation Number (FCN) must be available on Detail and Footer (it is already available on Header)
3) Originator's cross-reference number (19 characters) on Detail - Users must be able to map this field in Data Exchange Definition to "Document No." Field on the Payment Journal
Because this can be of use to a lot of exiting and prospective Business Central users, my colleagues and I hope that the above suggestions can be considered by Microsoft Team soon.
Thank you,
Iaroslav
(Consultant at BDO [Partner])
As you, probably, know Canadian EFT (ACH) formats vary from bank to bank. You have already set the default CA EFT to RBC. Excellent. Our existing and particularly prospective clients that use other banks need a bit more flexibility to choose Business Central. For example, those that use Scotiabank (CPA005 EFT standard) need that OOB EFT functionality in Business Central must allow the following:
1) Date format: YYYDDD (current is YYYYDDD and substring Transformation Rule does not work as it should);
2) File Creation Number (FCN) must be available on Detail and Footer (it is already available on Header)
3) Originator's cross-reference number (19 characters) on Detail - Users must be able to map this field in Data Exchange Definition to "Document No." Field on the Payment Journal
Because this can be of use to a lot of exiting and prospective Business Central users, my colleagues and I hope that the above suggestions can be considered by Microsoft Team soon.
Thank you,
Iaroslav
(Consultant at BDO [Partner])
STATUS DETAILS
Completed
Business Central Team (administrator)