Hi,
I was trying to add new employees. But it always shows like Employee EMP0001 is already exist. I am not able add new employees.
Here i am attaching the screenshot of the error getting.
Please help me to solve this.
Thanks and regards
Hello @rajeeb,
Can you please share the version of erpnext and frappe?
Does this occur everytime when you create a new employee?
Thanks & Regards,
Kalpit
@Shah_Kalpit Yes it occurs every time only for this series (EMP.####). Version is ERPNext: v11.1.33 Frappe Framework: v11.1.30
It works fine in mine. Have you changed anything in it?
@Shah_Kalpit I have imported some employee data by excel with employee numbers (Eg : EMP0001, EMP0002, EMP0003ā¦) which is in the same naming series.
Okay, Check tabSeries table in database and check the value of EMP.
You might have to update the number (count) of the employee in current field of tabSeries.
Check it out and revert back! @rajeeb
You can set it form naming series.
Search Naming Series in Awesomebar.
Select transaction, prefix and current value .
Then click on update series number
it will be fixed
3 Likes
check with this
@winter_wolf i tried but iām getting error
Traceback (most recent call last):
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 61, in application
response = frappe.handler.handle()
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 21, in handle
data = execute_cmd(cmd)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 56, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/__init__.py", line 1032, in call
return fn(*args, **newargs)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 84, in runserverobj
frappe.desk.form.run_method.runserverobj(method, docs=docs, dt=dt, dn=dn, arg=arg, args=args)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/run_method.py", line 36, in runserverobj
r = doc.run_method(method)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py", line 772, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py", line 1048, in composer
return composed(self, method, *args, **kwargs)
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py", line 1031, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py", line 766, in <lambda>
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File "/home/ubuntu/frappe-bench/apps/erpnext/erpnext/setup/doctype/naming_series/naming_series.py", line 162, in update_series_start
(self.current_value, prefix))
File "/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py", line 199, in sql
self._cursor.execute(query, values)
File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
IntegrityError: (1048, u"Column 'current' cannot be null")
This is something which has gone wrong (Individual).
While creating new Employee, there is a Series which contains EMP.#### in yours. This needs to be changed.
It should be EMP (Select Option Value) in it.
Can you please describe what have you done in brief? @rajeeb
@Shah_Kalpit I wanted to import the list of employees with employee number which i already have. So i imported all employees using an excel sheet. When i added Employee number is coming like EMP00050001,EMP00060002,EMP00060002ā¦ ( means collaborating with naming series ). So i removed EMP.#### naming series and imported data again. Then it came like EMP00050001,EMP00060001,EMP00060001ā¦ Finally i renamed all employees from EMP00050001 to EMP0005. This is what i have done.
