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"


RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

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:


A get/change next operation on table 'POP_PO' is for an invalid key.

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:

  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