Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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 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

Symptoms

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.

↑ Back to the top

Cause

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.

↑ Back to the top

Resolution

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


↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2450856
Revision : 1
Created on : 1/7/2017
Published on : 8/5/2011
Exists online : False
Views : 150