tracking code
LBMC Technology Solutions
  • Home
  • Solutions
    • Dynamics 365
    • Dynamics NAV
    • Dynamics GP
    • Dynamics CRM
    • Sage Intacct
    • Document Management (ECM)
    • Network Engineering and IT Solutions >
      • IT Security
      • Managed IT
      • Business Phone Systems
  • Events
    • All Upcoming Events
    • Training / CPE
    • Webinars and Workshops
  • Resources
    • Blog
    • Forum
    • On-Demand Webinars
    • Referral Program
    • Services We Offer
    • Support
  • About Us
    • Careers
    • Partner with Us
    • Community
    • Contact Us

Some Fixed Assets pointers

5/28/2014

 
Posted by Lise' Cummings
While working on an issue with a GP client the other day, I learned a few things about Fixed Assets that I did not know and thought they may be helpful to some of you. 

​The client was changing their Fiscal Period setup to coincide with the calendar year and since the current Fiscal Year ran from 11/01 to 10/31 they extended the 2013 year to 14 periods from 12 periods.  Unbeknownst to them that Fixed Assets calculated depreciation on 12 periods. 
Picture
The first issue they encountered after changing the fiscal period setup was that they needed to rebuild the Fixed Assets calendar to be based on 14 periods, which they did when they got the error.  What they did not know was that Fixed Assets was still going to calculate depreciation based on the current year depreciation amount found on the asset book window (which was calculated using 12 periods).  When they ran their depreciation they found that most all of their assets had a credit amount for the 14th period of depreciation.  The reason this happened was because when the Fixed Assets calendar was rebuilt based on 14 periods the assets should have been recalculated so that the current year depreciation amount would have been calculated based on 14 periods and because it was not the system was making the adjustment for the total amount of depreciation it had already calculated for period 1-13. 

The client then wanted to know if they could back out that month’s depreciation.  I knew that on GP 2010 and prior versions there was not a check box that would allow you to undo depreciation, but on GP 2013 that is a new feature.  Unfortunately, they were on GP 2010 so I did some research just to see if I could find anything that would be helpful. 

I found an article that said you could undo depreciation by using the following method:  Under Fixed Assets Routines go to the Depreciate One Asset window and enter an asset id.  Then enter the previous month’s depreciation target date into the Depreciation Target Date field.  In this case, they wanted to back out December depreciation so they would enter November as the target date.  Next highlight the book that needs the correction made and then click the Depreciate button.  You will get the following message:
The Target Date you have entered is before the Depreciated to Date for this Asset. Should you continue, depreciation will be backed out. Do you want to continue? 

​When you select yes, depreciation will be backed out for December (in this case).  When the GL interface is done a reversing entry is what is created to back out the original entry so that the General Ledger will be balanced to Fixed Assets again.  At this point the assets can be recalculated so the depreciation rate will then reflect 14 periods and depreciation can be reran.

Pointers to remember:

  1. When you extend your Fiscal Periods to be more than what your current periods are make sure you rebuild the Fixed Assets Calendar to match and synchronize your quarters for the year.
  2. Under Fixed Assets Transactions go to the Mass Asset Change window and go to the Book tab and perform the Recalc Remaining so that the depreciation amount will be reflected correctly for remaining depreciation that needs to be ran.
  3. You can undo depreciation using the method above, but it is a one asset at a time procedure.
ERP Guide

Comments are closed.


    Blog

    ​Your one stop shop for technology.

    Categories

    All
    Business Central
    Dynamics 365
    Dynamics CRM
    Dynamics GP
    Dynamics NAV
    Events
    Microsoft Dynamics Add-ons
    Software Decisions
    Tutorial

Solutions
Microsoft Dynamics 365
    Business Central
    Customer Engagement
Microsoft Dynamics NAV
Microsoft Dynamics GP
​Microsoft Dynamics CRM
​Sage Intacct
​
Network Engineering

​ERP Comparison Guide
Learning Opportunities
All Upcoming Events
User Conferences
Training / CPE
Vision
Webinars & Workshops
​

Resources
Blog
Forum
Referral Program
​​YouTube Channel

Company
About Us
Careers
Contact Us
​
Locations
Charlotte
Knoxville
Nashville
Picture
Picture
Proudly powered by Weebly

Sitemap | Home | Careers | Contact Us

share

Copyright © 2019

LBMC Technology Solutions