web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Retired Asset still sh...
Microsoft Dynamics GP (Archived)

Retired Asset still showing LTD Depreciation on Smartlist/Data Connections

(0) ShareShare
ReportReport
Posted on by jenasiis 114

We sold/retired one of our assets last year, yet it is still showing a LTD Depreciation amount on any Smartlists or Excel reports we run from GP. Is there any way to remove this? Currently we have to manually delete that row anytime we want to review and balance to GL totals.

Thanks in Advance!

Jena

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Jena,

    I think the default SmartList shows by default the retired assets as well (though I need to validate that).

    has created a view to use within Excel or SmartList Builder/Designer to show the Assets depreciation, in which you could just add a condition to filter out the retired ones..

    https://victoriayudin.com/2011/02/15/yearly-fixed-assets-depreciation-totals-in-dynamics-gp/

  • bacccpa Profile Picture
    bacccpa 5 on at

    I am having this same problem.   

    After retiring an asset, the Cost Basis shows 0.00, but the LTD Depreciation Amount still shows up on a SmartList report.   

    The only solution that I have discovered is to Delete the Asset ID from the system using Financial>>>Utilities>>>Fixed Assets>>>Delete.    Each Asset ID must be deleted individually. 

    Is there another way?

    Mary

  • DebraH Profile Picture
    DebraH 30 on at

    I have the same issue! Has anyone resolved this? Why does the cost come out but not the depreciation? 

  • Suggested answer
    RobertShap Profile Picture
    RobertShap 125 on at

    You need to include the Asset General Information master table. That way you can search on the asset status field for assets that are not retired. Use either the SmartList Designer or the Smartlist Builder to build a new SmartList.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans