Key segment not found and unable to register table GL_Acct_Mstr

This error was encountered after printing a batch of AP checks and during the post operation.  The checks printed fine. However the posting report was lost.  GL seems to have been updated correctly.

I’ve written extensively about the problems with reports dictionaries. It is one of the weak links in GP.  Anyone who tells you to have one shared reports dictionary is not doing you any favors.  Therefore, have multiple copies and backups of your reports dictionaries.

First, delete or rename the reports dictionary.  Launch GP, then import your package file to recreate the reports dictionary.  See post http://evarsys.com/dynamicsgp/?p=253

Second, rebuild the GL account index file.  Below are the complete steps taken from the MS Techknowledge article 855963.  As always make sure to backup your company database in Enterprise Manager or SQL Management Studio.

1. Have all users exit Microsoft Dynamics GP.

2. Delete the contents of the Account Index Master table.

a. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

Method 1: For SQL Server Desktop Engine

If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

Method 2: For SQL Server 2000

If you are using 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.

Method 3: For SQL Server 2005

If you are using 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.

Method 4: For SQL Server 2008

If you are using SQL Server 2008, start SQL Management Studio. to do this, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.

b. Run the following statement against the company database:

Delete GL00105

3. Start Microsoft Dynamics GP.

4. Follow the appropiriate step:

In Microsoft Dynamics GP 10.0, on the Microsoft Dynamics GP menu, point to Maintenance, and then click Check Links.

In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions – Great Plains 8.0, on theFile menu, point to Maintenance, and then click Check Links.

5. In the Series list, click Financial.

6. In the Logical Tables list, click Account Master.

7. Click Insert, and then click OK. When you are prompted, click to select the Screen check box to generate the error log report to the screen, and then click OK. After the check links process is complete, a report is generated.