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