Answered by:
Number more than One Billion in CRM 2011?

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 VaibhavTuesday, November 15, 2011 12:23 PM
Answers
-
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 PMModerator
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 VaibhavTuesday, 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- 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 PMModerator