For example, the CMPANYID value should be -1 for all records in the SY00600 table in the sample Fabrikam, Inc. TWO database.
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()
Steps to reproduce the behaviorIf the SY00600 table in the company database contains CMPANYID values that reference a different company, follow these steps:
- Click Purchasing, and then click Requisitions.
- Filter the records by the specific vendor, and then click the green arrow to start the search.
- When the results of your search appear, click to select the requisition or the requisitions that you want to convert to a purchase order.
- Click Create. You receive the error message that is mentioned in the "Symptoms" section.
Article ID: 894347 - Last Review: 10 Jan 2015 - Revision: 1