Number more than One Billion in CRM 2011? RRS feed

  • Question

  • Guys,

    We are working on a mathematical product based on CRM 2011 and we have this requirement to support number greater than One Billion (e.g 100 Billion)which is the limit of Whole Number/ Float and Decimal in CRM 2011.

    Any Ideas on how to go about it?

    Thanks Vaibhav
    Tuesday, November 15, 2011 12:23 PM


All replies

  • If you go to customization and customize a field you can raise the maximum value to 100,000,000,000.00 and lower the minimum to -100,000,000,000.00. Unfortunately, there is no supported way to increase the limits any further than this.

    • Proposed as answer by Philippe LEAL Wednesday, November 16, 2011 8:19 AM
    Tuesday, November 15, 2011 2:05 PM
  • Thanks Luke,

    What are the options for doing it unsupported way? Can you suggest something?

    Thanks Vaibhav
    Tuesday, November 15, 2011 2:28 PM
  • In the MetadataSchema.Attribute table there is a MaxValue column which is where the CRM maximum value is stored. You could try editing this value directly in SQL to force a larger maximum than the platform allows you to set.

    This is definitely unsupported and I've never tried it - I don't know whether it will work or what kind of problems you might cause.

    Tuesday, November 15, 2011 5:53 PM
  • Another option would be to store the data in a string data-type. This adds overhead in that you should validate the input, and you'd have to convert the value to do calculations, but at least it is a supported way to do this
    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Tuesday, November 15, 2011 9:21 PM