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.
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 .