Hello User,
In Dynamics 365 On-Premise, the maximum value for a Currency field is governed by the database's underlying data type. Specifically, currency fields are stored as Money data types in SQL Server, which limits the maximum value to 922,337,203,685,477 (15 digits). This is a constraint that you cannot bypass directly within Dynamics 365 because it relies on the SQL Server limitations.
Workarounds:
If you need to store numbers larger than this, here are a few possible workarounds:
1. Use Multiple Fields (Scaling)
You can split the value across multiple fields and combine them programmatically when needed. For instance, you could store part of the value in one field and the remainder in another.
Alternatively, store the value in a scaled format (e.g., in millions or billions), and handle the conversion for display or reporting purposes.
2. Custom Field with Different Data Type
Instead of using a Currency field, consider using a Whole Number field or Decimal field, which can handle a larger range of numbers. However, this would mean losing the built-in currency formatting and conversion functionality of the Currency field.
3. Custom Plugin for Storing Larger Values
If you require more precision and control, you could write a custom plugin or workflow to store the number in a custom table or even use a text field for display purposes, while performing calculations using custom logic in the background.
4. Store in External System
For extremely large values that exceed the limitation, you might consider integrating with an external system (e.g., a financial system) where such large numbers are managed, and then simply display or link this information in Dynamics 365.
Thank you,
Amit katariya
