patch for resetting payment reconciliation values
diff --git a/patches/february_2013/payment_reconciliation_reset_values.py b/patches/february_2013/payment_reconciliation_reset_values.py
new file mode 100644
index 0000000..cdb213a
--- /dev/null
+++ b/patches/february_2013/payment_reconciliation_reset_values.py
@@ -0,0 +1,7 @@
+def execute():
+ import webnotes
+ webnotes.conn.sql("""update `tabSingles` set value = ''
+ where doctype = 'Payment to Invoice Matching Tool'
+ and field in ('account', 'voucher_no', 'total_amount', 'pending_amt_to_reconcile',
+ 'from_date', 'to_date', 'amt_greater_than', 'amt_less_than')""")
+
\ No newline at end of file
diff --git a/patches/patch_list.py b/patches/patch_list.py
index 95fe806..f4b0127 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -162,4 +162,5 @@
"patches.january_2013.tabsessions_to_myisam",
"patches.february_2013.remove_gl_mapper",
"patches.february_2013.reload_bom_replace_tool_permission",
+ "patches.february_2013.payment_reconciliation_reset_values",
]
\ No newline at end of file