Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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"


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


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()

↑ Back to the top


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.

↑ Back to the top


Keywords: kbnosurvey, kbfreshness2007, kbmbsgp10,, kbgreatplainsbp, kbmbsmigrate, kbbug, kb

↑ Back to the top

Article Info
Article ID : 894347
Revision : 1
Created on : 3/3/2017
Published on : 1/10/2015
Exists online : False
Views : 302