Finance | Project Operations, Human Resources, ...

After Generate ACH file, DD10100 not clearing deposits

(0) Share

Report

Posted on by CRUIZ2020

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

All responses (2)

Answers (0)

Sort by

Suggested answer

Terry R Heley Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Deb@gpsupport 117 on at

Like (0)

Report
Copy link

Link copied!

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