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"
This article provides a solution to an error that occurs when you print an imported purchase order in Microsoft Dynamics GP.
Applies to: Microsoft Dynamics GP
Original KB number: 926390
Symptoms
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 1: Delete any unresponsive records
Back up the Microsoft Dynamics GP company database.
Back up the Dynamics database.
Have all users log out of Microsoft Dynamics GP.
Stop and then start the Microsoft SQL Server to clear out the temporary tables.
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
Log back on to Microsoft Dynamics GP as a user who has the system administrator role.
On the File menu, point to Maintenance, and then click Check Links.
In the Check Links window, click Purchasing in the Series list.
In the Logical Tables list, click Purchasing Transactions, click Insert, and then click OK.
Select a destination for the report, and then click OK.
On the Tools menu, point to Utilities, point to Purchasing, and then click Reconcile Purchasing Documents.
Click Reconcile and Print Report, and then click Process.
Resolution 2: Make sure that the purchase order fields are populated in the POP10110 table
Back up the Microsoft Dynamics GP company database.
Back up the Dynamics database.
On the Cards menu, point to Inventory, and then click Vendors.
In the Item Vendors Maintenance window, verify that the Vendor ID field is populated for the item numbers on the purchase order.
If the Vendor ID field is not populated, type the vendor ID in the field.
Start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
In the database list, click your company database.
Copy the
SELECT * FROM POP10110 where PONUMBER ='xxx'
SQL statement to the Query window.Note
The xxx placeholder represents the purchase order number.
On the Query menu, click Execute.
Note the DEX_ROW_ID value of the record.
Verify that there is a value under the VNDITNUM column.
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:
Start SQL Query Analyzer.
In the database list, click the company database.
Copy the
UPDATE POP10110 SET VNDITNUM = 'xxx' WHERE DEX_ROW_ID = 'yyy'
SQL statement to the Query window.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.
On the Query menu, click Execute.
Exit SQL Query Analyzer.
Disclaimer
Microsoft and/or its suppliers make no representations or warranties about the suitability, reliability or accuracy of the information contained in the documents and related graphics published on this website (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.