Change column length of in_words
diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index e52ce5e..3796c82 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -400,3 +400,4 @@
erpnext.patches.v8_0.update_customer_pos_id
erpnext.patches.v8_0.rename_items_in_status_field_of_material_request
erpnext.patches.v8_0.delete_bin_indexes
+erpnext.patches.v8_0.change_in_words_varchar_length
\ No newline at end of file
diff --git a/erpnext/patches/v8_0/change_in_words_varchar_length.py b/erpnext/patches/v8_0/change_in_words_varchar_length.py
new file mode 100644
index 0000000..0e5891e
--- /dev/null
+++ b/erpnext/patches/v8_0/change_in_words_varchar_length.py
@@ -0,0 +1,16 @@
+# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors
+# License: GNU General Public License v3. See license.txt
+
+from __future__ import unicode_literals
+import frappe
+
+def execute():
+ doctypes = frappe.db.sql_list(""""select parent from tabDocField where fieldname = 'in_words'""")
+
+ for dt in doctypes:
+ for fieldname in ("in_words", "base_in_words"):
+ frappe.db.sql("alter table `tab{0}` change column `{1}` `{2}` varchar(255)"
+ .format(dt, fieldname, fieldname))
+
+ frappe.db.sql("""alter table `tabJournal Entry`
+ change column `total_amount_in_words` `total_amount_in_words` varchar(255)""")
\ No newline at end of file