To resolve this problem, follow these steps.
Run the Check Links procedure
- On the Microsoft Dynamics GP menu, point to Maintenance, and then click Check Links.
- In the Series list, click Sales.
- In the Logical Tables list, click the table that appears in the error message that you received.
- Click Insert, and then click OK.
- If you are prompted to print the Error log, select a destination, and then click OK.
Note For more information about table names, use the Resource Descriptions window. To open the Resource Descriptions window, point to Resource Descriptions on the Tools menu, and then click Tables. - Perform the action that caused the error message that you received.
If you still receive the error message, follow these steps.
Re-create the auto procedure
- On the Microsoft Dynamics GP menu, point to Maintenance, and then click SQL.
- In the Database list, click the company database, and then click the auto procedure that you want to re-create.
- Click to select the Drop Auto Procedure and Create Auto Procedure check boxes, and then click Process.
- Perform the action that caused the error message that you received.
If you still receive the error message, follow these steps.
Re-create the table
To re-create the table without deleting records that are in the table, use the Toolkit. The Toolkit is a tool in the Professional Services Tools Library.
For more information about the Professional Services Tools Library (PSTL), use one of the following options:
Customers:
For more information about PSTL, contact your partner of record. If you do not have a partner of record, visit the following web site to identify a partner:
Microsoft PinpointPartners:
For more information about PSTL, visit the following web site:
https://mbs.microsoft.com/partnersource/downloads/releases/noam_pstl.htmTo re-create the table, follow these steps:
- Exit Microsoft Dynamics GP.
- Back up the Microsoft Dynamics GP code folder.
Notes- By default, the Microsoft Dynamics GP code folder is in the following location:
C:\Program Files\Microsoft Dynamics\GP
- Install the Professional Services Tools Library.
- Start Microsoft Dynamics GP.
- When you are prompted to include new code, click Yes.
- Add the Professional Services Tools Library to the Shortcuts area. To do this, follow these steps:
- In the Shortcuts area, click Add, and then click Other Window.
- Expand Technical Service Tools, expand Project, and then click Professional Services Tools Library.
- Click Add, and then click Done.
- In the Shortcuts area, click Professional Services Tools Library.
- When you are prompted to enter registration keys, click Cancel.
- Click Toolkit, and then click Next.
- Click Recreate SQL Objects, and then click Next.
- In the Series list, click Sales.
- In the Table list, click the table that appears in the error message that you received.
- Click Recreate Selected Table, click to select the Recreate data for selected table(s) check box, and then click Perform Selected Maintenance.
NoteIf the table has a custom trigger, you must manually re-create the trigger. - Perform the action that caused the error message that you received.