Dynamics Community Forum Thread Details

EFT File Generation — Company Bank Info Missing from ACH RB Detail + 6 Transactions Per Line

Hi everyone,

I am working on a NAV to Business Central migration for a client using the Canadian EFT localization (CA EFT DEFAULT). I have two issues I need help with.

─────────────────────────────────────
ISSUE 1 — Company Bank Account Information Not Flowing into ACH RB Detail (Table 10304)
─────────────────────────────────────

When the EFT file is generated, the ACH RB Detail staging table (Table 10304) only gets populated with vendor/beneficiary information. However, the bank file specification also requires the originator's (company) bank details in each transaction record — specifically the User Institution No., User Transit No., and User Return Account No.

Standard BC does not seem to flow Company Information bank fields into Table 10304 automatically. My plan is to:
- Add custom fields to Table 10304 via a TableExtension
- Populate them from Company Information when the staging table is filled

Has anyone handled this before? Is there a subscriber which can handle this?

─────────────────────────────────────
ISSUE 2 — Bank Requires 6 Transactions Per Line, BC Generates 1
─────────────────────────────────────

The bank file specification (CPA 005 standard) requires that each record line contains exactly 6 transactions grouped as segments, making each line exactly 1,464 characters. If the last line record has fewer than 6 transactions, the remaining segments must be blank-padded to reach 1,464 characters.

Standard BC Data Exchange Framework is generating one transaction per line which is causing the file to be rejected by the bank portal. How do you achieve the 6-transactions-per-line structure in BC? Is there a standard way to handle this or does it require a fully custom file generator codeunit? I was thinking that if there's any last minute subsciber where I can handle this stuff, in this way I can totally avoid writting my own logic.

Thanks in advance!

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

Microsoft Dynamics NAV

Hello,

When handling this in the past you have an alternative option. You can hardcode those field values if they are the originators information. You can just enter the Originator Account Number or Transit Code or whatever other fields you need:

If you want to customize it you need to add fields to the ACH RB Detail Table (10304) and then you can take those fields and use them in your field mapping.

For Isssue 2 i'm not sure on your exact problem but you can just set the length on the fields in the Column Definitions and add multiple blank "Filler" values for padding in the footer. I also make sure my Detail and Header sections are the same. This is what I do for all Canadian EFTs without issue:

The 1464 byte files should then work the same whether there is 1 payment line or 100 payment lines. As long as the sum of all lengths matches the mapping file. I've setup the 1464 byte/CPA005 formats this way and they've all been accepted by the major Canadian banks.

Here is an example of the Header section too: