Fixed Asset ID Missing in Dynamics GP 2010

I recently helped a client that reported that one of their Asset ID’s had disappeared in GP 2010.  As I helped them with this issue I wanted to accomplish two goals: 

1.     Restore the missing information,

2.     And determine what may have caused the issue. 

It turns out that I was able to discover the cause of the issue first.  I found Microsoft Support Article 863680 that outlined the following series of steps which, in Great Plains 8.0, would result in a missing asset ID:

1.    Go into SmartList.

2.     Click on the Fixed Assets SmartList.

3.     Double-click on an asset to drill back to the Asset General Information.

4.     Toggle back to SmartList.

5.     Double-click on the same asset. The asset ID will be missing. If you click Save, the asset is saved without an asset ID.

I replicated these steps and their results in Fabrikam in Dynamics GP 2010.

I then identified the following sequence of steps that could be used from the Dynamics GP interface to re-establish the missing asset id:

1.       Ensure that all current Fixed Asset activity has been interfaced to the General Ledger.

2.       Record all relevant details regarding the asset, needed to recreate it.

3.       Use the “Delete” utility in Fixed Assets to delete the asset with the missing ID.

4.       Recreate the asset and re-run depreciation to the same fiscal period it was previously depreciated to. 

5.       Run the Fixed Assets General Ledger Posting routine but delete the resulting GL batch containing the addition and depreciation transactions for this asset that were already posted.

The client performed these steps and reported back that the results were what they expected.  There may be alternate methods for addressing the issue of a missing asset ID but my client was content with this sequence because they could perform all the steps themself. 

My final word on this matter is a warning, be aware when you open asset cards via SmartList!

Sheldon Gitzel, ERP Consultant for Etelligent Solutions

www.esicanada.com