[SOLVED] [V7] POS not working after V7 Upgrade

Traceback (most recent call last):
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py”, line 55, in application
response = frappe.handler.handle()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py”, line 36, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 879, in call
return fn(*args, **newargs)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/sales_invoice/pos.py”, line 27, in get_pos_data
update_multi_mode_option(doc, pos_profile)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/sales_invoice/pos.py”, line 75, in update_multi_mode_option
for payment in get_mode_of_payment(doc):
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/sales_invoice/pos.py”, line 94, in get_mode_of_payment
tabMode of Payment mp where mpa.parent = mp.name and company = %(company)s""", {‘company’: doc.company}, as_dict=1)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py”, line 137, in sql
self._cursor.execute(query, values)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1052, “Column ‘company’ in where clause is ambiguous”)

I get this when I click on the POS module.

Hi @Justin_Lu,

Thanks for reporting an issue, we have fixed the issue and we’ll release it soon.

Thanks, Rohit