commit 47605cae16f7ece9323e1006c8c655012f3e8b52
author rohitwaghchaure <rohitw1991@gmail.com> Mon Sep 11 16:47:16 2017 +0530
committer GitHub <noreply@github.com> Mon Sep 11 16:47:16 2017 +0530
tree 522bbb40dd799885b48eda230b4deb2320cdea68
parent e2149cb46faac4409415522a91495b9de1490598
parent f5cbb9c7b95118b5904b967f23ed600146ceef8d

Merge pull request #10737 from nabinhait/budget_variance_for_project

[fix] Actual amount for budget variance report

erpnext/accounts/report/budget_variance_report/budget_variance_report.py

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})