Increase Currency Field Limit

michaeldvr · September 6, 2019, 12:56am

Hello,

I’d like to ask if it is possible to increase currency field limit. On MySQL side it is defined as DECIMAL(18,6) but currently it is not enough for our use case. Is there any configuration or API that can be used to alter all currency columns to larger decimal size?

Thank you.

michaeldvr · September 6, 2019, 1:27am

I’m on branch v10 and found Currency field definition:

github.com

frappe/frappe/blob/v10.x.x/frappe/model/db_schema.py#L27


      
          # imports - third-party imports
          import pymysql
          from pymysql.constants import ER
          
          
class InvalidColumnName(frappe.ValidationError): pass
          
          
varchar_len = '140'
          standard_varchar_columns = ('name', 'owner', 'modified_by', 'parent', 'parentfield', 'parenttype')
          
          
type_map = {
          	'Currency':		('decimal', '18,6'),
          	'Int':			('int', '11'),
          	'Long Int':		('bigint', '20'), # convert int to bigint if length is more than 11
          	'Float':		('decimal', '18,6'),
          	'Percent':		('decimal', '18,6'),
          	'Check':		('int', '1'),
          	'Small Text':		('text', ''),
          	'Long Text':		('longtext', ''),
          	'Code':			('longtext', ''),
          	'Text Editor':		('longtext', ''),
          	'Date':			('date', ''),

If I change its value, how to apply to database?

Thank you

Toan_V_ng_Khanh · January 23, 2021, 1:35am

I’m on the same issue.
Any help, many thanks