If you try to select a purchase order in the Purchasing Invoice Entry window in Microsoft Dynamics GP, you receive the following error message:

          You cannot receive against unauthorized purchase orders.

Additionally, you cannot mass approve the purchase orders that are in the Purchase Order Enhancements Entry window.

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

• When you activate a purchase order, you deactivate a purchase order, and then you reactivate a purchase order, the activation process does not correctly update the approval status of the purchase orders. For you to successfully enter or match invoices, purchase orders must have a status of Approved .
• Canceled purchase orders or some canceled line items in purchase orders remain in the CPO10110 table. Canceled line items must not appear in this table.


To resolve this problem, try method 1. If method 1 does not resolve the problem, try method 2.

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.


Method 1


Make sure that purchase orders have a status of Approved in the POA40003 table. To do this, run the following statements against the company database in Microsoft SQL Query Analyzer. To start SQL Query Analyzer, click Start , point to Programs , point to Microsoft SQL Server , and then click Query Analyzer .


Run the following SELECT statement to locate the purchase order and the DEX_ROW_ID value for the record.

Note Replace


Run the following UPDATE statement to set the purchase order status to Approved by using the DEX_ROW_ID value for the record as the condition. UPDATE POA40003 SET POA_PO_APPROVAL_STATUS = 2 where DEX_ROW_ID = ‘<yyy>’ Notes • In this statement, replace

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!