AttributeError: 'ERPNextAddress' object has no attribute 'is_your_company_address'

[jameskanyiri]

Information about bug

I am encountering an error while attempting to generate a new customer due to the following attribute problem: AttributeError: The 'ERPNextAddress' object does not possess the attribute 'is_your_company_address'.

Module

selling, manufacturing

Version

frappe version : 5.10.1
Erp version 14

Installation method

manual install

Relevant log output / Stack trace / Full Error Message.

No response

[RicardoTran]

Same issue

[yogeshsomvanshi1]

I am also facing same issue ..
AttributeError: 'ERPNextAddress' object has no attribute 'is_your_company_address'

[s-aga-r]

@jameskanyiri Is Your Company Address is a custom field that gets created on the ERPNext installation. Might be possible somehow it is not created/removed, just check it in Custom Field DocType, and would be better if you share the error log.

[yogeshsomvanshi1]

thanks for response below is error code, ### App Versions ``` { "erpnext": "14.27.10", "frappe": "14.40.0", "hrms": "15.0.0-dev" } ``` ### Route ``` Form/Quotation/new-quotation-1 ``` ### Traceback ``` Traceback (most recent call last): File "apps/frappe/frappe/app.py", line 66, in application response = frappe.api.handle() File "apps/frappe/frappe/api.py", line 54, in handle return frappe.handler.handle() File "apps/frappe/frappe/handler.py", line 47, in handle data = execute_cmd(cmd) File "apps/frappe/frappe/handler.py", line 85, in execute_cmd return frappe.call(method, **frappe.form_dict) File "apps/frappe/frappe/__init__.py", line 1608, in call return fn(*args, **newargs) File "apps/erpnext/erpnext/accounts/party.py", line 75, in get_party_details return _get_party_details( File "apps/erpnext/erpnext/accounts/party.py", line 135, in _get_party_details set_contact_details(party_details, party, party_type) File "apps/erpnext/erpnext/accounts/party.py", line 277, in set_contact_details party_details.contact_person = get_default_contact(party_type, party.name) File "apps/erpnext/erpnext/accounts/party.py", line 926, in get_default_contact contacts = frappe.get_all( File "apps/frappe/frappe/__init__.py", line 1925, in get_all return get_list(doctype, *args, **kwargs) File "apps/frappe/frappe/__init__.py", line 1897, in get_list return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs) File "apps/frappe/frappe/model/db_query.py", line 196, in execute result = self.build_and_run() File "apps/frappe/frappe/model/db_query.py", line 236, in build_and_run return frappe.db.sql( File "apps/frappe/frappe/database/database.py", line 221, in sql self._cursor.execute(query, values) File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute result = self._query(query) File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query conn.query(q) File "env/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result result.read() File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read first_packet = self.connection._read_packet() File "env/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet packet.raise_for_error() File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column 'tabContact.is_billing_contact' in 'where clause'") ``` ### Request Data ``` { "type": "POST", "args": { "party": "Bharat P", "party_type": "Customer", "price_list": "Standard Selling", "posting_date": "2023-06-27", "fetch_payment_terms_template": 1, "currency": "INR", "company": "Excellminds", "doctype": "Quotation" }, "headers": {}, "error_handlers": {}, "url": "/api/method/erpnext.accounts.party.get_party_details" } ``` ### Response Data ``` { "exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'tabContact.is_billing_contact' in 'where clause'\")" } ``` -Yogesh S

…

On Tue, Jun 27, 2023 at 2:15 PM s-aga-r ***@***.***> wrote: @jameskanyiri <https://github.com/jameskanyiri> Is Your Company Address is a custom field that gets created on the ERPNext installation. Might be possible somehow it is not created/removed, just check it in Custom Field DocType, and would be better if you share the error log. [image: image] <https://user-images.githubusercontent.com/63660334/249089620-6ee7206d-1a61-459e-8608-26626d3faaa9.png> — Reply to this email directly, view it on GitHub <#35698 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACMHOVWM3JCF5KF3MW7K2WLXNKMT7ANCNFSM6AAAAAAZGSDMCI> . You are receiving this because you commented.Message ID: ***@***.***>

[yogeshsomvanshi1]

Hi Frappe/Erpnext, I took update of erpnext "bench update " and my problem is solve. Thanks for help. Thanks & Regards -Yogesh S On Tue, Jun 27, 2023 at 2:20 PM yogesh somvanshi ***@***.***> wrote:

…

thanks for response below is error code, ### App Versions ``` { "erpnext": "14.27.10", "frappe": "14.40.0", "hrms": "15.0.0-dev" } ``` ### Route ``` Form/Quotation/new-quotation-1 ``` ### Traceback ``` Traceback (most recent call last): File "apps/frappe/frappe/app.py", line 66, in application response = frappe.api.handle() File "apps/frappe/frappe/api.py", line 54, in handle return frappe.handler.handle() File "apps/frappe/frappe/handler.py", line 47, in handle data = execute_cmd(cmd) File "apps/frappe/frappe/handler.py", line 85, in execute_cmd return frappe.call(method, **frappe.form_dict) File "apps/frappe/frappe/__init__.py", line 1608, in call return fn(*args, **newargs) File "apps/erpnext/erpnext/accounts/party.py", line 75, in get_party_details return _get_party_details( File "apps/erpnext/erpnext/accounts/party.py", line 135, in _get_party_details set_contact_details(party_details, party, party_type) File "apps/erpnext/erpnext/accounts/party.py", line 277, in set_contact_details party_details.contact_person = get_default_contact(party_type, party.name) File "apps/erpnext/erpnext/accounts/party.py", line 926, in get_default_contact contacts = frappe.get_all( File "apps/frappe/frappe/__init__.py", line 1925, in get_all return get_list(doctype, *args, **kwargs) File "apps/frappe/frappe/__init__.py", line 1897, in get_list return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs) File "apps/frappe/frappe/model/db_query.py", line 196, in execute result = self.build_and_run() File "apps/frappe/frappe/model/db_query.py", line 236, in build_and_run return frappe.db.sql( File "apps/frappe/frappe/database/database.py", line 221, in sql self._cursor.execute(query, values) File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute result = self._query(query) File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query conn.query(q) File "env/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result result.read() File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read first_packet = self.connection._read_packet() File "env/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet packet.raise_for_error() File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column 'tabContact.is_billing_contact' in 'where clause'") ``` ### Request Data ``` { "type": "POST", "args": { "party": "Bharat P", "party_type": "Customer", "price_list": "Standard Selling", "posting_date": "2023-06-27", "fetch_payment_terms_template": 1, "currency": "INR", "company": "Excellminds", "doctype": "Quotation" }, "headers": {}, "error_handlers": {}, "url": "/api/method/erpnext.accounts.party.get_party_details" } ``` ### Response Data ``` { "exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'tabContact.is_billing_contact' in 'where clause'\")" } ``` -Yogesh S On Tue, Jun 27, 2023 at 2:15 PM s-aga-r ***@***.***> wrote: > @jameskanyiri <https://github.com/jameskanyiri> Is Your Company Address > is a custom field that gets created on the ERPNext installation. Might be > possible somehow it is not created/removed, just check it in Custom Field > DocType, and would be better if you share the error log. > > [image: image] > <https://user-images.githubusercontent.com/63660334/249089620-6ee7206d-1a61-459e-8608-26626d3faaa9.png> > > — > Reply to this email directly, view it on GitHub > <#35698 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ACMHOVWM3JCF5KF3MW7K2WLXNKMT7ANCNFSM6AAAAAAZGSDMCI> > . > You are receiving this because you commented.Message ID: > ***@***.***> >