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) / fixed asset depreciati...
Microsoft Dynamics GP (Archived)

fixed asset depreciation report

(0) ShareShare
ReportReport
Posted on by Rachel Nusbaum 2,935

My client wants to be able to run a smartlist showing depreciation for the period jan-dec 2012.  She is on GP2010.  I just want to verify that this is not possible until they upgrade to GP2013?

Thx

Rachel

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    sueconrod Profile Picture
    sueconrod 337 on at

    If you have smartlist builder you can easily create this report.  Basically you take the FA00902 (lists all the assets and the depreciation) and the FA00100 (basically the Asset General Card) and do a join on the field AssetIndex.  Then you can run the report and get the depreciation for all years and all periods.  I usually then take this report and do a pivot table on it and have the months on top and the asset in the row and then it shows you all the depreciation from the beginning of time.  

    If you don't have SmartList buildiner if you have Excel and can go to your database again, go out to the two tables and grab the information and then do a vlookup on the Asset General informaiton and bring in the information that you need to add to the FA00902 table to make it readable by your customer.  

    This has always been available, just took a little effort.  I used to dump this out for all my customers who had Fixed Assets once they had closed the year end so that they had this information for their auditors.  

  • sueconrod Profile Picture
    sueconrod 337 on at

    Once you have dumped the transactions, you will want to only look at the FADEP-0 transactions, but now you have all activity that has been done on all your transactions...

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
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans