Pages

Monday, August 22, 2011

Changing Product Unit Groups

I ran into a situation where a large list of Products had been imported into CRM 2011, but the Unit Groups for many of them needed to be changed after the fact.  As many have discovered, even though the form customization options for the Product entity professes that the field is not flagged as “read only”, the field is in fact “read only” when Products are opened.

The workaround is fairly simple, but comes with some caveats:  export the records to an Excel spreadsheet with the option “Make this available for re-importing by including required column headings” selected.  You must export both the Unit Group field and the Default Unit field.  In spreadsheet form, you can alter the Unit Group and the Default Unit.  Now, here’s the caveats:

  1. The Default Unit must be uniquely named.  Multiple Units with identical names (in any Unit Group) will cause the import to fail, because it does not look for the Unit in a specific Unit Group.  The failure is because CRM cannot properly resolve the Unit, due to name duplication.
  2. Beware of any Price List Items configured to use the old Units configured for this Product.  I don’t know what CRM will do to you if you try to use the Product in a Quote/Order/Invoice after you change its Unit Group in this way.

When you import the changed data, you should notice that the modifications to the Unit Group (and Default Unit) values have been properly changed.

[Update:  Astute reader, Jevgenij, notes that the following Microsoft KB will also allow you to work around the problem using the Bulk Edit feature: http://support.microsoft.com/kb/949941  This is particularly useful for CRM administrators.  The process above, however, will work for anyone with access Product catalog maintenance.]

4 comments:

  1. Hi,

    You can check this article.
    http://support.microsoft.com/kb/949941
    Not sure if it applies to version 2011

    ReplyDelete
  2. Jevgenij,

    Can you explain how this perhaps pertains to my post? If you meant to imply that Bulk Edit would work to change the Unit Group, I can state that my testing suggests otherwise. It's also not a matter of "OnChange" code, as this is the behavior I've identified about CRM 2011 out-of-the-box with no customization.

    ReplyDelete
  3. Hello, Dave.
    My idea was that using Bulk Edit mode is more easier and less time consuming.
    I have just tested solution mentioned in KB on CRM 2011, and it seems to allow changing Unit Group (and Default Unit) in Bulk Edit mode.
    Actually, the field is disabled in Bulk Edit mode, since out-of-the-box script exists in the OnChange event.
    Just sharing.

    Regards!

    ReplyDelete
  4. Oh, now I get it. I think that would also serve as a workaround to the problem. Thanks for the recommendation!

    ReplyDelete

Unrelated comments to posts may be summarily disposed at the author's discretion.