Dear all.I have set up the assets as recommended on document on asset setup in erpnext but I noticed that the depreciation journal would not be passed on the date set up for it to be passed.
The scheduler is on.When l checked the error log I find the error below:
erpnext.assets.doctype.asset.depreciation.post_depreciation_entries
Error
{‘method_name’: ‘erpnext.assets.doctype.asset.depreciation.post_depreciation_entries’, ‘log’: <function log at 0x7fa3681ca730>, ‘retry’: 0, ‘is_async’: True, ‘user’: ‘Administrator’, ‘kwargs’: {}, ‘job_name’: ‘erpnext.assets.doctype.asset.depreciation.post_depreciation_entries’, ‘event’: ‘daily’, ‘method’: <function post_depreciation_entries at 0x7fa367edbd90>, ‘site’: ‘joenygroup.com’}
Traceback (most recent call last):
File “/home/fred/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 324, in db_insert
), list(d.values()))
File “/home/fred/frappe-bench/apps/frappe/frappe/database/database.py”, line 156, in sql
self._cursor.execute(query, values)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 732, in _read_query_result
result.read()
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 1075, in read
first_packet = self.connection._read_packet()
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.IntegrityError: (1062, “Duplicate entry ‘ACC-JV-2020-00001’ for key ‘PRIMARY’”)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/home/fred/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 99, in execute_job
method(**kwargs)
File “/home/fred/frappe-bench/apps/erpnext/erpnext/assets/doctype/asset/depreciation.py”, line 19, in post_depreciation_entries
make_depreciation_entry(asset, date)
File “/home/fred/frappe-bench/apps/erpnext/erpnext/assets/doctype/asset/depreciation.py”, line 88, in make_depreciation_entry
je.save()
File “/home/fred/frappe-bench/apps/frappe/frappe/model/document.py”, line 273, in save
return self._save(*args, **kwargs)
File “/home/fred/frappe-bench/apps/frappe/frappe/model/document.py”, line 296, in _save
self.insert()
File “/home/fred/frappe-bench/apps/frappe/frappe/model/document.py”, line 248, in insert
raise e
File “/home/fred/frappe-bench/apps/frappe/frappe/model/document.py”, line 245, in insert
self.db_insert()
File “/home/fred/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 334, in db_insert
raise frappe.DuplicateEntryError(self.doctype, self.name, e)
frappe.exceptions.DuplicateEntryError: (‘Journal Entry’, ‘ACC-JV-2020-00001’, IntegrityError(1062, “Duplicate entry ‘ACC-JV-2020-00001’ for key ‘PRIMARY’”))
After I discovered the error,I tried to create another journal number series and default it so that it would no longer pick from existing series that is causing the conflict.Despite this the error persists.
I need help dear friends to resolve this.