Number more than One Billion in CRM 2011?

All replies

• 

  

  1

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  Thanks Luke,

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

  ---

  Thanks Vaibhav

  Tuesday, November 15, 2011 2:28 PM
• 

  

  1

  Sign in to vote

  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
• 

  

  1

  Sign in to vote

  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
  

  • Edited by DavidJennawayMVP, Moderator Tuesday, November 15, 2011 9:23 PM
  • Proposed as answer by Philippe LEAL Wednesday, November 16, 2011 8:19 AM
  • Marked as answer by DavidJennawayMVP, Moderator Friday, December 2, 2011 6:03 PM

  Tuesday, November 15, 2011 9:21 PM

  Moderator