Menu
GP

I Can't Run Depreciation in Dynamics GP!

Here is something that I see from clients occasionally. Scenario: User goes to the ‘Depreciate’ Window (Routines > Fixed Assets > Depreciate) to process depreciation of fixed assets. However, upon arriving at the window, they see the ‘Depreciate’ button unavailable.

Typically one of two things have occurred to get us into this situation. Either there was an unusual termination of GP while on the depreciation window, or the window was closed before the process could run to completion.

Not to worry, there is an easy solution (if you have access to SQL Management Studio).

Issue: Depreciation Button is unavailable

 

Depreciation Button Unavailable

 

As you can see, even though all required information is selected on the window, the ‘Depreciate’ button is not available.

 

Depreciation Button

 

  1. Remove the hung record(s) from the table

*Is it always advisable to have a restorable backup of the company DB before making changes to data*

Example Script:

DELETE from TWO..FA40203 WHERE DEX_ROW_ID = '2003'            

  • Note that sample database ‘TWO’ is used in this example. Substitute ‘TWO’ for the database name.
  • Additionally, substitute the DEX_ROW_ID that is returned in the first script.
  1. Close and Reopen the Depreciate Window in Dynamics GP

Verify that the ‘Depreciate’ button is now available.

 

 

Tip to prevent this behavior:

When running depreciation, make sure the progress bar is completely finished and the ‘Depreciate’ button is available again before you close the window.

Search in All Title Contents
2018 Dec  9  5
2018 Nov  34  7
2018 Oct  45  4
2018 Sep  36  3
2018 Aug  48  5
2018 Jul  19  5
2018 Jun  48  6
2018 May  33  5
2018 Apr  315  6
2018 Mar  78  7
2018 Feb  42  5
2018 Jan  101  5
2017 Dec  89  9
2017 Nov  40  6
2017 Oct  73  8
2017 Sep  31  5
2017 Aug  152  11
2017 Jul  165  9
2017 Jun  121  11
2017 May  242  10
2017 Apr  28  6
2017 Mar  295  9
2017 Feb  153  11
2017 Jan  420  11
2016 Dec  166  10
2016 Nov  132  12
2016 Oct  20  11
2016 Sep  32  15
2016 Aug  33  16
2016 Jul  28  11
2016 Jun  35  12
2016 May  30  20
2016 Apr  35  5
2016 Mar  21  10
2016 Feb  44  3
2016 Jan  6  4