Error message if you try to select a purchase order in the Purchasing Invoice Entry window in Microsoft Dynamics GP: "You cannot receive against unauthorized purchase orders”

SYMPTOMS

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.

RESOLUTION

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

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 .

a.

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

Note Replace

b.

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?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×