Patch to update idx.. start idx from 1
diff --git a/erpnext/patches/update_0_idx.py b/erpnext/patches/update_0_idx.py
new file mode 100644
index 0000000..9c31f1d
--- /dev/null
+++ b/erpnext/patches/update_0_idx.py
@@ -0,0 +1,9 @@
+import webnotes
+def execute():
+ doc_type_list = webnotes.conn.sql("""SELECT DISTINCT parent FROM `tabDocField` where idx=0""")
+ for doc_type in doc_type_list:
+ if doc_type and doc_type[0]:
+ webnotes.conn.sql("""\
+ UPDATE `tabDocField` SET idx=idx+1
+ WHERE parent=%s
+ """, doc_type[0])