Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

After Generate ACH file, DD10100 not clearing deposits

Posted on by 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?

  • Deb@gpsupport Profile Picture
    Deb@gpsupport 108 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

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,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans