Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
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?  

Categories:
  • 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans