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 :
Finance | Project Operations, Human Resources, ...
Answered

Payroll ACH File with rows of 9999999

(0) ShareShare
ReportReport
Posted on by 727

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?

Categories:
I have the same question (0)
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    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 ?

  • Verified answer
    Mike Bufano Profile Picture
    1,484 on at

    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

  • erowden Profile Picture
    727 on at

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

  • sandipdjadhav Profile Picture
    18,306 on at

    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

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans