Customer Name is not Unique

NCP · March 4, 2024, 5:24am

When naming customers, if you enter a name that’s already used, It will add a hyphen and a number after the name to differentiate it.

github.com

frappe/erpnext/blob/develop/erpnext/selling/doctype/customer/customer.py#L108-L132


      
          	def get_customer_name(self):
          
          		if frappe.db.get_value("Customer", self.customer_name) and not frappe.flags.in_import:
          			count = frappe.db.sql(
          				"""select ifnull(MAX(CAST(SUBSTRING_INDEX(name, ' ', -1) AS UNSIGNED)), 0) from tabCustomer
          				 where name like %s""",
          				"%{0} - %".format(self.customer_name),
          				as_list=1,
          			)[0][0]
          			count = cint(count) + 1
          
          			new_customer_name = "{0} - {1}".format(self.customer_name, cstr(count))
          
          			msgprint(
          				_("Changed customer name to '{}' as '{}' already exists.").format(
          					new_customer_name, self.customer_name
          				),
          				title=_("Note"),
          				indicator="yellow",
          				alert=True,

This file has been truncated. show original

If you’re using the naming series, you’ll need to include a validate method and adjust it accordingly.

I hope this helps.

Thank You!