Error message when you try to convert a requisition to a purchase order in Requisition Management for Business Portal in Microsoft Dynamics GP: "Purchase Order Failure"

Applies to: Dynamics GP 2010

Symptoms


When you try to convert a requisition to a purchase order in Requisition Management for Business Portal, you receive the following error message:
Purchase Order Failure, Error in the application - More data was found in the result set than was expected.
This problem occurs in Business Portal in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains.

Cause


The SY00600 table in the company database contains company ID values that reference a different company. All company ID values in this table must be the same.

For example, the CMPANYID value should be -1 for all records in the SY00600 table in the sample Fabrikam, Inc. TWO database.

Resolution


Change the SY00600 table so that all the CMPANYID values are the same. Run the following query on the company database in SQL Query Analyzer:

Note Make a backup of your Great Plains database before you run the query.
update SY00600 set CMPANYID = b.CMPANYID 

from SY00600 a, DYNAMICS.dbo.SY01500 b

where b.INTERID = db_name()

More Information


The cause of this issue can occur when you restore live company databases into test company databases. When the restore process is completed, the final step should be to run the script that is in the following Microsoft Knowledge Base article:
871973 How to set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, or SQL Server 2005

The script will update all tables in a company database to the correct database ID that is referenced in Company Master table SY01500 of the Great Plains database.

Steps to reproduce the behavior

If the SY00600 table in the company database contains CMPANYID values that reference a different company, follow these steps:
  1. Click Purchasing, and then click Requisitions.
  2. Filter the records by the specific vendor, and then click the green arrow to start the search.
  3. When the results of your search appear, click to select the requisition or the requisitions that you want to convert to a purchase order.
  4. Click Create. You receive the error message that is mentioned in the "Symptoms" section.