{"id":1802,"date":"2015-10-07T14:16:57","date_gmt":"2015-10-07T08:46:57","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=1802"},"modified":"2015-10-07T14:16:57","modified_gmt":"2015-10-07T08:46:57","slug":"tip-while-migrate-products-to-microsoft-dynamics-crm","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2015\/10\/tip-while-migrate-products-to-microsoft-dynamics-crm\/","title":{"rendered":"Tip while migrating Products to Microsoft Dynamics CRM"},"content":{"rendered":"<p><strong>Introduction<\/strong><\/p>\n<p>Most CRM Implementations involve data migration from <a href=\"http:\/\/inogic.com\/Product\/89\/Data-Conversion\/Microsoft-Dynamics-CRM-Legacy\" target=\"_blank\" rel=\"noopener noreferrer\">legacy system<\/a>. This article is a tip for smooth migration of Product data to Dynamics CRM.<\/p>\n<p><strong>Product Record mandatory fields <\/strong><\/p>\n<p>As you know that the when we create the product in CRM, we select the Unit Group and the Default Unit on Product.<\/p>\n<p>Unit group is a broader category of family under which multiple units can be defined. Unit names should be unique within the Unit Group but not across the system.<\/p>\n<p>In case of product, the business logic around this is, you can select Default Unit only after setting of the Unit Group and the Unit must belong to the Unit Group specified.<\/p>\n<p>We came across a case, where a particular Unit was named the same and available under multiple unit groups.<\/p>\n<p>For example, consider the following scenario,<\/p>\n<p>As you can see in the below screenshot that we have two units Groups \u00a0\u201cEnterprise User\u201d and \u201cBusiness User\u201d and both of these have the units with the same name i.e. \u201cYear\u201d.<\/p>\n<ul>\n<li>Unit Group: Enterprise User<a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2015\/10\/migration.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-1803\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2015\/10\/migration.png\" alt=\"migration\" width=\"629\" height=\"151\" \/><\/a><\/li>\n<\/ul>\n<ul>\n<li>Unit Group: Business User<a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2015\/10\/migration1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-1804\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2015\/10\/migration1.png\" alt=\"migration1\" width=\"629\" height=\"154\" \/><\/a><\/li>\n<\/ul>\n<p><strong>Data Migration Issue<\/strong><\/p>\n<p>During data migration especially for setting the values for the Lookup fields, the general logic followed is to look for the name provided within the entity set. This logic usually works across the CRM system for lookup fields but since there is this additional business logic that is being applied at the platform level for \u201cUnit\u201d where unit should be a part of \u201cUnit Group\u201d, it doesn\u2019t work with migrating \u201cUnits\u201d<\/p>\n<p>In case of Units, you need to provide the additional search criteria to match the name of the Unit as well as Unit Group to find the correct unit associated with the group.<\/p>\n<p>If you don\u2019t apply the additional search criteria for Unit Group, you could receive the following error while creating Product<\/p>\n<p><strong><em>\u201cThe unit does not exist in the specified unit schedule\u201d<\/em><\/strong><\/p>\n<p>Since the name appears correct, it is very difficult to understand the reason behind this error.<a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2015\/10\/migration2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-1805\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2015\/10\/migration2.png\" alt=\"migration2\" width=\"629\" height=\"194\" \/><\/a><\/p>\n<p>But actually only the names match not the GUIDS, so the unit set was perhaps of another unit group and not this one.<\/p>\n<p><strong>Conclusion: <\/strong><\/p>\n<p>If you want to migrate the products from one system to other, you need to make sure that the Units and Unit Groups names has to be unique in CRM i.e., Units in different Unit Groups cannot have same name.<\/p>\n<p>Get the most today..Monitor what your users are doing in Dynamics CRM. Try <a href=\"https:\/\/www.inogic.com\/blog\/2015\/09\/user-adoption-tracker-getting-the-most-from-your-dynamics-crm\/\" target=\"_blank\" rel=\"noopener noreferrer\">User Adoption Tracker<\/a>\u00a0today!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Most CRM Implementations involve data migration from legacy system. This article is a tip for smooth migration of Product data to Dynamics CRM. Product Record mandatory fields As you know that the when we create the product in CRM, we select the Unit Group and the Default Unit on Product. Unit group is a\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2015\/10\/tip-while-migrate-products-to-microsoft-dynamics-crm\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[19,31,57],"tags":[83,624,656,1120],"class_list":["post-1802","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-integrations-dynamics-crm","category-ssis","tag-act-data-conversion-dynamics-crm","tag-dynamics-crm-data-migration","tag-dynamics-crm-migration","tag-microsoft-dynamics-crm-data-migration"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/1802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=1802"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/1802\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=1802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=1802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=1802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}