Issue

I have a batch that is marked for posting in Payroll which states checks are currently being printed. How do I unmark the batch?

The following error messages may also occur to indicate the Payroll batch is stuck:

  • “Open operation on UPR_Temp_Post2 has incorrect record length”
  • “Remove Range Operation on Table ddDeposits has caused known error 2”
  • “Batches with zero transactions cannot be marked”
  • “Another user is performing a check run”
  • “UPR_Work_Post failed accessing SQL data”
  • “The employee record cannot be inactivated or deleted Pay run is in progress for this employee”Also, an Open Operation, Get/Change, or Save Operation error may occur on one of the following files to indicate the Payroll batch is stuck:
    UPR_WORK_MSTR
    UPR_WORK_MSTR_Detail
    UPR_WORK_HDR
    UPR_WORK_Pay_Type
    UPR_WORK_Deduction
    UPR_WORK_Benefit
    UPR_WORK_State_Tax
    UPR_WORK_Local Tax
    UPR_WORK_Check
    UPR_WORK_Post
    UPR_Flat_Tax_Records
    UPR_Account_Cache

Resolution – SQL or MSDE  (scroll down for PSQL)

Perform the following steps to eliminate any of the errors mentioned above:

1. Run the following script in Query Analyzer or the Support Administrator Console on MSDE against the COMPANY database.  Note – The first two lines in the script will delete the contents of the activity files in the Dynamics database and the rest of the files will delete the contents of the work and activity files in the Company database.

Delete DYNAMICS..UPR10300
Delete DYNAMICS..UPR10304
Delete UPR10200
Delete UPR10201
Delete UPR10202
Delete UPR10203
Delete UPR10204
Delete UPR10205
Delete UPR10206
Delete UPR10207
Delete UPR10208
Delete UPR10209
Delete UPR10213
Delete UPR10301
Delete UPR19900
Delete UPR19901

2. Open Windows Explorer and select the Temporary directory (C:\Windows\Temporary). Delete the files in the directory that begin with “TNT” and delete the files that have a “tmp” extension.

3. If you have Direct Deposit, run the following scripts:

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)

4. In Dynamics, go to File | Maintenance | Check Links (make sure everyone is logged out).  Choose Payroll for the Series and insert the Payroll Transactions.  Process this.  You will get errors on the error log which you can ignore as the Check Links process is re-attaching the Batch ID to the existing transactions.

5. Build the check file again; all batches will still be there.

Note:
If you have recurring batches and you delete the UPR10301 above, when you run check links the frequency will default back to single use. Before posting the batch, you will need to go to Transactions | Payroll | Batches pull up the recurring batch and change the frequency to something other than Single.

Did you find this article helpful? Look for more documents like it on TechKnowlege in CustomerSource!