Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

fixed asset depreciation report

(0) ShareShare
ReportReport
Posted on by 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

  • sueconrod Profile Picture
    sueconrod 335 on at
    RE: fixed asset depreciation report

    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...

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    RE: fixed asset depreciation report

    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.  

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans