A few employees set up for Direct Deposit receive a check instead of a Direct Deposit Earnings Statement when using Payroll Direct Deposit in Microsoft Dynamics GP

A few direct deposit employees receive a check instead of a direct deposit earnings statement. In prior payruns, the employees received a Direct Depsoit Earnings Statement, but are getting a check on the current payrun for no reason.

Symptoms

In the Direct Deposit Employee Master (DD00100) table, the Employee ID is mis-matched with upper and lower case letters when you compare it to the Payroll Employee Master (UPR00100) table. Consequently, Microsoft Dynamics GP incorrectly reads the direct deposit line for the employee and results in a check generated.

Cause

The Employee ID column in the Direct Deposit table needs to be corrected to match the Employee ID column in the Payroll Employee Master table. 

Note Before you follow the steps below, make a current backup copy of the company database so you can restore if a problem occurs. 



To resolve this problem, follow these steps:


1. Open a SQL query window using the appropriate method below: 

•If you use Microsoft SQL Server 2008, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2008 , and then click SQL Server Management Studio .

•If you use Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio .

•If you use Microsoft SQL Server 2000, start SQL Query Analyzer. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .



2. Copy the below script into the query window and execute against the Company database.

update b set b.EMPLOYID= a.employid from UPR00100 a, DD00100 b where a.EMPLOYID = B.EMPLOYID


Resolution

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×