update modified date of JV through bank reconciliation
diff --git a/accounts/doctype/bank_reconciliation/bank_reconciliation.py b/accounts/doctype/bank_reconciliation/bank_reconciliation.py
index 8434f62..3ba477b 100644
--- a/accounts/doctype/bank_reconciliation/bank_reconciliation.py
+++ b/accounts/doctype/bank_reconciliation/bank_reconciliation.py
@@ -18,32 +18,32 @@
class DocType:
- def __init__(self, d, dl):
- self.doc, self.doclist = d, dl
+ def __init__(self, d, dl):
+ self.doc, self.doclist = d, dl
- def get_details(self):
- if not (self.doc.bank_account and self.doc.from_date and self.doc.to_date):
- msgprint("Bank Account, From Date and To Date are Mandatory")
- return
-
- dl = sql("select t1.name, t1.cheque_no, t1.cheque_date, t2.debit, t2.credit, t1.posting_date, t2.against_account from `tabJournal Voucher` t1, `tabJournal Voucher Detail` t2 where t2.parent = t1.name and t2.account = %s and (clearance_date is null or clearance_date = '0000-00-00' or clearance_date = '') and (t1.cheque_no is not null or t1.cheque_no != '') and t1.posting_date >= %s and t1.posting_date <= %s and t1.docstatus=1", (self.doc.bank_account, self.doc.from_date, self.doc.to_date))
-
- self.doc.clear_table(self.doclist, 'entries')
- self.doc.total_amount = 0.0
+ def get_details(self):
+ if not (self.doc.bank_account and self.doc.from_date and self.doc.to_date):
+ msgprint("Bank Account, From Date and To Date are Mandatory")
+ return
+
+ dl = sql("select t1.name, t1.cheque_no, t1.cheque_date, t2.debit, t2.credit, t1.posting_date, t2.against_account from `tabJournal Voucher` t1, `tabJournal Voucher Detail` t2 where t2.parent = t1.name and t2.account = %s and (clearance_date is null or clearance_date = '0000-00-00' or clearance_date = '') and (t1.cheque_no is not null or t1.cheque_no != '') and t1.posting_date >= %s and t1.posting_date <= %s and t1.docstatus=1", (self.doc.bank_account, self.doc.from_date, self.doc.to_date))
+
+ self.doc.clear_table(self.doclist, 'entries')
+ self.doc.total_amount = 0.0
- for d in dl:
- nl = addchild(self.doc, 'entries', 'Bank Reconciliation Detail', 1, self.doclist)
- nl.posting_date = str(d[5])
- nl.voucher_id = str(d[0])
- nl.cheque_number = str(d[1])
- nl.cheque_date = str(d[2])
- nl.debit = flt(d[3])
- nl.credit = flt(d[4])
- nl.against_account = d[6]
- self.doc.total_amount += flt(flt(d[4]) - flt(d[3]))
+ for d in dl:
+ nl = addchild(self.doc, 'entries', 'Bank Reconciliation Detail', 1, self.doclist)
+ nl.posting_date = str(d[5])
+ nl.voucher_id = str(d[0])
+ nl.cheque_number = str(d[1])
+ nl.cheque_date = str(d[2])
+ nl.debit = flt(d[3])
+ nl.credit = flt(d[4])
+ nl.against_account = d[6]
+ self.doc.total_amount += flt(flt(d[4]) - flt(d[3]))
- def update_details(self):
- for d in getlist(self.doclist, 'entries'):
- if d.clearance_date:
- sql("update `tabJournal Voucher` set clearance_date = %s where name=%s", (d.clearance_date, d.voucher_id))
- msgprint("Updated")
\ No newline at end of file
+ def update_details(self):
+ for d in getlist(self.doclist, 'entries'):
+ if d.clearance_date:
+ sql("update `tabJournal Voucher` set clearance_date = %s, modified = %s where name=%s", (d.clearance_date, nowdate(), d.voucher_id))
+ msgprint("Updated")