Error message when you try to print an imported purchase order in Microsoft Dynamics GP: "A Get/Change Next Operation on table POP_PO_Line failed"


MPTOMS

When you try to print an imported purchase order in Microsoft Dynamics GP, you receive the following error message:

A Get/Change Next Operation on table POP_PO_Line failed. A Record was already locked.

CAUSE

This problem occurs if one of the following conditions is true:

• A user session is unresponsive or is inactive. See resolution 1.
• The purchase order is missing a field. See resolution 2.



     

RESOLUTION

Resolution 1: Delete any unresponsive records

1. Back up the Microsoft Dynamics GP company database.
2. Back up the Dynamics database.
3. Have all users log out of Microsoft Dynamics GP.
4. Stop and then start the Microsoft SQL Server to clear out the temporary tables.
5.

In SQL Query Analyzer, select the Dynamics database. Then, use the following statements to delete all the records from the ACTIVITY, SY00800, and SY00801 tables:

delete ACTIVITY
delete SY00800
delete SY00801



     
6. Log back on to Microsoft Dynamics GP as a user who has the system administrator role.
7. On the File menu, point to Maintenance , and then click Check Links .
8. In the Check Links window, click Purchasing in the Series list.
9. In the Logical Tables list, click Purchasing Transactions , click Insert , and then click OK .
10. Select a destination for the report, and then click OK .
11. On the Tools menu, point to Utilities , point to Purchasing , and then click Reconcile Purchasing Documents .
12. Click Reconcile and Print Report , and then click Process .

Resolution 2: Make sure that the purchase order fields are populated in the POP10110 table

1. Back up the Microsoft Dynamics GP company database.
2. Back up the Dynamics database.
3. On the Cards menu, point to Inventory , and then click Vendors .
4. In the Item Vendors Maintenance window, verify that the Vendor ID field is populated for the item numbers on the purchase order.
5. If the Vendor ID field is not populated, type the vendor ID in the field.
6. Start SQL Query Analyzer. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .
7. In the database list, click your company database.
8. Copy the following SQL statement to the Query window.
SELECT * FROM POP10110 where PONUMBER ='xxx'
Note The xxx placeholder represents the purchase order number.
9. On the Query menu, click Execute .
10. Note the DEX_ROW_ID value of the record.
11. Verify that there is a value under the VNDITNUM column.
12. Update the VNDITNUM column in the POP10110 table to reflect the value in the Vendor Item field in the Item Vendors Maintenance window in Microsoft Dynamics GP. To do this, follow these steps:
a. Start SQL Query Analyzer.
b. In the database list, click the company database.
c. Copy the following SQL statement to the Query window.
UPDATE POP10110 SET VNDITNUM = 'xxx' WHERE DEX_ROW_ID = 'yyy'
Note The xxx placeholder represents the value in the Vendor Item field in the Item Vendors Maintenance window. The yyy placeholder represents the DEX_ROW_ID value of the record that you are updating.
d. On the Query menu, click Execute .
e. Exit SQL Query Analyzer.

APPLIES TO


Microsoft Dynamics GP 9.0
Microsoft Business Solutions–Great Plains 8.0
Purchase Order Processing

DISCLAIMER 

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.