commit a6c6e02c492568b65fe910a1f15966ae29d1e3cf
author Anastes Mp <foranastes@gmail.com> Wed Aug 21 16:53:06 2019 +0530
committer Nabin Hait <nabinhait@gmail.com> Wed Aug 21 16:53:06 2019 +0530
tree 9e571ba4d72735cec152257f7cae44d900f3a051
parent 109a07b8344df9c2420c2cea7f9bd6419284c920

Incorrect database table (#18558)

Fixed Unknow Column tax_type error on offline pos

erpnext/accounts/doctype/sales_invoice/pos.py

diff --git a/erpnext/accounts/doctype/sales_invoice/pos.py b/erpnext/accounts/doctype/sales_invoice/pos.py
index e2f99d6..479548c 100755
--- a/erpnext/accounts/doctype/sales_invoice/pos.py
+++ b/erpnext/accounts/doctype/sales_invoice/pos.py
@@ -307,7 +307,7 @@
 	# example: {'Consulting Services': {'Excise 12 - TS': '12.000'}}
 
 	itemwise_tax = {}
-	taxes = frappe.db.sql(""" select parent, tax_type, tax_rate from `tabItem Tax`""", as_dict=1)
+	taxes = frappe.db.sql(""" select parent, tax_type, tax_rate from `tabItem Tax Template Detail`""", as_dict=1)
 
 	for tax in taxes:
 		if tax.parent not in itemwise_tax: