commit | b6cd3316c4e9c41bf05aa4557ea9b499120da9bc | [log] [tgz] |
---|---|---|
author | Nabin Hait <nabinhait@gmail.com> | Mon Mar 19 13:27:06 2012 +0530 |
committer | Nabin Hait <nabinhait@gmail.com> | Mon Mar 19 13:27:06 2012 +0530 |
tree | d5a96d1f28966cf8eba1c81eda3c865edd75ed3e | |
parent | f02c9e7b6c14210b6234663186f9e8b59464a5ae [diff] |
error fixed in lease receipts client wise
diff --git a/erpnext/accounts/search_criteria/lease_receipts_client_wise/lease_receipts_client_wise.sql b/erpnext/accounts/search_criteria/lease_receipts_client_wise/lease_receipts_client_wise.sql index f951388..af49c81 100644 --- a/erpnext/accounts/search_criteria/lease_receipts_client_wise/lease_receipts_client_wise.sql +++ b/erpnext/accounts/search_criteria/lease_receipts_client_wise/lease_receipts_client_wise.sql
@@ -1,5 +1,5 @@ SELECT gl.account,sum(gl.credit) as amount FROM `tabGL Entry` gl, `tabAccount` a -WHERE gl.account=a.name and a.master_type='Customer' and gl.posting_date between '%(date)s' and '%(date1)s' +WHERE gl.account=a.name and a.master_type='Customer' and gl.posting_date between '%(date)s' and '%(date1)s' and ifnull(gl.is_cancelled, 'No') = 'No' GROUP BY gl.account ORDER BY posting_date