| commit | 1ddfaa7605f710b2fd12ccdfa38824cd086f576d | [log] [tgz] |
|---|---|---|
| author | Gursheen Kaur Anand <40693548+GursheenK@users.noreply.github.com> | Mon Jul 31 14:29:20 2023 +0530 |
| committer | GitHub <noreply@github.com> | Mon Jul 31 14:29:20 2023 +0530 |
| tree | afae564196dbea98182044a5ce2f153b528574e4 | |
| parent | c6d8f15b10955abcdabd7cdc87a59c4cfb0f6713 [diff] |
fix: ignore cancelled gle in voucher-wise balance report (#36417) fix: ignore cancelled gle
diff --git a/erpnext/accounts/report/voucher_wise_balance/voucher_wise_balance.py b/erpnext/accounts/report/voucher_wise_balance/voucher_wise_balance.py index 5ab3611..bd9e9fc 100644 --- a/erpnext/accounts/report/voucher_wise_balance/voucher_wise_balance.py +++ b/erpnext/accounts/report/voucher_wise_balance/voucher_wise_balance.py
@@ -46,6 +46,7 @@ .select( gle.voucher_type, gle.voucher_no, Sum(gle.debit).as_("debit"), Sum(gle.credit).as_("credit") ) + .where(gle.is_cancelled == 0) .groupby(gle.voucher_no) ) query = apply_filters(query, filters, gle)