An error “The number of decimal places on the quantity is invalid” while migrating quote product through SSIS

By | April 22, 2016

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.

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.

For example, we were getting an error “The number of decimal places on the quantity is invalid” while migrating the Quote Details entity data.

Consider the quote and its quote product below.

Quote in Source CRM:

quote in source crm

Quote Product in Source CRM:

Quote Product in Source CRM

As you can see in the above screenshot that the Quantity for this quote details is “9.54450”.

To investigate the cause of the error we checked the precisions allowed for the field “Quantity” of the Quote Detail in the destination CRM. And we found that the precision was “5” and this was correct as the Quantity for the Quote Product in Source CRM has the value with precision as “5”.

Field Quantity of the Quote Product in Destination CRM:

Field Quantity of the Quote Product in Destination CRM

So after further investigating into this, we found that the cause of the issue was “Decimals Supported” of the Product which was used in this Quote Detail.

The “Decimals Supported” for the Product “CRM Online Enterprise” was “2” and the Quantity for the Quote Details was having the value as “9.54450” which has the precisions as “5”.

Product in Destination CRM:

Product in Destination CRM

Since the precisions for the Quantity value for the Quote Product was greater than the “Decimals Supported” of the Product, it was giving an error “The number of decimal places on the quantity is invalid” while migrating this Quote Detail and did not allow to create this Quote Detail in the destination CRM.

So we changed the “Decimal Supported” of the Product “CRM Online Enterprise” from “2” to “5” and then migrated the same Quote Details again and this time the quote detail migrated successfully to the destination CRM.

Product in Destination CRM:

Product in Destination CRM

Migrating Quote Detail using SSIS:

Migrating Quote Detail using SSIS

Quote Product migrated to Destination CRM:

Migrating Quote Detail using SSIS

Quote Product in Destination CRM:

Quote Product in Destination CRM

Conclusion:

While migrating or importing the data of the entities Quote Products, Invoice Products, Order Products and Opportunity Products make sure that the “Decimals Supported” of the Product is appropriate so that it can match the Quantity’s precision in the Quote Products or Invoice Products or Opportunity Products.

You may like to check > Maplytics – Dynamics CRM Bing Maps Integration tool.