I am creating a Purchase Invoice, when i select the "Credit To", this is the error that i am getting : "None does not have an Account Head in BusinessClouds. You must first create it from the Supplier Master"
Traceback :
Traceback (innermost last): File "lib/webnotes/handler.py", line 78, in handle execute_cmd(cmd) File "lib/webnotes/handler.py", line 118, in execute_cmd ret = call(method, webnotes.form_dict) File "lib/webnotes/handler.py", line 140, in call return fn(**newargs) File "lib/webnotes/handler.py", line 22, in runserverobj webnotes.widgets.form.run_method.runserverobj() File "lib/webnotes/widgets/form/run_method.py", line 40, in runserverobj r = webnotes.model.code.run_server_obj(so, method, arg) File "lib/webnotes/model/code.py", line 102, in run_server_obj return getattr(server_obj, method_name)() File "app/accounts/doctype/purchase_invoice/purchase_invoice.py", line 85, in set_supplier_defaults super(DocType, self).set_supplier_defaults() File "app/utilities/transaction_base.py", line 129, in set_supplier_defaults for fieldname, val in self.get_supplier_defaults().items(): File "app/utilities/transaction_base.py", line 117, in get_supplier_defaults out = self.get_default_address_and_contact("supplier") File "app/utilities/transaction_base.py", line 20, in get_default_address_and_contact fetch_shipping_address=True if self.meta.get_field("shipping_address_name") else False) File "app/utilities/transaction_base.py", line 314, in get_default_address_and_contact billing_address = get_default_address(party_field, party_name) File "app/utilities/transaction_base.py", line 345, in get_default_address limit 1""" % (party_field, "%s", order_by), party_name) File "lib/webnotes/db.py", line 96, in sql self._cursor.execute(query, values) File "/home/user/erpnext/lib/python2.7/site-packages/MySQLdb/cursors.py", line 201, in execute self.errorhandler(self, exc, value) File "/home/user/erpnext/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s order by is_primary_address desc, name asc\n\t\tlimit 1' at line 1")