web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Direct Debit for Recei...
Microsoft Dynamics GP (Archived)

Direct Debit for Receivables

(0) ShareShare
ReportReport
Posted on by Chris Conway 5

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 post is locked for comments

I have the same question (0)
  • Suggested answer
    Shabareesh Profile Picture
    Shabareesh on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans