| commit | f5cbb9c7b95118b5904b967f23ed600146ceef8d | [log] [tgz] |
|---|---|---|
| author | Nabin Hait <nabinhait@gmail.com> | Mon Sep 11 13:58:15 2017 +0530 |
| committer | Nabin Hait <nabinhait@gmail.com> | Mon Sep 11 13:58:15 2017 +0530 |
| tree | 36abb3617d874905c7caca0c669985985c0a77ad | |
| parent | b9d158076ee3f070f6ed6b1280a9ac9dc246640d [diff] |
[fix] Actual amount for budget variance report
diff --git a/erpnext/accounts/report/budget_variance_report/budget_variance_report.py b/erpnext/accounts/report/budget_variance_report/budget_variance_report.py index 875ec99..bc457aa 100644 --- a/erpnext/accounts/report/budget_variance_report/budget_variance_report.py +++ b/erpnext/accounts/report/budget_variance_report/budget_variance_report.py
@@ -99,7 +99,8 @@ where b.name = ba.parent and b.docstatus = 1 - and ba.account=gl.account + and ba.account=gl.account + and b.{budget_against} = gl.{budget_against} and gl.fiscal_year=%s and b.{budget_against}=%s and exists(select name from `tab{tab}` where name=gl.{budget_against} and {cond})