Failing to import customers (Willing to pay for the assistance)

Am trying to import new customers into ERPNext and is showing that error anyone who can assist?

Showing this error

Traceback (most recent call last):
File “apps/frappe/frappe/core/doctype/data_import/importer.py”, line 126, in import_data
doc = self.process_doc(doc)
File “apps/frappe/frappe/core/doctype/data_import/importer.py”, line 194, in process_doc
return self.insert_record(doc)
File “apps/frappe/frappe/core/doctype/data_import/importer.py”, line 213, in insert_record
new_doc.insert()
File “apps/frappe/frappe/model/document.py”, line 240, in insert
self.run_before_save_methods()
File “apps/frappe/frappe/model/document.py”, line 971, in run_before_save_methods
self.run_method(“validate”)
File “apps/frappe/frappe/model/document.py”, line 869, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 1161, in composer
return composed(self, method, *args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 1144, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “apps/frappe/frappe/model/document.py”, line 863, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “apps/erpnext/erpnext/selling/doctype/customer/customer.py”, line 75, in validate
validate_party_accounts(self)
File “apps/erpnext/erpnext/accounts/party.py”, line 328, in validate_party_accounts
validate_party_gle_currency(doc.doctype, doc.name, account.company, party_account_currency)
File “apps/erpnext/erpnext/accounts/party.py”, line 302, in validate_party_gle_currency
party_account_currency = get_party_account_currency(party_type, party, company)
File “apps/erpnext/erpnext/accounts/party.py”, line 275, in get_party_account_currency
return frappe.local_cache(“party_account_currency”, (party_type, party, company), generator)
File “apps/frappe/frappe/init.py”, line 1644, in local_cache
local.cache[namespace][key] = generator()
File “apps/erpnext/erpnext/accounts/party.py”, line 272, in generator
party_account = get_party_account(party_type, party, company)
File “apps/erpnext/erpnext/accounts/party.py”, line 244, in get_party_account
group = frappe.get_cached_value(party_type, party, scrub(party_group_doctype))
File “apps/frappe/frappe/init.py”, line 863, in get_cached_value
doc = get_cached_doc(doctype, name)
File “apps/frappe/frappe/init.py”, line 848, in get_cached_doc
doc = get_doc(*args, **kwargs)
File “apps/frappe/frappe/init.py”, line 891, in get_doc
doc = frappe.model.document.get_doc(*args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 75, in get_doc
return controller(*args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 113, in init
self.load_from_db()
File “apps/frappe/frappe/model/document.py”, line 156, in load_from_db
frappe.throw((“{0} {1} not found”).format((self.doctype), self.name), frappe.DoesNotExistError)
File “apps/frappe/frappe/init.py”, line 444, in throw
msgprint(msg, raise_exception=exc, title=title, indicator=‘red’, is_minimizable=is_minimizable, wide=wide, as_list=as_list)
File “apps/frappe/frappe/init.py”, line 423, in msgprint
_raise_exception()
File “apps/frappe/frappe/init.py”, line 378, in _raise_exception
raise raise_exception(msg)
frappe.exceptions.DoesNotExistError: Customer Joyce Chara not found

If you’re importing a record which links to a customer which should also be created through this sheet then, try removing it for once and import without that column

have checked that , every record that links it to this is there and there are only three data fields l am dealing with , customer name , customer group and territory

What about some before save customization, like get party account or any other customization?

1 Like

Thank you very much you are life saver it had worked l wasn’t putting all mandatory fields