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.