FrontAccounting forum — How to run depreciation for all assets

Re: How to run depreciation for all assets

null@example.com (jhernandezmyh) — Thu, 29 Jul 2021 03:31:37 +0000

Good evening, has there been any news with this problem?

Re: How to run depreciation for all assets

null@example.com (mugao-em) — Tue, 05 Feb 2019 06:06:02 +0000

Thank you Amputhu,

Much appreciated.

Regards, Mugao.

Re: How to run depreciation for all assets

null@example.com (apmuthu) — Tue, 05 Feb 2019 03:12:11 +0000

It is not a solution. It will provide inputs to make an extension to accommodate it as a functionality even possibly in the core, whilst providing you a means of quickly getting the work done in the meanwhile.

Re: How to run depreciation for all assets

null@example.com (mugao-em) — Mon, 04 Feb 2019 10:59:16 +0000

How is that a solution seriously?

Re: How to run depreciation for all assets

null@example.com (apmuthu) — Mon, 04 Feb 2019 10:12:16 +0000

1. Take a backup 1.
2. Make one depreciation entry manually.
3. Make a list of all other assets you wish to depreciate in a similar manner.
4. Take backup 2.
5. Compare backup 1 and backup 2 and see what SQLs are needed to arrive at the latter from the former.
6. Make such SQL statements for other similarly depreciable items and execute it enblock
7. If anything breaks, revert to either backup 2 or 1 as appropriate.

Re: How to run depreciation for all assets

null@example.com (mugao-em) — Mon, 04 Feb 2019 10:02:57 +0000

Dear Amputhu,

Hope you are well, has this issue been worked on. Its very tedious depreciating many assets one by one?

Thanks,

Mugao

Re: How to run depreciation for all assets

null@example.com (apmuthu) — Mon, 19 Feb 2018 14:22:19 +0000

Possibly a depreciation class to which each asset can pertain....

@joe: ??

Re: How to run depreciation for all assets

null@example.com (mugao-em) — Mon, 19 Feb 2018 09:38:11 +0000

Dear Apmuthu,
Thank you for the feedback.
Ofcourse your suggestion will work, but it will ignore most validations that are being done at the front end.
Please consider adding this feature, it will be very helpful to companies having many assets as most would not want to give users back end access.

Thank you in advance.

Re: How to run depreciation for all assets

null@example.com (apmuthu) — Wed, 14 Feb 2018 15:43:54 +0000

Take a backup.
Enter one such depreciation record.
Take another backup and see what SQL INSERTs/ UPDATEs are needed.
Restore from first backup.
Make SQL statements for all depreciations and then import them into the DB.

How to run depreciation for all assets

null@example.com (mugao-em) — Wed, 14 Feb 2018 12:54:41 +0000

HI, i am using FA 2.4.3. Is it possible to depreciate all assets at once for a given period ?
Regards,
Mugao