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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Direct Debit for Receivables

(0) ShareShare
ReportReport
Posted on by 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
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans