Skip to main content

Notifications

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:
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 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 727 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 Super User 2024 Season 1 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans