[patch] Fix affected Journal Entries due to reconciliation
diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index 5346a85..fe930c4 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -212,4 +212,5 @@
erpnext.patches.v5_8.tax_rule
erpnext.patches.v6_3.convert_applicable_territory
erpnext.patches.v6_4.round_status_updater_percentages
-erpnext.patches.v6_4.repost_gle_for_journal_entries_where_reference_name_missing
\ No newline at end of file
+erpnext.patches.v6_4.repost_gle_for_journal_entries_where_reference_name_missing
+erpnext.patches.v6_4.fix_journal_entries_due_to_reconciliation
\ No newline at end of file
diff --git a/erpnext/patches/v6_4/fix_journal_entries_due_to_reconciliation.py b/erpnext/patches/v6_4/fix_journal_entries_due_to_reconciliation.py
new file mode 100644
index 0000000..37b6c63
--- /dev/null
+++ b/erpnext/patches/v6_4/fix_journal_entries_due_to_reconciliation.py
@@ -0,0 +1,50 @@
+# 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():
+ je_rows = frappe.db.sql("""
+ select name, parent, reference_type, reference_name, debit, credit
+ from `tabJournal Entry Account`
+ where docstatus=1 and date(modified) >= '2015-09-17'
+ and ((ifnull(debit_in_account_currency, 0)*exchange_rate != ifnull(debit, 0))
+ or (ifnull(credit_in_account_currency, 0)*exchange_rate != ifnull(credit, 0)))
+ order by parent
+ """, as_dict=True)
+
+ journal_entries = []
+
+ for d in je_rows:
+ if d.parent not in journal_entries:
+ journal_entries.append(d.parent)
+
+ is_advance_entry=None
+ if d.reference_type in ("Sales Invoice", "Purchase Invoice") and d.reference_name:
+ is_advance_entry = frappe.db.sql("""select name from `tab{0}`
+ where journal_entry=%s and jv_detail_no=%s
+ and ifnull(allocated_amount, 0) > 0 and docstatus=1"""
+ .format(d.reference_type + " Advance"), (d.parent, d.name))
+
+ if is_advance_entry or not (d.debit or d.credit):
+ frappe.db.sql("""
+ update `tabJournal Entry Account`
+ set debit=debit_in_account_currency*exchange_rate,
+ credit=credit_in_account_currency*exchange_rate
+ where name=%s""", d.name)
+ else:
+ frappe.db.sql("""
+ update `tabJournal Entry Account`
+ set debit_in_account_currency=debit/exchange_rate,
+ credit_in_account_currency=credit/exchange_rate
+ where name=%s""", d.name)
+
+ for d in journal_entries:
+ print d
+ # delete existing gle
+ frappe.db.sql("delete from `tabGL Entry` where voucher_type='Journal Entry' and voucher_no=%s", d)
+
+ # repost gl entries
+ je = frappe.get_doc("Journal Entry", d)
+ je.make_gl_entries()
\ No newline at end of file