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

Topic: Fixed Assets Depreciation customization

Hello FA team,
I am looking for a developer to customize fixed assets in order to depreciate all the assets with one click. currently the user has to depreciate one asset at a time.

Reach me on gmail using mwitimugao@gmail.com.

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

Re: Fixed Assets Depreciation customization

1. Take a FA sql backup
2. Make one depreciation entry manually in FA.
3. Take another sql backup.
4. Check what has changed between the two backups.
5. Construct similar sql entries for all your assets that need depreciation.
6. Execute the set of depreciation sql entries in one go in any MySQL client like phpmyadmin, sqlyog, etc.

Provide feedback on your experience here so that a menu item can be made to provide for depreciation on single click of selected asset entries.

apmuthu's Website

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

Re: Fixed Assets Depreciation customization

Thank you,

I will get back with the results