Fixed Assets Depreciation hangs on GP 2010
Recently I had encountered an issue while depreciating fixed assets in Dynamics GP 2010. The system hangs for a while and only option was to kill the dynamics.exe from the task manager. I found that there is an issue with assets for which depreciation is less than 0.01.
What I did was to run the following statement first in SQL server to get rid of the current depreciation run after taking a backup of data.
DELETE FA01500
DELETE FA41900
DELETE FA40203
DELETE FAINDEX
Then, I set those penny assets depreciation method to None from straight line original life method. Now, ran the depreciation routine and it worked like a charm.