Article ID: 851664 - View products that this article applies to.
When you select a batch in the Build Payroll Checks window in Microsoft Dynamics GP, you may receive one of the following error messages:
Error message 1
Error - "Open operation on UPR_Temp_Post2 has incorrect record length"
Error message 2
Error - "Remove Range Operation on Table ddDeposits has caused known error 2"
Error message 3
Error - "Batches with zero transactions cannot be marked"
Error message 4
Error - "Another user is performing a check run"
Error message 5
Error - "UPR_Work_Post failed accessing SQL data"
Error message 6
Error - "The employee record cannot be inactivated or deleted Pay run is in progress for this employee"
Error message 7
Error - "Checks cannot be calculated. Errors were found."
Error message 8
Error - "You cannot void a check. A computer check run is in process."
Error message 9
Error - "You cannot edit a batch marked for posting"
Error message 10
Additionally, an Open Operation error, a Get/Change error, or a Save Operation error may occur on one of the following files to indicate that the Payroll batch is stuck:
Error - "Batch is marked for posting and cannot be edited."
This problem may occur if the payroll work tables have not been cleared. The payroll work tables must be cleared to release the batch.
Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs
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.
Fix this problem
Microsoft Fix it 50427
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:
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:
Step 4: Build the check fileBuild the check file again. All the batches are still in the check file.
Note If you have recurring batches, and you delete the UPR10301 file in step 1, the frequency defaults back to single use when you run the Check Links process. Before you post the batch, click Transactions, click Payroll, and then click Batches. Select the recurring batch, and then change the frequency to a frequency other than Single.
Article ID: 851664 - Last Review: April 4, 2013 - Revision: 12.0
Contact us for more help
Connect with Answer Desk for expert help.