Microsoft KB Archive/890689

= Only the first 16 document types appear in the returned results after you select many sales document types in the Published Order Types list of the Microsoft CRM Integration Settings and Administration tool in Microsoft CRM 1.2 =

Article ID: 890689

Article Last Modified on 9/7/2006

-

APPLIES TO


 * Microsoft Business Solutions CRM Integration for Great Plains, when used with:
 * Microsoft CRM 1.2
 * Microsoft CRM 1.2

-





SYMPTOMS
When you select many sales document types in the Published Order Types list of the Microsoft CRM Integration Settings and Administration tool, all the document types appear to be selected. However, if you run a Microsoft SQL Server query against the MSCRMIntegration database, only the first 16 document types appear in the returned results. Additionally, when you restart the Settings and Administration tool, only the first 16 document types are selected in the Published Order Types list.

This problem occurs after you integrate Microsoft Business Solutions–Great Plains with Microsoft Business Solutions CRM 1.2.



CAUSE
This problem occurs because the NodeValue column of the IntegrationSystemConfig table in the MSCRMIntegration database has an nvarchar value of 255. (An nvarchar value is also known as a variable-character value.) Therefore, only the first 16 sales documents are selected in the Published Order Types list when you configure document type selections. Additional document types that you select exceed the column length of the database table. Therefore, they do not appear.



WORKAROUND
To work around this problem, do not click to select the check boxes of the document types in the Published Order Types list of the Settings and Administration tool. When no document types are selected, the Sales and Integration tool pushes over all the document types. This behavior occurs because all the document types are returned with a value of TRUE when no document types are selected. To set the list so that no document types are selected, follow these steps:
 * 1) Click Start, point to All Programs, point to Microsoft CRM Integration, and then click Settings and Integration.
 * 2) In the left pane, click Great Plains, and then click the Sales Documents tab.
 * 3) In the Published Order Types list, click to clear the check boxes of all the items that appear under Document Type.
 * 4) Click the Save and Close button.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbbug kbprb kbpending kbmbsmigrate KB890689

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.