Dynamics Community Forum Thread Details

Direct Debit for Receivables

How do you create the EFT file for Direct Debits for Receivables? In particular, we need to manage the transaction codes easily and create an EFT file.

GP Direct Debits used to do it all. But now it is a module with significant limitations without a processor of the payment portion (EFT transaction).

Currently, we have 3 file formats in EFT for Receivables (Prenote, 1st draw, and ongoing). This is not dirt simple to manage.

Any suggestions are welcome.

This DDR (Direct Debit product), I have found that DDR was designed a long time ago and was designed to work with a 3rd party product named Albany Software’s ‘eBank’ product to generate the DDR file. That is why you are not finding a path or functionality within Dynamics GP to generate the DDR file out of the box. Albany has since discontinued this product, and so Microsoft redesigned the RM EFT functionality (in GP 10.0 version), so you can just use our RM EFT functionality instead.

The DDR functionality was left within Dynamics GP, in case customers were still using it or had customizations for it, etc., but there is no functionality in GP at this time to generate the DDR file (from the DDEU007/DDEU008 tables).

The RM EFT functionality updates the CM20202/CM20203 tables, which are populated by keying a cash receipt and marking it as ‘EFT’ type. (The DDR functionality will also update the CM20202 only, in case customers wanted to point any customizations to this table. But there is not path to generate the DDR file from within Dynamics GP now. You could insert a header record in to the CM20203 table and then you could use our EFT functionality to generate an EFT file, but that is not supported. )

In current versions, I recommend to use ‘RM EFT’ functionality instead of the old DDR functionality for generating this EFT files.

Quick Links

Leaderboard