Dynamics Community Forum Thread Details

duplicate DD numbers and missing DD amounts

I have a customer with about 3,000 employees that processes payroll weekly - within the last 2 pay periods - employees set up with DD are not included in the ACH file, not does it show any ACH information on the DD statement. Also, we have several DD statements using the exact same number for 2 employees - I suspect the second one is not getting the DD payments because the first employee got the DD statement number. How do I find this and how do I fix this?

Categories:

Microsoft Dynamics GP

Hi Deborah, usually not something we typically see.

I would when it is a NON payroll week, in the generate ACH window, remove any completed payroll builds to make sure we have no issues with old builds from prior payrolls. Keeping old payroll builds in this window, I can see slow down your post routine as well.

I would also clear the payroll work tables.

Delete DYNAMICS..UPR10300

Delete DYNAMICS..UPR10304

Delete UPR10200

Delete UPR10201

Delete UPR10202

Delete UPR10203

Delete UPR10204

Delete UPR10205

Delete UPR10206

Delete UPR10207

Delete UPR10208

Delete UPR10209

Delete UPR10213

Delete UPR19900

Delete UPR19901

And since this is DD, clear these tables as well too

delete DD10100

delete DD10200

delete DD10300

delete DD10400

delete DD10500

delete DD10600

Then if you wanted to test, you could copy LIVE to TEST at this point.

Run a payroll for a few of the "bad" employees in test and then see if all is OK

We typically don't see employees get the same earnings statement number, but maybe you want to set that up with some leading 0000 in the Direct Deposit setup window as well, not sure what they are using there but could be part of the issue.

This seems pretty complex type issue, if it continues to happen and maybe things were imported, I'm not sure, you may need to create a case for further assistance if needed and we need to look at the employee record and DD line items were they actually keyed or imported that are causing the problem, etc.

Thanks

Terry Heley

Microsoft

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL