Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / After Generate ACH fil...
Finance | Project Operations, Human Resources, ...
Suggested answer

After Generate ACH file, DD10100 not clearing deposits

(0) ShareShare
ReportReport
Posted on by CRUIZ2020 26

When we generate our ACH file for direct deposits from Payroll we DO NOT "Delete the build after use".  We do not check this box because we have found times where our file does not generate properly and we just need to re-run or rebuild the file.  However, we are finding that when we run the Direct Deposit Register from the Generate ACH File window, the report contains records from the previous payroll run.  When we check the DD10100, we do see the records are still there when they should not be.  How can we make sure our register only contains the current batch we have checked and the records are cleared from the DD10100 without scripting them out?

Categories:
Microsoft Dynamics GP
  • Deb@gpsupport Profile Picture
    Deb@gpsupport 112 on at
    RE: After Generate ACH file, DD10100 not clearing deposits

    I have a company that is having an issue where after we cleared the DD10100 table for 1 employee that showed up from a 8/25/2022 payroll before running the payroll for 10/25/22 payroll.  After we posted the 10/25/22 payroll the old DD for her showed up again in the DD10100 table.  What would make this happen, every pay period?  They don't want to have to involve IT every pay run to make sure her DD from August doesn't get included again.

    They are on GP 18.4.1384

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: After Generate ACH file, DD10100 not clearing deposits

    I would make sure it is not a payroll week and all deposits have been filed with the bank.

    Then I would delete all the builds from the generate ACH window as we know they have all gone to the bank.

    (If that gets large we have seen it slow down posting performance for payroll )

    Then run this script against the company

    delete dd10100

    Now run payroll and see if it works as you expect it.

    If you want, you can always "delete out" the prior weeks payroll from the Generate window before starting the new weeks payroll, this way it is fairly cleared out in the generate window too and by the time you start the new payroll all should have competed from the bank.

    Thanks

    Terry

    Microsoft

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans