Hi Terri,
I understand that you are receiving an error message when you try to post manual payroll checks. I have seen this error occur if there are stuck records in the Payroll Work Tables.
** NOTE: Please ensure that you have a restorable BACKUP prior to performing any system maintenance.
** NOTE: If possible, I highly recommend testing this in a test company created from a backup of your live data prior to setting this up in your live company.
To setup a test company please see KB 885542:
mbs.microsoft.com/.../KBDisplay.aspx
In order to resolve this issue, we will be following the steps found in Knowledge Base article 851664. The article can be found at the following link:
mbs.microsoft.com/.../KBDisplay.aspx
For your convenience, I have copied the steps from the article below:
To clear the payroll work tables yourself, follow these steps:
a. 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 .
b. 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..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
c. 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: Perform Check Links
Check Links will check the linking of the data between the tables to ensure data integrity. To do this, follow these steps:
a. Use the appropriate method to open the check Links window.
• In Microsoft Dynamics GP 10.0 or Microsoft Dynamic GP 2010, click Microsoft Dynamics GP, click Maintenance, and then click Check Links.
b. In the Series list, click Payroll.
c. In the Logical Tables list, click Payroll Transactions , click Insert , and then click OK.
d. 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.
Once you have completed these steps, Build 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 **
