{"id":2675,"date":"2016-04-22T16:27:13","date_gmt":"2016-04-22T10:57:13","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=2675"},"modified":"2016-04-22T16:27:13","modified_gmt":"2016-04-22T10:57:13","slug":"an-error-the-number-of-decimal-places-on-the-quantity-is-invalid-while-migrating-quote-product-through-ssis","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2016\/04\/an-error-the-number-of-decimal-places-on-the-quantity-is-invalid-while-migrating-quote-product-through-ssis\/","title":{"rendered":"An error \u201cThe number of decimal places on the quantity is invalid\u201d while migrating quote product through SSIS"},"content":{"rendered":"<p><b>Introduction: <\/b><\/p>\n<p style=\"text-align: justify;\">While migrating or creating the records for the Products and hence the Quote Products, Invoice Products, Order Products and Opportunity Products, we have to ensure the number of things as this would not allow us to create or migrate the data successfully in the CRM.<\/p>\n<p style=\"text-align: justify;\">For example, Price List, Unit and Unit Group etc.<\/p>\n<p style=\"text-align: justify;\">But there could be some things that we might have ignored and which could cause the error while migration and hence not processing the data successfully.<\/p>\n<p style=\"text-align: justify;\">For example, we were getting an error \u201cThe number of decimal places on the quantity is invalid\u201d while migrating the Quote Details entity data.<\/p>\n<p style=\"text-align: justify;\">Consider the quote and its quote product below.<\/p>\n<p><b><span style=\"text-decoration: underline;\">Quote in Source CRM:<\/span><\/b><\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image0021.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"clip_image002\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image002_thumb1.jpg\" alt=\"quote in source crm\" width=\"629\" height=\"254\" border=\"0\" \/><\/a><\/p>\n<p><b><span style=\"text-decoration: underline;\">Quote Product in Source CRM:<\/span><\/b><\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image0041.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"clip_image004\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image004_thumb1.jpg\" alt=\"Quote Product in Source CRM\" width=\"629\" height=\"206\" border=\"0\" \/><\/a><\/p>\n<p>As you can see in the above screenshot that the Quantity for this quote details is \u201c<b>9.54450<\/b>\u201d.<\/p>\n<p>To investigate the cause of the error we checked the precisions allowed for the field \u201c<b>Quantity<\/b>\u201d of the Quote Detail in the destination CRM. And we found that the precision was \u201c5\u201d and this was correct as the Quantity for the Quote Product in Source CRM has the value with precision as \u201c<b>5<\/b>\u201d.<\/p>\n<p><b><span style=\"text-decoration: underline;\">Field Quantity of the Quote Product in Destination CRM:<\/span><\/b><\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image0061.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"clip_image006\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image006_thumb1.jpg\" alt=\"Field Quantity of the Quote Product in Destination CRM\" width=\"630\" height=\"263\" border=\"0\" \/><\/a><\/p>\n<p>So after further investigating into this, we found that the cause of the issue was \u201c<b>Decimals Supported<\/b>\u201d of the Product which was used in this Quote Detail.<\/p>\n<p>The \u201cDecimals Supported\u201d for the Product \u201cCRM Online Enterprise\u201d was \u201c2\u201d and the Quantity for the Quote Details was having the value as \u201c<b>9.54450<\/b>\u201d which has the precisions as \u201c5\u201d.<\/p>\n<p><b><span style=\"text-decoration: underline;\">Product in Destination CRM:<\/span><\/b><\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image0081.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"clip_image008\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image008_thumb1.jpg\" alt=\"Product in Destination CRM\" width=\"629\" height=\"199\" border=\"0\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Since the precisions for the Quantity value for the Quote Product was greater than the \u201cDecimals Supported\u201d of the Product, it was giving an error \u201cThe number of decimal places on the quantity is invalid\u201d while migrating this Quote Detail and did not allow to create this Quote Detail in the destination CRM.<\/p>\n<p style=\"text-align: justify;\">So we changed the \u201cDecimal Supported\u201d of the Product \u201cCRM Online Enterprise\u201d from \u201c2\u201d to \u201c5\u201d and then migrated the same Quote Details again and this time the quote detail migrated successfully to the destination CRM.<\/p>\n<p><b><span style=\"text-decoration: underline;\">Product in Destination CRM:<\/span><\/b><\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image0101.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"clip_image010\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image010_thumb1.jpg\" alt=\"Product in Destination CRM\" width=\"629\" height=\"191\" border=\"0\" \/><\/a><\/p>\n<p><b><span style=\"text-decoration: underline;\">Migrating Quote Detail using SSIS:<\/span><\/b><\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image0121.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"clip_image012\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image012_thumb1.jpg\" alt=\"Migrating Quote Detail using SSIS\" width=\"629\" height=\"259\" border=\"0\" \/><\/a><\/p>\n<p><b><span style=\"text-decoration: underline;\">Quote Product migrated to Destination CRM:<\/span><\/b><\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image0141.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"clip_image014\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image014_thumb1.jpg\" alt=\"Migrating Quote Detail using SSIS\" width=\"629\" height=\"259\" border=\"0\" \/><\/a><\/p>\n<p><b><span style=\"text-decoration: underline;\">Quote Product in Destination CRM:<\/span><\/b><\/p>\n<p><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image0161.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"clip_image016\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2016\/04\/clip_image016_thumb1.jpg\" alt=\"Quote Product in Destination CRM\" width=\"630\" height=\"235\" border=\"0\" \/><\/a><\/p>\n<p><b>Conclusion<\/b>:<\/p>\n<p style=\"text-align: justify;\">While migrating or importing the data of the entities Quote Products, Invoice Products, Order Products and Opportunity Products make sure that the \u201cDecimals Supported\u201d of the Product is appropriate so that it can match the Quantity\u2019s precision in the Quote Products or Invoice Products or Opportunity Products.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #993300;\"><em>You may like to check &gt; Maplytics &#8211; <a href=\"http:\/\/inogic.com\/product\/integrations\/maplytics-bing-map-microsoft-dynamics-crm\" target=\"_blank\" rel=\"noopener noreferrer\">Dynamics CRM Bing Maps Integration<\/a> tool.<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: While migrating or creating the records for the Products and hence the Quote Products, Invoice Products, Order Products and Opportunity Products, we have to ensure the number of things as this would not allow us to create or migrate the data successfully in the CRM. For example, Price List, Unit and Unit Group etc.\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2016\/04\/an-error-the-number-of-decimal-places-on-the-quantity-is-invalid-while-migrating-quote-product-through-ssis\/\">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,24,57],"tags":[664,1136,1175,1210,1389],"class_list":["post-2675","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-dynamics-crm-2016","category-ssis","tag-dynamics-crm-online-enterprise","tag-microsoft-dynamics-crm-online-migration","tag-migrate-data-using-ssis","tag-ms-crm-data-migration-support","tag-quantity-decimals-error"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/2675","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=2675"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/2675\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=2675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=2675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=2675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}