|1. ||Have all the users exit Microsoft Dynamics GP. |
|2. || |
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 . Open a New query window.
|3. ||Run the following statements against the DYNAMICS database. (No users should be in Dynamics GP at all when executing these scripts:) |
|4. ||Run the following statement against the company database. Update the checkbook ID. |
DELETE CM10100 where CHEKBKID = 'XXX'
DELETE CM10101 where CHEKBKID = 'XXX'
|5. ||Perform the Check Links routine on the CM Transaction file and on the Checkbook Master file. To do this, follow these steps: |
|a. || |
Point to Maintenance on the Microsoft Dynamics GP menu, and then click Check Links .
|b. ||In the Series list, click Financial . |
|c. || |
Insert the following files:
• CM Transaction
• Checkbook Master
|d. ||Click OK . |
|6. ||To determine whether a deposit number is in the Deposit_In_Progress field, run the following statement against the CM00100 table. |
SELECT * FROM CM00100
|7. ||On the Cards menu, point to Financial , and then click Checkbook . |
|8. ||In the Checkbook ID list, click a checkbook. |
|9. ||Note the value in the Next Deposit Number field. |
|10. ||If the value in the Deposit_In_Progress field in step 6 is equal to or less than the value that you noted in step 9, set the value of the Deposit_In_Progress field to ' ' (blank). To do this, run the following script against the company database. |
UPDATE CM00100 SET Deposit_In_Progress = '' where CHEKBKID = '<XXX>'Note <XXX> is a placeholder for the value in the Checkbook ID list.