Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Fixed asset depreciated .05 more than the cost - has negative net book value

Posted on by 250

An active fixed asset is fully depreciated but it depreciated .05 more than the cost, leaving a -.05 as the net book value.

What's the best way to update the net book value to zero?  

  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at
    RE: Fixed asset depreciated .05 more than the cost - has negative net book value

    Try the following (in test first of course to ensure results are as desired)

    https://support.microsoft.com/en-us/topic/kb-set-up-a-test-company-that-has-a-copy-of-live-company-data-for-microsoft-dynamics-gp-by-using-microsoft-sql-server-6199295b-fc49-d963-3865-2d24a4b49211

    1. Go to the asset book record (Cards>Fixed Assets>Book).
    2. Take note of the Yearly Depreciation Rate"
    3. Does this match the current YTD depreciation?
    4. Next we need to decide if we are going to have FA show the difference at the end of the previous year.
      1. If you want to book the change at the end of the previous year, just adjust the LTD depreciation down the over depreciation (will book to last day of the previous year).
      2. If you want it to book in the current year, you will also need to reduce the YTD depreciation. This is where our check on YTD depreciation vs yearly depreciation rate comes in. If we reduce the YTD depreciation and it is less than the yearly depreciation rate we can wind up in a situation where it will try to take the difference again. If the YTD and yearly rate will not be the same, you may also want to set depreciation method to No Depreciation (when you save this will cause the recalc\reset window to come up and you would want to select recalc instead of one of the two reset options).
    5. Finally save the change (and select recalc instead of a reset depending on what you did above in step 4).
    6. Interface the transaction to GL on whatever date needed.
    7. If everything is correct, you can then backup live and repeat the solution.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans