Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

Payroll ACH File with rows of 9999999

Posted on by 725

We are implementing direct deposit from Dynamics GP 2016R2 payroll. When we generate the ACH file pre-note test, everything looks good, but at the bottom there are 6 rows of 9999999999999999's. Does anyone know why that would occur?

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,252 on at
    RE: Payroll ACH File with rows of 9999999

    Hello,

    How can I add rows of 9999999 in Payable EFT file generated from GP?  number of rows divided by 10.  NACHA file format is : US-NACHA-CCD+.  

    Thanks much

    Sandip

  • erowden Profile Picture
    erowden 725 on at
    RE: Payroll ACH File with rows of 9999999

    Thank you. That makes sense and we did a test with the bank today and it worked.

  • Verified answer
    Mike Bufano Profile Picture
    Mike Bufano 1,480 on at
    RE: Payroll ACH File with rows of 9999999

    99999's are padded at the bottom of the file.  The file needs to have at least 10 rows.. (the number of rows is a configuration but the default is 10).

    I believe that it will add rows of 99's to make the file contain a  number of rows divided by 10 as well.

    There is a box to remove the padding if you dont' need them in the setup, but the question is does your bank accept the file?  If you bank accepts the file then you need the padding.

    regards

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: Payroll ACH File with rows of 9999999

    Hi Liz,

    Did you looked at those support pages ?

    support.microsoft.com/.../guidelines-to-follow-when-you-generate-eft-files-or-eft-prenote-files

    community.dynamics.com/.../microsoft-dynamics-gp-payroll-direct-deposit-nacha-compliant

    based on this, can you confirm from where you got the specs for the ACH file format ?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans