Open Forum

Expand all | Collapse all

Addenda not showing on EFT File

  • 1.  Addenda not showing on EFT File

    Posted Apr 05, 2019 02:45 PM
    We are trying to get the addenda lines to show on the EFT when selecting the addenda option when generating the file.
    This wonks on one entity within GP but not the others.  Has anyone ran into this issue before, and if so how can we go by fixing it?

    I found a post where they said this was buggy (this was a 2 year old post( and there was a work around posted we do not understand how to "hard code the addenda count at one".  The other post is

    Anna Logan
    Columbus OH
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Addenda not showing on EFT File

    Posted Apr 09, 2019 11:16 AM
      |   view attached
    Hi Anna.
    Unfortunately, my comment from that thread is still valid.  Microsoft's work around for this issue is to email remittance advices to vendors when you generate EFT payments.
    As to how you hard code the addenda count at one, here are the steps:
    • In the EFT File Format maintenance screen, you should use the CCD+ or PDP+ format type.  These are the NACHA formats that include addenda.
    • In the Detail line type, set the Addenda Record Indicator to 1 as a constant
    • In the Addenda line type on that format, set the Addenda Count field to 1 as a constant.
    • Then map the Payment Detail field to the GP table and field where your addenda detail will be found.
    • I have attached a field mapping document for these windows.  However, always check the file mapping reference document from your bank to validate your map layout.

    Lou Spevack
    Systems Accountant | Dynamics Credentialed Professional
    American Council on Education
    Washington DC


    CCD Addenda Mapping.pdf   322K 1 version
    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role