Automatic Depreciation of fixed Assets

ERPNext User Forum
1

Hi,

I have been trying to get the automatic depreciation function for fixed assets working for a few days. Unfortunately, I have not been successful, Im not sure what I’m doing wrong.

When I looked at the error log created from the background jobs, I get the following error, can someone please help decode this error.

Thanks in advance.

13-11-2019 00:00:57

failed
erpnext.assets.doctype.asset.depreciation.post_depreciation_entries

Traceback (most recent call last):
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/rq/worker.py”, line 793, in perform_job
rv = job.perform()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/rq/job.py”, line 599, in perform
self._result = self._execute()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/rq/job.py”, line 605, in _execute
return self.func(*self.args, **self.kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 103, in execute_job
method(**kwargs)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/assets/doctype/asset/depreciation.py”, line 18, in post_depreciation_entries
make_depreciation_entry(asset, date)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/assets/doctype/asset/depreciation.py”, line 75, in make_depreciation_entry
finance_books = asset.get(‘finance_books’)[idx - 1]
IndexError: list index out of range

2

Hi,

Anyone who can help me with this error please?

Thanks.

3

Please post some screen shot to understand the issue better. Are you trying to do back dated entry? It will not work. Give a future date for system to pass entry. Next day would be fine.

4

Hi Muzzy,
Please find a screen shot of one asset that was purchased previously but depreciation started last week. i set this date before 11-11-2019. However the system didn’t auto depreciate as you can see from the table below.

image
image1167×933 32.6 KB

This is another asset i created with a more recent purchase date. That also didn’t depreciate.

image
image1080×938 32.3 KB

Both above assets were created before 11-11-2019

5

Hi,
I really appreciate it if anyone is able to help me on this issue.

Thanks.

6

Hi Everyone,

Just to update this thread with a possible solution.

After much experimenting, I figured out that if you export the data of the “Assets” there are 2 columns with the date field. even though I changed the date of the depreciation start date, the downloaded data revealed a previous date. (in my case).

So I changed the date in the exported data to a future date and imported it back to the assets module. Now suddenly the depreciation with a future date is working fine.

Hope this helps anyone with a similar problem.

2 Likes