• You create a sales order.
• Then, you create an order product for the sales order.
• Finally, you click the lookup button next to the Great Plains Site field in the Order Product form.

• The Microsoft Dynamics CRM Connector for Microsoft Dynamics GP is installed.
• You create more than two custom entities before you install the Microsoft Dynamics CRM Connector.

Back to the top

1. Make sure that you have complete backup copies of the following databases:
   • The OrganizationName_MSCRM database
   • The OrganizationName_METABASE database
   For more information about how to back up the databases, view "Chapter 26: Backing Up Your Microsoft CRM System" in the Microsoft CRM 3.0 Implementation Guide. To obtain the Microsoft CRM 3.0 Implementation Guide, visit the following Microsoft Web site:
   http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff067f8-4f77-40f0-ae9c-68ada7d4f16a&DisplayLang=en (http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff067f8-4f77-40f0-ae9c-68ada7d4f16a&DisplayLang=en)
2. Determine what ObjectTypeCode value is associated with the New_BOProductSite custom entity. To do this, run the following script against the OrganizationName_METABASE database.
   
   Note Run this script by using SQL Query Analyzer or by using SQL Server Management Studio.

   USE <OrganizationName>_METABASE 
   GO
   SELECT Name,PhysicalName,LogicalName, ObjectTypeCode 
   FROM Entity
   WHERE ObjectTypeCode >= 10000
   AND Name = 'New_BOProductSite'
   ORDER BY ObjectTypeCode

   Note In this script, <OrganizationName> is a placeholder that represents the actual organization name.
3. If the ObjectTypeCode value for the New_BOProductSite custom entity is not equal to 10001, note the ObjectTypeCode value that is returned after you run the query.
4. Log on to the Microsoft Dynamics CRM 3.0 Web site as a user who has the Microsoft Dynamics CRM administrator role.
5. Click Settings, click Customizations, and then click Export Customizations.
6. Click Export All Customizations, and then save the file as the All_MSCRM_Customizations.xml file.
   
   Note This step is used to back up all custom attributes and all custom entities.
7. Click an entity whose schema name is salesorderdetail.
   
   Note By default, the Order Product entity has this schema name. However, the entity can be renamed.
8. On the More Actions menu, click Export Selected Customizations.
9. Click OK, and then save the file as the SalesOrderDetail_Original.xml file.
10. Make a copy of the SalesOrderDetail_Original.xml file, and then rename the copied file as SalesOrderDetail_Fixed.xml.
11. Use WordPad to open the SalesOrderDetail_Fixed.xml file.
12. In WordPad, click Replace on the Edit menu.
13. In the Replace dialog box, type 10001 in the Find what field, type the ObjectTypeCode value that you noted in step 3 in the Replace with field, and then click Replace All.
14. Save the SalesOrderDetail_Fixed.xml file.
    
    Note Make sure that the file type is Text Document.
15. Click Settings, click Customizations, and then click Import Customizations.
16. Click Browse next to the Import File field, click the SalesOrderDetail_Fixed.xml file, and then click Open.
17. Click Upload. The Order Product entity appears in the Import Customizations form.
18. Click Import All Customizations.
19. After the Order Product entity customization is imported, click OK.
20. Click Customization, and then click Customize Entities.
21. On the More Actions menu, click Publish All Customizations.
22. Click Start, click Run, type iisreset, and then click OK.
23. Delete temporary Internet files. To do this, follow these steps:
    1. Start Internet Explorer.
    2. Click Tools, and then click Internet Options.
    3. Use one of the following methods, depending on which version of Internet Explorer you are using:
       • In Windows Internet Explorer 7, click Delete in the Browsing history area, click Delete files in the Temporary Internet Files area, and then click Yes.
       • In Microsoft Internet Explorer 6, click Delete Files in the Temporary Internet files area, and then click OK.
    Note To correctly use the Great Plains Site field, you must create a Great Plains site, and you must associate the Great Plains site with the item that is integrated as the Microsoft Dynamics CRM 3.0 product.

Back to the top

Steps to reproduce the problem

1. Create more than two custom entities.
2. Install the Microsoft Dynamics CRM Connector.
3. On the New menu, click Order.
4. In the Name field, type an order name.
5. Click the lookup button next to the Customer field, click a customer, and then click OK.
6. Click the lookup button next to the Price List field, click a price list, and then click OK.
7. Click Save.
8. Click Existing Products, and then click New Order Product.
9. Click the lookup button next to the Product field, click a product, and then click OK.
10. Click the lookup button next to the Unit field, click a unit, and then click OK.
11. Click the lookup button next to the Great Plains Site field.

<ImportExportXml version="3.0.5300.0">
  <Entities>
    <Entity>
      <Name LocalizedName="Order Product" OriginalName="Order Product">SalesOrderDetail</Name>
      <ObjectTypeCode>1089</ObjectTypeCode>
      <LocalizedName>Order Product</LocalizedName>
      <LocalizedCollectionName>Order Products</LocalizedCollectionName>
…
var aSiteLookups=window.document.forms['crmForm'].elements['productid'].DataValue;
	if(aSiteLookups && aSiteLookups.length > 0)
	{ 
		if(IsOutlookLaptopClient())
			{
				var lookupItem = openStdDlg("/_controls/lookup/lookupsingle.aspx?class=null&objecttypes=10005&browse=0&DefaultType=0",null,"600px","488px",true,null,null);
				if(lookupItem && lookupItem.items.length > 0)
					{
						var lookupfield = crmForm.new_boproductsiteid.parentElement.parentElement.firstChild.firstChild;
						var lookup = event.srcElement;
						lookup.Clear();
						lookup.AddItems(lookupItem.items);
					}
													
													
	        }
		else
			{
				var productid = aSiteLookups[0].id;
				var url = '\\Integration\\LookupSite.aspx?productid='+productid+'&objecttypes=10005';											
				var lookupItem=window.showModalDialog(url);
				if(lookupItem && lookupItem.items.length > 0)
					{
						var lookupfield = crmForm.new_boproductsiteid.parentElement.parentElement.firstChild.firstChild;
						var lookup = event.srcElement;
						lookup.Clear();
						lookup.AddItems(lookupItem.items);
						//				BuildField(lookupfield, lookupItem); 
					}
													
			}
	}
…

Back to the top