Open Forum

Expand all | Collapse all

Depreciation will not run

  • 1.  Depreciation will not run

    SILVER CONTRIBUTOR
    Posted Apr 11, 2019 01:42 PM
    ​I setup a new company and am now running depreciation on the fixed assets for the first time.  I have access to the depreciate button but when I run depreciation it appears as if it is running but goes very fast and does nothing.  I already verified my target date is within my fiscal year and that is also correct, my FA calendar and quarters are correct and tried rebuilding just in case.  I checked the SQL table FA40203 to make sure the table is not locked.  I am not receiving any error messages.  I am on GP2016R2.  Any ideas?
    Thanks,
    Susan

    ------------------------------
    Susan Ferrian
    Guardian Angels of Elk River (GAER)
    Elk River MN
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: Depreciation will not run

    GOLD CONTRIBUTOR
    Posted Apr 11, 2019 02:35 PM

    Hi Susan,

    Here are some items to check (in case you haven't yet):

    1. Do you see records in the Financial Detail Inquiry (Inquiry >> Fixed Assets >> Financial Detail) for the affected Asset ID / Asset Book? Alternatively, you can check on the FA00902 table and see if it's populated. In the sample script below, replace "enter_asset" with the asset ID in review:

      select ASSETID, * from FA00902 a
      inner join FA00100 b on a.assetindex = b.assetindex
      where ASSETID = 'enter_asset'

    2. Are you able to the asset records in the Asset Book window (Cards >> Fixed Assets >> Book)? Maybe the asset has not yet been assigned to an asset book.

      select ASSETID, * from FA00200 a
      inner join FA00100 b on a.assetindex = b.assetindex
      where ASSETID = 'enter_asset'
    3. You might also want to check if the Averaging Convention is not set to "None".


    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------

    GPUG Summit - Post


  • 3.  RE: Depreciation will not run

    TOP CONTRIBUTOR
    Posted Apr 11, 2019 03:29 PM
    I might recommend running project as of the same date to see if any records appear.  If not, project for a much further period (maybe to end of fiscal year).  If you get records for much further period, it's possible you've already depreciated or the averaging convention is factoring in an unexpected manner.

    ------------------------------
    Kyle Malone, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - http://ALaCarteGP.com
    Chapter Leader - Louisiana (New Orleans)
    ------------------------------

    GPUG Summit - Post


  • 4.  RE: Depreciation will not run

    SILVER CONTRIBUTOR
    Posted Apr 12, 2019 03:50 PM
    ​Thank you Kyle.  This issue was that I had not built any historical years in my fixed asset calendar.  I really don't understand why that would be an issue but I did that and it works.
    Thanks,
    Susan

    ------------------------------
    Susan Ferrian
    Guardian Angels of Elk River (GAER)
    Elk River MN
    ------------------------------

    GPUG Summit - Post


  • 5.  RE: Depreciation will not run

    GOLD CONTRIBUTOR
    Posted Apr 11, 2019 07:27 PM
    Hi Susan,

    Thanks for the update.

    If rebuilding the FA Calendar took care of the issue - then that would either mean that it wasn't setup completely (i.e. the years that are to be referenced aren't in the system yet / FA42100) or it was damaged.

    As per the KB below:
    https://support.microsoft.com/en-ph/help/874133/how-to-rebuild-the-fixed-assets-calendar-in-microsoft-dynamics-gp

    ... Steps to rebuild the Fixed Assets calendar can be used as part of the troubleshooting steps for several problems in Fixed Assets. If the Fixed Assets calendar becomes damaged or the Fiscal Period calendar is rebuilt in General Ledger, the FA calendar has to be rebuilt...




    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------

    GPUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role