Microsoft Knowledge Base Email Alertz

(933518) - Describes a problem that occurs because the value in the Address Name field in Microsoft Dynamics CRM can be modified. But the value in the Address ID field in Microsoft Dynamics GP cannot be modified. A workaround is provided.

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]





ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
KBAlertz referrals get
** SIX MONTHS FREE **


Community Site



We Send hundreds of thousands of emails using ASP.NET Email


ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
KBAlertz referrals get
** SIX MONTHS FREE **




Mentioned In








Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks




Article ID: 933518 - Last Review: August 21, 2007 - Revision: 1.1

The value in the "Address Name" field for an account in Microsoft Dynamics CRM 3.0 may differ from the value in the "Address ID" field for the account in Microsoft Dynamics GP

On This Page

SYMPTOMS

The value in the Address Name field for an account in Microsoft Dynamics CRM may differ from the value in the Address ID field for the account in Microsoft Dynamics GP. This problem occurs after you use Microsoft Dynamics CRM Connector for Microsoft Dynamics GP to integrate a customer account in Microsoft Dynamics CRM 3.0 with a customer account in Microsoft Dynamics GP.

CAUSE

This problem occurs because the value in the Address Name field in Microsoft Dynamics CRM can be modified. However, the value in the Address ID field in Microsoft Dynamics GP cannot be modified. Therefore, the fields may be different if you update the Address Name field in Microsoft Dynamics CRM.

WORKAROUND

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

To work around this problem, disable the ability to edit the following fields in Microsoft Dynamics CRM 3.0:
  • The Address1: Name field in the Account entity
  • The Address2: Name field in the Account entity
  • The Address1: Name field in the Address entity
  • The Address2: Name field in the Address entity
  • The Address Name field in the Address entity.
To do this, use one of the following methods.

Method 1

Note Use this method if you want to use the Microsoft Dynamics CRM Software Development Kit (SDK) applications to update the values in these fields. Also, use this method if you want to use the Microsoft Dynamics CRM SDK callouts to update the values in these fields.

Note These steps describe how to disable the ability to edit the following fields:
  • The Address1: Name field in the Account entity
  • The Address2: Name field in the Account entity
  • The Address1: Name field in the Address entity
  • The Address2: Name field in the Address entity
However, you can also follow these steps to disable the fields for the Contact entity.
  1. Back up the OrganizationName_MSCRM database and the OrganizationName_METABASE database.

    For more information about the backup procedure, see Chapter 26, "Backing up your Microsoft CRM System," in the Microsoft CRM 3.0 Implementation Guide. To download 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. Log on to the Microsoft Dynamics CRM 3.0 Web client as a user who has a System Administrator role or as a user who has a System Customizer role.
  3. On the Go To menu, point to Settings, and then click Customization.
  4. Click Customize Entities.
  5. Customize the Account entity.
    1. Double-click the Account entity.
    2. On the "Entity: Account" page, click Forms and Views, and then double-click Form.
    3. On the "Form: Account" page, click Form Properties under Common Tasks.
    4. In the Form Properties dialog box, click Onload under Event List, and then click Edit.
    5. In the Event Detail Properties dialog box, click to select the Event is enabled check box, copy the following script, and then paste the script in the script box.
      var CRM_FORM_TYPE_UPDATE = "2";
      if (crmForm.FormType == CRM_FORM_TYPE_UPDATE)
      {
      // Disable the name attribute.
      crmForm.all.address1_name.Disabled=true;
      }
    6. Click OK two times.
    7. On the "Form: Account" page, click Save and Close.
    8. On the "Entity: Account" page, click Save and Close.
  6. Customize the Address entity.
    1. Double-click the Address entity.
    2. On the "Entity: Address" page, click Forms and Views, and then double-click Form.
    3. On the "Form: Address" page, click Form Properties under Common Tasks.
    4. In the Form Properties dialog box, click Onload under Event List, and then click Edit.
    5. In the Event Detail Properties dialog box, click to select the Event is enabled check box, copy the following script, and then paste the script in the script box.
      var CRM_FORM_TYPE_UPDATE = "2";
      if (crmForm.FormType == CRM_FORM_TYPE_UPDATE)
      {
      // Disable the name attribute.
      crmForm.all.name.Disabled=true;
      }
    6. Click OK two times.
    7. On the "Form: Address" page, click Save and Close.
    8. On the "Entity: Address" page, click Save and Close.
  7. Select the Account entity and the Address entity, and then click Publish.

Method 2

Note Use this method if you want to prevent the Microsoft Dynamics CRM SDK applications from updating the values in these fields. Also, use this method if you want to prevent the Microsoft Dynamics CRM callouts from updating the values in these fields.

To obtain the steps for this method, contact Microsoft Customer Support Services. For a complete list of Microsoft Customer Support Services telephone numbers, and for information about support costs, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to reproduce the problem

  1. Log on to Microsoft Dynamics GP 9.0.
  2. On the Cards menu, point to Sales, and then click Customer.
  3. In the Customer Maintenance window, click the lookup button next to the Customer ID field, click a customer account that has been integrated to Microsoft Dynamics CRM 3.0, and then click Select.
  4. Note the value in the Address ID field.
  5. Click Address.
  6. In the Customer Address Maintenance window, note the value in the Address ID field.
  7. Log on to Microsoft Dynamics CRM 3.0.
  8. On the Go To menu, point to Sales, and then click Accounts.
  9. Double-click the integrated account that you selected in step 3 earlier in this section.
  10. Note the value in the Address Name field. This value differs from the value that you noticed in step 4 earlier in this section.
  11. Click More Addresses. The value in the Address Name field differs from the value that you noted in step 6 earlier in this section.

APPLIES TO
  • Microsoft Dynamics CRM 3.0
  • Microsoft Dynamics CRM Connector for Microsoft Dynamics GP, when used with:
    • Microsoft Dynamics CRM 3.0
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
Keywords: 
kbtshoot kbbug kbmbsmigrate KB933518
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate