• From: Kenya
  • Registered: 11/21/2017
  • Posts: 34

Topic: How to run depreciation for all assets

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: How to run depreciation for all assets

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.

apmuthu's Website

  • From: Kenya
  • Registered: 11/21/2017
  • Posts: 34

Re: How to run depreciation for all assets

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.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: How to run depreciation for all assets

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

@joe: ??

apmuthu's Website

  • From: Kenya
  • Registered: 11/21/2017
  • Posts: 34

Re: How to run depreciation for all assets

Dear Amputhu,

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

Thanks,

Mugao

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: How to run depreciation for all assets

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.

apmuthu's Website

  • From: Kenya
  • Registered: 11/21/2017
  • Posts: 34

Re: How to run depreciation for all assets

How is that a solution seriously?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: How to run depreciation for all assets

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.

apmuthu's Website

  • From: Kenya
  • Registered: 11/21/2017
  • Posts: 34

Re: How to run depreciation for all assets

Thank you Amputhu,

Much appreciated.

Regards, Mugao.

  • From: Costa Rica
  • Registered: 09/04/2017
  • Posts: 3

Re: How to run depreciation for all assets

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