Error message when you try to activate the Purchase Order Approvals feature in the PO Enhancements Setup window in Microsoft Dynamics GP: "A get/change next operation on table 'POP_PO' is for an invalid key"

Symptoms

When you try to activate the Purchase Order Approvals feature in the PO Enhancements Setup window in Microsoft Dynamics GP and Microsoft Business Solutions – Great Plains 8.0, you receive the following error message:

Cause

This problem is caused if invalid fields exist in the POP10100 table or the POP10110 table. Before the Purchase Order Approvals feature is activated, the system scans through purchase orders in the POP10100 table and the POP10110 table.



The following problems will cause the Purchase Order Approvals activation to fail:

• The Vendor ID field is blank.
  

• The PO Number field is blank.
  

• The PO Status field is invalid.
  

• The PO Type field is invalid.
  

• The Document Date field is blank.
  

• The User To Enter field is blank

Resolution

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

1. Have all users exit Microsoft Dynamics GP and Microsoft Business Solutions – Great Plains 8.0.
   
   

2. 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.
   

3. Run the following statement against the company database:
   
   

   /*POP Header*/
   Select * from POP10100 where POTYPE not in (1,2,3,4)
   Select * from POP10100 where POSTATUS not in (1,2,3,4,5,6)
   
   Select VENDORID, PONUMBER, DOCDATE, STATGRP, DEX_ROW_ID From POP10100 
   Where VENDORID = '' 
   or PONUMBER = '' 
   or DOCDATE = '' 
   or STATGRP = ''
   or USER2ENT = ''
   
   
   /*POP Line*/
   Select * from POP10110 where POLNESTA not in (1,2,3,4,5,6)
   Select * from POP10110 where POTYPE not in (1,2,3,4)
   
   

4. View the results to determine the problem purchase order.
   
   

5. Delete the purchase order in Microsoft Dynamics GP or in Microsoft Business Solutions – Great Plains 8.0.
   
   Note If you cannot delete the purchase order, contact your Microsoft Partner or Dynamics Technical Support. For information about technical support for deleting a purchase order, visit the following Microsoft Web site:
   
   

   http://www.microsoft.com/dynamics/support/default.mspx

6. Verify that you no longer receive the error message described in the “Symptoms” section:
   
   

   1. Follow the appropriate step:
      

      • In Microsoft Dynamics GP 10.0, on the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Purchasing, and then click Purchase Order Enhancements.
        

      • In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions – Great Plains 8.0, on the Tools menu, point to Setup, point to Purchasing, and then click Purchase Order Enhancements.
        

   2. Click to select the Activate Approvals check box.

   3. Click to select the Approval Setup check box, set up the approvals, and then click OK.
      
      
      

More Information

The following values are valid values for POP Type field:

• 1 = Shipment
  

• 2 = Invoice
  

• 3 = Shipment/Invoice
  
  

The following values are valid values for POLNESTA field:

• 1 = New
  

• 2 = Released
  

• 3 = Change Order
  

• 4 = Received
  

• 5 = Closed

• 
  6 = Cancelled

References