Error - "The employee record cannot be inactivated or deleted Pay run is in progress for this employee"
- UPR_WORK_Local Tax
To resolve this problem, follow these steps:
Step 1: Delete records in Payroll work tablesFollow one of the options below to delete the activity from the payroll work tables. To have us delete records for you, go to the Option 1: "Fix it for me" section. To delete records yourself, go to the Option 2: "Let me fix it myself" section.
Option #1: Fix it for meTo clea the payroll work temp tables automatically, have all users exit Microsoft Dynamics GP, and then click the Fix this problem button or link. Click Run in the File Download dialog box, and then follow the steps in the Fix it wizard.
Note This wizard may be in English only; however, the automatic fix also works for other language versions of Windows.
Note If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
Option #2: Let me fix it myselfTo clear the payroll work tables yourself, follow these steps:
- Open Microsoft SQL Server 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.
- Run delete statements against the company database.
Note The first two lines in the script delete the contents of the activity files in the Dynamics database. The other lines delete the contents of the work files and the activity files in the Company database.
Delete DYNAMICS..UPR10300Delete DYNAMICS..UPR10304Delete UPR10200Delete UPR10201Delete UPR10202Delete UPR10203Delete UPR10204Delete UPR10205Delete UPR10206Delete UPR10207Delete UPR10208Delete UPR10209Delete UPR10213Delete UPR10301Delete UPR19900Delete UPR19901
- If you use Direct Deposit, run delete statements for Direct Deposit:
Delete DD10100 --(Direct Deposit Employee Deposit Work) Delete DD10200 --(Direct Deposit ACH Copy) Delete DD10300 --(Direct Deposit ACH Cross Reference) Delete DD10400 --(Direct Deposit ACH Header) - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file.) Delete DD10500 --(Direct Deposit ACH Items) - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file.) Delete DD10600 --(Direct Deposit Prenotes Completed) Delete DD10700 --(Direct Deposit Exceptions)
Step 2: Delete temporary filesTo delete temporary files, open Windows Explorer, and then click the Temporary directory. The Temporary directory has the following path:
In the directory, delete the files that begin with TNT. Then, delete the files that have a .tmp file name extension.
Step 3: Perform Check LinksCheck Links will check the linking of the data between the tables to ensure data integrity. To do this, follow these steps:
- Open the check Links window. In Microsoft Dynamics GP click Microsoft Dynamics GP, click Maintenance, and then click Check Links.
- In the Series list, click Payroll.
- In the Logical Tables list, click Payroll Transactions, click Insert, and then click OK.
- In the Report Destination dialog box, click to select the appropriate check box, and then click OK.
Note You can safely ignore the error messages that occur in the error log. The Check Links process is reattaching the batch ID to the existing transactions.
NOTE: If your batch should have been a recurring batches, and was rebuilt by the Check Links process, the batch frequency was set to 'single use' by default. Click Transactions, click Payroll, and then click Batches and select the Batch ID that was recreated, and review the Batch settings. If this should be a recurring batch, change the frequency to a Frequency other than Single Use.
Step 4: Build the check file
Build the check file again. All the batches are still in the check file.
Q1: I don't want to delete the whole payroll batch and start completely over, should I still follow the steps above?
A1: Yes, the Transactions in the payroll batch are stored in the UPR10302 Payroll Transactions table, and you are not deleting that table in the scripts above, so the transactions are not getting removed. The scripts only remove the batch header record (UPR10301) and when you run checklinks, the system will recreate that batch header record again (because it sees it on the transactions still, so it will recreate it.),
Q2: I posted the new batch and it disappeared. It should have been a recurring batch.
A2: When you ran check links to rebuild the batch, it built it with a 'single use' frequency by default. You should have edited the batch frequency before posting it, if it should have been a recurring batch. If you posted the batch, it's too late now. You will need to manually key the batch/transactions back in again (starting on the next posting date needed), and change the frequency on the new batch to be used going forward.