commit ac199580af30b82bbb5dd77a5c25b4483b4536bb
author Himanshu <himanshuwarekar@yahoo.com> Mon Mar 18 15:44:54 2019 +0530
committer Faris Ansari <netchampfaris@users.noreply.github.com> Mon Mar 18 15:44:54 2019 +0530
tree 259579ec280ce43426893ab3301487e1836d2af6
parent 4c8627e88df793b2bab2c5bf08c448b6a0e4d57c

fix(Customer Ledger): ambiguous error in where clause (#16914)

fix for error "InternalError: (1052, u"Column 'company' in where clause is ambiguous")" in Customer Ledger Summary

erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py

diff --git a/erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py b/erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py
index e33bd61..eceabf5 100644
--- a/erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py
+++ b/erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py
@@ -195,7 +195,7 @@
 		conditions = [""]
 
 		if self.filters.company:
-			conditions.append("company=%(company)s")
+			conditions.append("gle.company=%(company)s")
 
 		self.filters.company_finance_book = erpnext.get_default_finance_book(self.filters.company)